Datasheet
As far as I can tell, there is no limit to the number of commands that you can add to your
QAT. But regardless of the number of icons, the QAT always displays a single line of icons.
If the number of icons exceeds the Excel window width, it displays an additional icon at
the end: More Controls. Click the More Controls icon, and the hidden QAT icons appear in a
pop-up window.
Adding New Commands to the QAT
You can add a new command to the QAT in three ways:
•
Click the QAT drop-down control, which is located on the right side of the QAT (see
Figure 10-1). The list contains several commonly used commands. Select a command
from the list, and Excel adds it to your QAT.
•
Right-click any control on the Ribbon, and choose Add To Quick Access Toolbar. The
control is added to your QAT, after the last control.
•
Use the Customize tab of the Excel Options dialog box. A quick way to access this dialog
box is to right-click any Ribbon control and choose Customize Quick Access Toolbar.
Figure 10-1: The QAT drop-down menu is one way to add a new command to the QAT.
Figure 10-2 shows the Customize tab of the Excel Options dialog box. The left side of the
dialog box displays a list of Excel commands, and the right side shows the commands that
are now on the QAT. Above the command list on the left is a drop-down control that lets
you filter the list. Select an item for the drop-down list, and the list displays only the com-
mands for that item.
Tip 10: Customizing Your Quick Access Toolbar
32
04_137666 ch01.qxp 5/22/07 7:31 PM Page 32