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