Datasheet

8. Click the Choose Commands From drop-down button and then click
Review Tab in the drop-down list.
Excel now displays all the command buttons on the Review tab of the
Ribbon in the list box below.
9. Add the Spelling and Research buttons from the Review Tab list box
to the Customize Quick Access Toolbar list box and position them so
that they appear one after the other following the Print Preview
button.
Next you need to add the Cut, Copy, Paste, and Format Painter buttons to
the Quick Access toolbar. These command buttons are on the Home tab.
10. Click the Home Tab option in the Choose Commands From drop-down
list and then add the Cut, Copy, Paste, and Format Painter buttons to
the Customize Quick Access Toolbar in this order in front of the Undo
button.
Note when adding the Paste button that Choose Commands From dis-
plays two Paste buttons. The first is the regular Paste button that was on
the Standard toolbar. The second is a Paste button with a drop-down
button that, when clicked, opens a drop-down menu with all the special
Paste options. You can add either one, although the second Paste button
with the drop-down menu is much more versatile.
11. Click the Format Painter option in the Insert Tab list box and then
click the Add button.
Excel adds the Format Painter button after the Paste button in the
Customize Quick Access Toolbar list box on the right.
12. Click the Redo button in the Customize Quick Access Toolbar list box
to select its icon and then click the Insert Tab on the Choose
Commands From drop-down list and add the Insert Hyperlink button
from to the Quick Access toolbar.
13. Add the remaining Standard toolbar buttons, AutoSum, Sort Ascending,
Sort Descending, and Create Chart, to the Quick Access toolbar.
The AutoSum, Sort Ascending, and Sort Descending buttons are avail-
able in the Home Tab and the Create Chart button (the closest thing to
the Chart Wizard in Excel 2007) is on the Insert Tab list box.
14. Add the buttons on the Formatting toolbar to the Quick Access toolbar
in the order in which they appear.
The Formatting toolbar contains these tools all found on the Home tab:
• Font
• Font Size
• Bold
• Italic
47
Chapter 1: The Excel 2007 User Experience
05_037377 ch01.qxp 11/16/06 9:23 AM Page 47