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.



More articles......



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.


Find Real Lovers