Datasheet

To customize your Quick Access toolbar so that it matches the one shown in
Figure 1-10 with every button from the Standard and Formatting toolbars
except the Permission, Zoom, and Help buttons, follow these steps:
1. Click the Customize Quick Access Toolbar button at the end of the
Quick Access toolbar and then click the Show Below the Ribbon option.
When filling the Quick Access toolbar with buttons, you need to place
the bar beneath the Ribbon so that it won’t crowd out name of the cur-
rent workbook file.
2. Click the Customize Quick Access Toolbar button again and this time
click the More Commands option.
Excel opens the Excel Options dialog box with the Customize tab
selected. The Customize Quick Access Toolbar list box on the right side
of this dialog box shows all three of the default buttons in the order in
which they now appear on the toolbar.
3. Click the New option in the Popular Commands list followed by the
Add button.
Excel adds the New command button at the end of the toolbar indicated
by the appearance of the New button at the bottom of the list in the
Customize Quick Access Toolbar list box on the right.
4. Click the Move Up button (with the triangle pointing upward) three
times to move the New button to the top of the Customize Quick Access
Toolbar list box and the first position on the Quick Access toolbar.
Note that the New button is now in front of the Save button on the toolbar.
5. Click the Open option in the Popular Commands list box on the left
and then click the Add button.
Excel inserts the Open button in the Customize Quick Access Toolbar
list box in between the New and Save button, which is exactly where it
appears on the Standard toolbar.
6. Click the Save button in the Customize Quick Access Toolbar list box
on the right to select this button. Then, click the Quick Print option in
the Popular Commands list box on the left and click the Add button.
Excel inserts the Quick Print button after the Save button.
7. Click the Print Preview button near the bottom of the Popular
Commands list box and then click the Add button.
Excel inserts the Print Preview button after the Quick Print button in the
Customize Quick Access Toolbar list box.
Now, you need to add the Spelling and Research buttons. They are located
on the Review tab in Excel 2007. Before you can add their buttons to the
Quick Access toolbar, you need to replace Popular Commands with
Review Tab by selecting this option on the Choose Commands From
drop-down list.
46
Part I: Getting In on the Ground Floor
05_037377 ch01.qxp 11/16/06 9:23 AM Page 46