Adding a Menu to a Toolbar and Deleting a Custom Toolbar and Resetting a Menu and Resetting a Toolbar

♦Adding a Menu to a Toolbar

1- Display the toolbar that you will add a menu to it.

2- From the main menu,choose →Tools →Customize to display the Customize dialog box.

3- Click on the Commands tab.

4- In the Categories scrolling box, select New Menu.

5- From the Commands scrolling box, drag the New Menu command onto the toolbar. 

6- Check to see that the New Menu icon is selected

 

7- From the Commands tab of the Customize dialog box, click on the Modify Selection

button:

8- From the Name item of the popup menu, select the text in the text box, and enter a name for your new menu

9- To add items to the new menu, locate and drag the command onto the popup menu

portion of the new menu icon.  (You will need to hold the command over the new menu icon, and wait for the popup menu to appear):

10-Continue adding other commands to create your menu.

11- When finished, click Close.

  

♦Deleting a Custom Toolbar

1- From the main menu, choose Tools  →Customize to display the Customize dialog box.

2- Click on the Toolbars tab.

3- Select the toolbar you want to delete by clicking on the toolbar name:

4- Click Delete.  The following warning message will appear:

5- Click OK to delete the toolbar.

6- From the Customize dialog box, click Close.

  ♦ Resetting a Menu

Excel allows you to customize menus by adding commands, editing names, changing  icons, etc.  Modified menus can be set to their default state by resetting them.

1- From the main menu, choose Tools  →  Customize to display the Customize dialog  box. 

2- Leave the Customize dialog box open, right-click the menu you want to restore ,and select Reset from the popup menu:

        

3- From the Customize dialog box, click Close

 

♦ Resetting a Toolbar

Excel allows you to customize toolbars by adding commands, editing names, changing icons, etc.  Modified 

toolbars can be set to their default state by resetting them.

 

1- From the main menu, choose Tools → Customize to display the Customize dialog

box.

2- Click on the Toolbars tab.

3- Select the toolbar you want to reset by clicking on the toolbar name.

4- Click Reset.  The following warning message will appear:

 

5- Click OK to reset the toolbar.

6- From the Customize dialog box, click Close.

NOTE: You cannot reset custom toolbars.