Macro in Excel

Prev Tutorial Next Tutorial

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.
macros in excel

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.

record macros in excel

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:

stop macros recording in excel

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:

run macros recording in excel
Prev Tutorial Next Tutorial

Download Projects

Google Adsense Advertisements
Free Classified Site – Bedpage

Yahoo Advertisements