Javatpoint Logo



Javatpoint Logo

Excel Macros

By using Macro we can record a task. It is very useful when you have a task that you need to perform repeatedly. It speeds up the procedure and assures accuracy.

How to open a macro:

Open View tab. On the right end of the Ribbon you will find the macro button.

Click on the arrow shown at the bottom of macro button. It will display three options; view macros, record macro and use relative references. See the image:

Macros in Excel 1

View Macro: Clicking on view macro option opens the macro dialog box where you 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 you can fill the details of your macro.

Use Relative Reference: This option helps record macro in relative mode. Using relative mode you 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. Fill the details of macro then click ok. See the image given below.

Macros in Excel 2

Now perform the task that you want to record. When the task is done, click on the arrow below the macro button it will display three options, out of these options select stop recording. See the image given below:

Macros in Excel 3

Now the macro is created and is ready to use, to run the macro click on the Macro button. You can also 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 the image given below:

Macros in Excel 4

Latest 4 Tutorials on JavaTpoint