MS Excel is a robust piece of software that can make your life so much easier, but you do not want to wade through menu items that you hardly ever use, right?
You can customize Excel to meet your specific needs and have it your way just like the popular fast food franchise boasts.
Did you know that you can add a macro you have created to a menu? Well you can! You can customize your menus to reflect your own personal commands.
Follow the steps below to learn how:
- Click on Tools | Customize to display the dialog box.
- Be certain the Commands tab is selected.
- In the Categories list, select the category of commands you would like to add to your menu or, alternatively, select Macros if you wish to add a macro to your menu.
- In the list of available commands for the category, select the one that you would like to add.
- Drag the selected command to the menu where you would like it added. The menu appears as you move the selected command over the command name.
- As you reach the point where you would like to add the item, simply release your mouse button.
That’s all there is to it!
Versions 97, 2000, 2002, 2003