Creating Your Own Menus

Creating Your Own Menus

Just as you can create your own custom toolbars , you can create your own menus in Excel and add whichever commands you want the menu to include. The following steps lead you through the process:

1. Open the Tools menu and choose Customize , or right-click a toolbar and choose Customize .

2. Click the Commands tab.

3. Scroll to the bottom of the Categories list and click New Menu , as shown in Figure 12.10. The Commands list displays a single item: New Menu.

   Figure 12.10. You can create your own menu.

   

4. From the Commands list, drag New Menu up to the menu bar, and drop it in the position where you want your new menu inserted. New Menu appears on the menu bar.

5. Right-click New Menu in the menu bar, and then in the Name text box, drag over New Menu and type the desired name for your menu.

6. In the Categories list (in the Customize dialog box), click the category for a command that you want to add to your menu.

7. Scroll down the Commands list to find the desired command.

8. Drag the desired command from the Commands list over the name of your new menu and onto the menu itself, as shown in Figure 12.11. The command appears on the menu, and your menu expands to accommodate it.

   Figure 12.11. You can populate your menu with commands from the Commands list.

   

9. Repeat steps 68 to add more commands to your menu.

10. When your menu is complete, click the Customize dialog box's Close button.