Microsoft KB Archive/211947

= XL2000: Customizing Menus and Toolbars Without Using Customize Dialog Box =

Article ID: 211947

Article Last Modified on 9/25/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211947





SUMMARY
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.



MORE INFORMATION
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.

