• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Modifying Toolbars

Many tools are available on the default Excel toolbars, but you’re likely to find that you use certain tools repeatedly, and others rarely or never. You’re probably already comfortable with turning the various toolbars on and off with the View, Toolbars command, and have undoubtedly noticed that Excel displays certain toolbars automatically when you work in certain modes—the Chart toolbar appears when you’re creating or editing charts, and so on. But you might not have thought about customizing those default toolbars to fit your specific needs. Excel enables you to add and remove buttons on any of the default toolbars, move buttons from one toolbar to another, and even create custom toolbars for various purposes.

To begin customizing toolbars, start by opening the Customize dialog box. Choose View, Toolbars, Customize, or right-click any toolbar and select Customize from the pop-up menu to open the Customize dialog box. With this dialog box open, you can right-click any toolbar button to display a special pop-up context menu for customizing that button, as shown in Figure 27.9. You can also access the Customize command from the Tools menu. This option appears just below the other command that controls Excel—the Options command. You can also access the Customize command from the Tools menu.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint