Adding Your Own Menu Items

Summary: Want to really make Excel reflect how you work? Why not make some changes to the menu structure so that the menus have your commands where you want them? This tip explains how you can use the Customize dialog box to add your own new menu items, such as one to run a macro. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

As you customize Excel to meet your particular needs, you may want to add a menu item or two. For instance, you might want to add a menu item to run a macro you have designed. To add an item to a menu, follow these steps:

Select Customize from the Tools menu. Excel displays the Customize dialog box.
Make sure the Commands tab is selected. (Click here to see a related figure.)
In the Categories list, select either the category of commands you want to add to the menu, or select Macros if you want to add a macro to a menu.
In the list of available commands for the category, select the one that you want to add to a menu.
Drag the selected command to the menu where you want it added. The menu appears as you move the selected command over the command name.
As you reach the point where you want the item to be added, release the mouse button.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2719) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Save Time and Money! Many people need to keep track of employee time, but don't know where to start when it comes to creating a spreadsheet. Here's a way to save time, effort, and money with ready-to-use timesheet templates.

Check out Timesheet Templates today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Adding Your Own Menu Items