How to Add a Custom Menu to an Excel Toolbar

It's easy to customize your Excel toolbar and menus. You can make your own menu with commands you most commonly use and stick it in the toolbar. These steps work with Microsoft Excel 97.

Difficulty: Moderate

Instructions

Things You'll Need:

• Excel Book
• Microsoft Excel

Adding a Custom Menu to a Toolbar

1. Open Microsoft Excel.

2. Display the toolbar that contains the menu where you want to add your command.

3. Open the Tools menu and select Customize.

4. Select the Commands tab.

5. In the Categories box, click New Menu.

6. Drag New Menu from the Commands box to the desired location on toolbar.

7. Right-click the new menu and select Name.

8. Type a name for the menu in the Name box. Press Enter.

9. Now add commands to the new menu, following the steps in the next section.

Adding a Command to a Menu

10. Open the Tools menu and select Customize.

11. Select the Commands tab.

12. Click your new menu on the toolbar. A box will appear below it.

13. In the Categories box, select the category for the command.

14. Drag the command you want from the Commands box to the new menu's box on the toolbar. When the menu displays a list of menu commands, point to the location where you want the command to appear on the menu on the toolbar, and then release the mouse button.

Tips & Warnings

• You can also just drag commands to a toolbar to insert the commands as toolbar buttons.

[richardfisher]

on 2/15/2007 That's the easy part! But how do you save a custom excel menu in a 'safe' file for later usage?
[e-mail]