Datasheet

19
Chapter 1: Getting Familiar with the Excel 2010 Interface
The command buttons for your customized version of the Quick Access toolbar
now appear in the correct order in the Customize Quick Access Toolbar list box in
the Excel Options dialog box. The only other thing you need to do is to divide them
into groups by adding a vertical bar called a separator.
8. Click the Print Preview and Print command option in the Customize Quick Access
Toolbar list box to select it and then click the Separator option at the very top of
the Choose Commands From list box to select this option. Click the Add button.
Excel inserts a separator between the Print Preview and Print and Undo command
options in the Customize Quick Access Toolbar list box.
9. Use this same technique to add a Separator between the Redo and AutoFormat
command options and the Form and Speak Cells command options in the
Customize Quick Access Toolbar list box.
Your customized Quick Access toolbar now contains four groups of command
buttons created by the three Separator options that appear after the Print Preview
and Print command option, Redo command option, and the Form command option.
10. Click OK to close the Excel Options dialog box.
Check the buttons on your customized toolbar against those shown in the toolbar
in Figure 1-5.
11. On the Quick Access toolbar, click the Customize Quick Access Toolbar button
followed by the Show Above the Ribbon option on its menu.
The final version of your customized Quick Access toolbar now appears once again
above the Ribbon to the immediate right of the File menu.
Figure 1-4:
The Excel
Options dia-
log box with
the Quick
Access
Toolbar
option
selected.
05_489604-ch01.indd 1905_489604-ch01.indd 19 7/29/10 11:25 PM7/29/10 11:25 PM