XL2000: Customizing Menus and Toolbars Without Using Customize Dialog Box

Normally, if you want to customize a menu or toolbar, you must first display the Customize dialog box (click Customize on the Tools menu). However, there is a way to customize menu bars and toolbars without having to display the Customize dialog box.

NOTE: This "Quick Customize" mode for modifying menu bars and toolbars does not include all the features available in the Customize dialog box.

The following steps show you how to customize the worksheet menu bar without displaying the Customize dialog box.

Deleting a Menu

To delete a command from the worksheet menu bar, hold down ALT and drag the command from the menu to the workbook area. For example, to delete the Help command, hold down ALT, point to Help, hold down the mouse button, drag the item onto the workbook area, and then release the mouse button.

Reordering a Menu Bar

To move a command from one position to another on the worksheet menu bar, hold down ALT and drag the command to the new position (either left or right of its current position). For example, to move the Window command to the left of the Tools menu, hold down ALT, place your mouse pointer over the Window menu control, hold down the mouse button and drag the Window command until you see a thick vertical bar to the left of the Tools command. Release the mouse button and the Window command appears in the new position.

NOTE: These procedures also work on toolbars.

Reset the Worksheet Menu Bar

To reset the worksheet menu bar to its default settings, follow these steps:

1.	Right-click the menu bar and then click Customize on the shortcut menu.
2.	Click the Toolbars tab.
3.	In the Toolbars list, click to select (highlight) Worksheet Menu Bar and then click Reset.
4.	If you receive a message asking you to confirm that you want to reset the worksheet menu bar, click OK.
5.	Click Close.

For more information about toolbars, click Microsoft Excel Help on the Help menu, type About menus and toolbars in the Office Assistant or the Answer Wizard, and then click Search to view the topic.