Macro in Excel
How to Use Macro in Excel
By using Macro you can record your activity or task. It is very useful when you have a task that you need to perform repeatedly.
Step to Use Macro
- Click on View Tab
- On the right end of the Ribbon you get macro button.
- Click on the arrow shown at the bottom of macro button.
- Here you get three option; view macros, record macro and use relative references.
View Macro: Clicking on view macro option open macro dialog box where we can run, edit or delete a macro.
Record Macro: Click on this option to record macro. On clicking, it displays the record macro dialog box where we can fill the details of your macro.
Use Relative Reference: This option help record macro in relative mode. Using relative mode we can run the recorded data anywhere on the worksheet.
Steps to record a macro
Click on the Record Macro option. It will display the macro dialog box you need to fill the details of macro then click ok. See in the below image.
When recording done, click on the arrow below the macro button it will display three options, out of these options select stop recording. See in the below image:
Now the macro is created and is ready to use, to run the macro click on the Macro button click on View Macro option; it will display the dialog box with multiple options like Run, Edit and Delete. Click on the Run option, it will display the recorded task. See in the below image: