Save more than one toolbar configuration

  1. Make any changes you want to the built-in menu (built-in menu: A menu included with Microsoft Office; it is not created by the user.) and toolbars (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, press ALT and then SHIFT+F10.), create any custom toolbars you want to save, and then display the toolbars the way you want them to appear.

ShowHow?

  1. On the Tools menu, click Customize.
  2. Click the Toolbars tab.
  3. Click New.
  4. In the Toolbar name box, type the name you want, and then click OK.
  5. Click the Commands tab.
  6. Do one of the following:

ShowAdd a button to the toolbar

  1. Click a category in the Categories box.
  2. Drag the command you want from the Commands box to the displayed toolbar.

ShowAdd a built-in menu to the toolbar

  1. In the Categories box, click Built-in Menus.
  2. Drag the menu you want from the Commands box to the displayed toolbar.
  1. When you have added all the buttons and menus you want, click Close.
  1. Quit Excel.
  2. Locate the file Excel.xlb.
  3. Rename the file, retaining the .xlb extension.

To use a saved configuration, click Open on the File menu and open the renamed file. When you next quit the program, Excel creates a new Excel.xlb toolbar settings file.

 
 
Applies to:
Excel 2003