Save more than one toolbar configuration - Excel

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this link

Printer-Friendly Version Bookmark and Share

Save more than one toolbar configuration

Applies to: Microsoft Office Excel 2003

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, click Customize on the Tools menu, and then click the Toolbars tab.), create any custom toolbars you want to save, and then display the toolbars the way you want them to appear.
How?
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:
  Add 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.
  Add 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.
7. When you have added all the buttons and menus you want, click Close.
Quit Excel.
Locate the file Excel.xlb.
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.