An Excel macro is an action or a set of actions that you can record, give a name, save and run as many times as you want and whenever you want. Macros help you to save time on repetitive tasks involved in data manipulation and data reports that are required to be done frequently.
To perform a macro, one needs to record a macro using the following steps.
Step 1: Open Excel. Then go to File tab and select options bar.
Step 2: Select customize ribbon option and make sure developer checkbox is selected.
Step 3: Select Ok . Developer menu will appear in the ribbon.
Step 4: Select Developer tab and click on record macro. It will start recording a macro. It will then record the various steps. Click on stop recording to stop recording a macro.
Step 5: A new dialog box will open. Select the name of the macro and assign a shortcut key for the macro. You can use current workbook, new workbook , or personal macro workbook to store the macro. Click Ok to continue.