Datasheet

Figure 10-2: Use the Customization tab in the Excel Options dialog box to customize the QAT.
Some of the items in the drop-down control are described in this list:
•
Popular Commands: Displays commands that Excel users commonly use
•
Commands Not In The Ribbon: Displays a list of commands that you cannot access
from the Ribbon
•
All Commands: Displays a complete list of Excel commands
•
Macros: Displays a list of all available macros
•
Office Menu: Displays the commands available on the Office menu
•
Home Tab: Displays all commands that are available when the Home tab is active
In addition, the drop-down list contains an item for every other tab.
To add an item to your QAT, select it from the list on the right and click Add. Notice that
some commands in the list on the left display icons. The icon tells you what form the com-
mand will take: a drop-down list, a split button, an edit control, or a Ribbon group. If the
command doesn’t display an icon, it’s a button control.
If you add a macro to your QAT, you can click the Modify button to change the text and
choose a different icon for the macro.
The only time you ever need to use the Customize tab of the Excel Options dialog box is
when you want to add a command that’s not on the Ribbon or add a command that executes
a macro. In all other situations, it’s much easier to locate the command on the Ribbon,
right-click the command, and choose Add To Quick Access Toolbar.
Tip 10: Customizing Your Quick Access Toolbar
33
Part I
04_137666 ch01.qxp 5/22/07 7:31 PM Page 33