Datasheet

Only you can decide which commands to put on your QAT. In general, if you find that you
use a particular command frequently, it should probably be on your QAT. For example,
when I work on a chart, I like to use the Chart Elements control to make it easy to select
chart elements. That control is located in the Chart Tools Format tab and the Chart
Tools Layout tab, but not in the Chart Tools Design tab. Putting a copy of this control
on my QAT saves me many keystrokes on every chart I work on.
Performing Other QAT Actions
Here are some other things you can do with your QAT:
Rearrange the QAT icons: If you want to change the order of your QAT icons, you can
do so on the Customization tab of the Excel Options dialog box. Select the command and
then use the up- and down-arrow buttons on the right to move the icon.
Remove QAT icons: The easiest way to remove an icon from your QAT is to right-click
the icon and choose Remove from Quick Access Toolbar. You can also use the
Customization tab of the Excel Options dialog box. Just select the command in the list
on the right and click the Remove button.
Reset the QAT: If you want to return the QAT to its default state, display the
Customization tab in the Excel Options dialog box and click the Reset button. All your
customizations disappear, and the QAT then displays its three default commands.
Tip 10: Customizing Your Quick Access Toolbar
34
04_137666 ch01.qxp 5/22/07 7:31 PM Page 34