#FridayHacks-How To Create Custom Task Menus In Word Or Excel

I am one of those people who love to move with technology and when office 2013 came out, I jumped into using it. But little did I know the hidden features in it. To increase the readability and visibility of a document it has to be formatted in a nice way. I am sure you highlight pieces of text by applying different types of formats. Now, my question to you is how often do you apply bold, italics, and underline formatting (all at once) to text in your Word, PowerPoint, or Excel document? If you answered,read on.

Am going to help you reduce that three-step process to one. You either click on the buttons B, I, U or use the keyboard shortcuts Ctrl + B, Ctrl + I, Ctrl + U. Yesterday was the last day you used those short cuts. You will have a button by the end of this tutorial that does all three in a single click that’s the beauty of technology. And this is just an example, you can use this method to create several such buttons for repetitive formatting. The idea is to record a macro and then assign it to a button. The button can be placed anywhere in the ribbon or the quick access toolbar. I prefer the latter, like the one shown in the diagram below.
excel menus

Record a Macro

Step 1: Navigate to View -> Macros -> Record Macro.


Step 2: Give your macro a name, give it an optional description, and select the scope. Then click on OK.


If you want you can assign it a keyboard shortcut. But be careful because you may end up overriding default keyboard shortcuts.

Step 3: Whatever you do after clicking on OK will be recorded as a sequence of actions. So check the B, I, U and any other buttons as you see fit. It keeps recording until you press the stop button placed on the status bar. Click on the stop icon when finished.


Leave a Reply

%d bloggers like this: