How to Create and Run a Macro in Excel

Macro can be used to recording group of more than one commands. If you want to run more then one commands in a sequential format then you have to create a Macro in Excel. This guide helps you to easily create and run a Macro in Excel.

During working on Microsoft Excel you need to run more than one commands one by one. But it’ll take lot of time to again and again execute more than one same commands in any worksheet. If you want to execute all the commands sequentially then you must have to create the Macro. After creating the Macro you can easily run any existing macro either from excel shortcut keys or from View tab.

Must Read: How to find duplicates using conditional formatting in Excel

Easily Create and Run a Macro in Excel

Macro is an important utility of Microsoft Excel, which enable you to record more than one commands in Excel. When you need you have to execute any existing macro and stored commands are executed one by one in active worksheet. You just have to take few given simple steps which helps you to create and run a macro in Excel.

How to Create and Run a Macro in Excel

Step 1: Create a blank worksheet, in which you want to store a Macro in Excel.

Step 2: Click on the View tab and choose Macros option > Now, click on the “Record Macro…” option.

Step 3: In the Record Macro dialog box fill the Macro name, set the shortcut key to run the macro, set store macro location and description as per your need. Click on the OK button after fill all the necessary information.

Must Read: How to Age calculation From Date of Birth – MS EXCEL

Step 4: Macro recording is stared you just have to type data, make any kind of formatting and other required things in active worksheet. After finish all the formatting and editing stop the recording of macro from View > Macros > Click on the “Stop Recording” button.

Step 5: Take cursor on any new worksheet and press the assign shortcut key to run the macro. You can also use given path to run any existing macro View > Macros > View Macro or Press Alt+F8 shortcut key to quickly open view macro dialog box. Select the Macro name which you want to execute and click on the “Run” button.

Now all the stored commands are executed one by one in active worksheet. If you don’t want to keep any existing macro then you have to delete any macro in Excel from Macro dialog box.

I hope after reading this guide you can easily create and run a Macro in Excel. If you have any suggestion regarding this guide then please write us in the comment box. Thanks to all.

Leave a Reply

Your email address will not be published. Required fields are marked *