Datasheet

You can add separators to the toolbar to group related buttons. To do this,
click the <Separator> selection in the list box on the left and then click the
Add button twice to add two. Then, click the Move Up or Move Down buttons
to position one of the two separators at the beginning of the group and the
other at the end.
To remove a button added from the Ribbon, right-click it on the Quick Access
toolbar and then click the Remove from Quick Access Toolbar option on its
shortcut menu.
Adding non-Ribbon commands to the Quick Access toolbar
You can also use the options on the Customize tab of the Excel Options
dialog box (see Figure 1-6) to add a button for any Excel command even if it’s
is not one of those displayed on the tabs of the Ribbon:
1. Click the type of command you want to add to the Quick Access tool-
bar in the Choose Commands From drop-down list box.
The types of commands include the File pull-down menu (the default) as
well as each of the tabs that appear on the Ribbon. To display only the
commands that are not displayed on the Ribbon, click Commands Not in
the Ribbon near the bottom of the drop-down list. To display a complete
list of all the Excel commands, click All Commands at the very bottom of
the drop-down list.
2. Click the command whose button you want to add to the Quick Access
toolbar in the list box on the left.
Figure 1-6:
Use the
buttons
on the
Customize
tab of the
Excel
Options
dialog box
to cus-
tomize the
appearance
of the Quick
Access
toolbar.
20
Part I: Getting In on the Ground Floor
05_037377 ch01.qxp 11/16/06 9:23 AM Page 20