Record a Macro to create Shortcut Button for Multiple Formats in Word and Excel 2013

By default, the Quick Access Toolbar of Microsoft Word 2013 and Microsoft Excel 2013 contains only three options – Save, Undo and Redo. But, what if I say that this is possible to add more custom buttons? On the other hand, we often apply different formats such as Bold, Italic, Underline, Heading 1, Heading 2, etc, to our writings. Sometime, we need to apply more than one formats (bold, italic and underline or bold and heading 1, etc.) multiple times. Suppose, you need to do so 50 times. This would mean, to complete styling for one time, you need to click on three buttons or so.

To get rid of this time consuming work, you can record a macro and create a shortcut button to implement multipleformats at once. Let us see how to do this.
Record a Macro – Create button to add multiple formats

This is very easy and not very time consuming. You can do this in Word 2013 as well as Excel 2013. The following steps are done with Word 2013, but Excel users can also follow these steps since they are same.

First, open your Word 2013 app and go to View tab. After that, click on Macros and select Record Macro.
Record Macro in Word 2013
Then, you will get a popup as follows,
Enter Macro Details
You need to enter a name and a description, so that you can identify it quickly. Also, make sure that All Documents (Normal.dotm) is selected. After entering all these detsila, hit the OK button. Thereafter, your cursor would look like this –
New Cursor style
Now, you can select any format. Ex.: Bold, Underline etc.
Select Formats
After selecting or clicking on all those formats, hit the Stop button that is positioned in the bottom of Microsoft Word.
Stop Macro Recording
To pin this recorded Macro to your Quick Access Toolbar, navigate to File > Options > Quick Access Toolbar. Now, expand the drop-down menu and select Macros.
record a macro
You will get your Macro in the left side. Just select it and click on Add button.
Add Macro
If you want to give it an icon, just select it from right side and click on Modify button.
Add Icon to Macro
After that, you will get icons to add.
You will now get a new icon on your Quick Toolbar.
New Macro on Quick Access Toolbar
Whenever, you wish to apply those formats, just select the text and hit that button.
Instead of wasting your time to apply various formats or style to to text, you can simply record a macro, add it to your Quick Access Toolbar and utilize it in accordance with your requirements.


Post a Comment



FIND US ON Twitter