Datasheet

For the most part, the pull-down menu commands listed in Table 1-2 are logi-
cally located. The ones that take the most getting used to are the Header and
Footer and PivotTable/Chart commands that are located on the Insert tab
rather than the View tab and Data tab as might be expected given they inhab-
ited, respectively, the View and Data pull-down menus in earlier Excel versions.
In addition, the worksheet background command ended up all by its lonesome
on the Page Layout tab rather than going to the Home tab with all its fellow
formatting commands.
Finding the Standard Toolbar
buttons equivalents
If you’re like me, you came to rely heavily on the buttons of the Standard tool-
bar in doing all sorts of everyday tasks in earlier versions of Excel. Table 1-3
shows you the Excel 2007 equivalents for the buttons on the Standard toolbar
in Excel 2003. As you can see from this table, most of these Standard toolbar
buttons are regulated to one of the places in Excel 2007:
 Office pull-down menu activated by clicking the Office Button or press-
ing Alt+F (New, Open, Save, Print Preview)
 Quick Access toolbar (Save, Undo, and Redo)
 Home tab in the Clipboard group (Cut, Copy, Paste, and Format Painter)
and Editing group (AutoSum, Sort Ascending, and Sort Descending)
Table 1-3: Excel 2007 Equivalents for the Standard Toolbar
Buttons in Excel 2003
Toolbar Excel 2007 Common Excel 2007
button Equivalent Shortcut Keys Shortcut Keys
New Office Button | New Ctrl+N Alt+FN
Open Office Button | Open Ctrl+O Alt+FO
Save Office Button
| Save or Ctrl+S Alt+FS
Save button on Quick
Access toolbar
Permission
Available only as a
custom Permission
button added to
Quick Access toolbar
(continued)
41
Chapter 1: The Excel 2007 User Experience
05_037377 ch01.qxp 11/16/06 9:23 AM Page 41