How to Create Macros in MS Excel 2016?

Suppose you are working on Excel, and repeatedly you have to perform the same actions. Then you can create a macro for that and use it as many time in the worksheet. A macro record the actions, it can be a mouse click, keystroke, or modification in a font, etc. Creating macro saves time. So let’s move towards the steps of How to Create Macros in MS Excel 2016?

Steps to Create Macro in MS Excel 2016:

Step 1:  Open an Excel worksheet on your screen in which you want to create a macro. Now, go to the View tab. Under Macros group you have a Macros drop down button click it.

Step 2: Macros provide three options:

View Macros: it will show you the list of the already created macro if any.
Record Macros: this option allows you to create your macro that you can play back again.
Use Relative References: Here macros are recorded with the actions relative to the initially selected cell.

As our aim is to create Macro select Record Macro.

Step 3: A Record Macro dialogue box is opened which will demand to fill the Macro name, Shortcut Key, Storage location of the macro.
In the image below you can observe that I named my macro as Highlight, remember do not use spaces while naming a macro. Then in Shortcut key, the Ctrl key is constant in every shortcut key, I wanted to make the shortcut as Ctrl +H i.e.  h in upper case to make a shortcut key. Hence I pressed Shift + h that’s why Shift + H get append to Ctrl.

Next, comes Store Macro in, a drop down box. It provides you three options:

Personal Macro Workbook: Select this if you think that the created macro has wider applicability to the other workbooks also.
New Workbook: Select this if you want the macro to be applicable to the workbooks that you will create newly.
This Workbook: Select this when you feel that only the current workbook will require this macro.

For now, I have selected This Workbook. Then Click OK.

Step 4: As soon as you click OK, the recording has started. Click a cell (1) to which you want to use to create a macro. Then perform the action to record a macro. Like I selected (2) the Font size 12, Font Style Bold, Italic, Font Alignment, Colour of text and background. Now when you performed the desired actions, to stop recording click on the box beside Ready (3) that appears at the left bottom of the worksheet.

Step 5: Now, it’s time to use the macro. You can simply select a cell to which you want to apply macro. Then press the shortcut key to apply macro. You can also go to the Macros button in the View tab and visit View Macros and then select the macro you want to apply then run it.

Thank you. Hope the content is useful. Keep reading.