How to Add a Custom Menu to an Excel Toolbar

By eHow Computers Editor

Rate: (5 Ratings)

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:

Adding a Custom Menu to a Toolbar

Step1
Open Microsoft Excel.
Step2
Display the toolbar that contains the menu where you want to add your command.
Step3
Open the Tools menu and select Customize.
Step4
Select the Commands tab.
Step5
In the Categories box, click New Menu.
Step6
Drag New Menu from the Commands box to the desired location on toolbar.
Step7
Right-click the new menu and select Name.
Step8
Type a name for the menu in the Name box. Press Enter.
Step9
Now add commands to the new menu, following the steps in the next section.

Adding a Command to a Menu

Step1
Open the Tools menu and select Customize.
Step2
Select the Commands tab.
Step3
Click your new menu on the toolbar. A box will appear below it.
Step4
In the Categories box, select the category for the command.
Step5
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.

Comments

| View All Comments
Flag This Comment

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?
richard@doonella.com

View All

Post a Comment

POST A COMMENT

Request a New How-To Article

Looking for more How To information? Chances are there’s an eHow member who knows how to do what you’re looking to do. Submit an article request now!

eHow Article: How to Add a Custom Menu to an Excel Toolbar

eHow Computers Editor

eHow Computers Editor

Category: Computers

Articles: See my other articles

Related Ads