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.

Instructions

Difficulty: Moderate

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

• The Reset button on the Toolbars tab of the Customize dialog box is your friend. It restores your menus to Excel's default values.
• The Delete command that appears when you right-click your new menu will erase the menu. This cannot be undone.
• Use the Toolbars tab of the Customize dialog box to display or hide additional toolbars. Click New to create a custom toolbar of your own.
• You can also just drag commands to a toolbar to insert the commands as toolbar buttons.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.