XL2000: Customizing Menus and Toolbars Without Using Customize Dialog Box (211947)

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.