Microsoft Office Tutorials and References
In Depth Information
Adding tools to the toolbar
INSIDE OUT Create a mini ribbon
Here is a trick you can use if it just seems like too much bother to click those tabs at
the top of the ribbon, or if you just want to maximize screen space. Saving a click here
and there can make quite a difference if you do a lot of repetitive work. The following
illustration shows the Quick Access Toolbar displayed below the ribbon (which is
minimized) and loaded with buttons that correspond to every group on every default tab
on the ribbon:
The toolbar shown here includes only buttons that correspond to the command groups
(not individual commands) on every default tab. Notice that clicking the Tables button
displays a drop-down list of commands identical to those in the ribbon group of the
same name on the Insert tab. To customize the toolbar this way, use the Excel Options
dialog box. Although you can build a similar toolbar using the right-click approach,
using the dialog box offers the advantage of being able to insert separators between
groups of buttons.
You’ll find the Ribbon Group Toolbar.xlsx file on the companion website.
Too many tools?
It is certainly possible to load more buttons onto the Quick Access Toolbar than can it
across the screen, even if you move the toolbar below the ribbon. If this happens, a More
Controls button appears at the right end of the toolbar, looking like a fast-forward button
(>>). As shown in Figure 3-15, clicking More Controls displays the hidden controls on a
Figure 3-15 If you add more buttons than can be displayed, click the More Controls button.