Microsoft Office Tutorials and References
In Depth Information
Restoring the toolbar
Customizations (which also resets the ribbon). Click Yes to confirm the restoration,
and then click OK.
Removing individual buttons On the Quick Access Toolbar, right-click the button
you want to remove and then click the Remove From Quick Access Toolbar
command, as shown in Figure 3-19.
Figure 3-19 You can easily remove any button from the Quick Access Toolbar.
INSIDE OUT What happened to my custom toolbars?
Custom toolbars you created and attached to workbooks in versions of Excel prior to
2007 are still accessible, though you might not think so at first glance. If you open an
old workbook with attached toolbars, the toolbars won’t appear on the screen. But
look at the Add-Ins tab on the ribbon. You might not have seen the Add-Ins tab before,
but click this tab, and there they are—your custom toolbars. The following graphic
shows an example of having way too many custom toolbars on the Add-Ins tab:
So all your hard work creating custom toolbars is not lost—provided you attached
them to workbooks. After you open a workbook containing attached toolbars, the
toolbars continue to appear on the Add-Ins tab each time you start Excel. To get rid of
them, right-click each toolbar (each row of buttons is a toolbar on the Add-Ins tab) and
close it by using the Delete Custom Toolbar command. When you delete the last
custom toolbar, if it is the only item on the Add-Ins tab, the Add-Ins tab disappears as well.