Customizing toolbars

Choose Toolbars from the View menu to display the submenu of available toolbars. The Standard and Formatting toolbars are the default toolbars, but you can display other toolbars by choosing them from the submenu. To learn more about customizing toolbars, see Chapter 19. 

The built-in Microsoft Excel toolbars can be restored to their "factory-installed" condition by using the Reset button in the Toolbars tab of the Toolbars dialog box (Figure 19-2). Individual toolbuttons can be restored by following the procedure described earlier. Custom toolbars cannot be reset. 

There are two ways to create a custom toolbar. One way is to modify an existing toolbar (such as the Standard toolbar). The other way is to create a new toolbar and then proceed to add built-in tools, as described earlier, or custom toolbuttons, as described later in this chapter. This way you can leave the Standard and Formatting toolbars (for example) unmodified and display your own custom toolbar. To create a new toolbar, use the procedure in the following box. 

Press the New... button. Enter a name for the custom toolbar (see Figure 19-4), then press OK. The (empty) custom toolbar will appear. 

Figure 19-4. Naming a custom toolbar with the New Toolbars dialog box.

From the Options menu, select Customize Toolbar. 

The order that the buttons appear on the toolbar can be changed by selecting individual buttons on the Current toolbar buttons list in the Customize Toolbar dialog and then clicking the Move Up or Move Down buttons. 

---