Datasheet

Toolbar Excel 2007 Common Excel 2007
button Equivalent Shortcut Keys Shortcut Keys
Sort Descending Home | Sort & Filter | Alt+HSO
Sort Z to A
ChartWizard
Not available except
as specific chart type
command buttons in
the Charts group
on the Insert tab
Drawing Not available except
as command buttons
in the Shapes,
Illustrations, and Text
groups on the Insert tab
and as custom buttons
added to Quick Access
toolbar
Zoom View | Zoom Alt+WQ
Microsoft Excel Microsoft Office Excel F1
Help Help button to the right
of the Ribbon tabs
Because Excel 2007 supports only a single toolbar, the Quick Access toolbar,
the Drawing toolbar disappears completely from Excel 2007 and thus the
Drawing button on the Standard toolbar has no equivalent. Most of its main
features, including Clip Art, inserting graphics files, and creating diagrams
and WordArt are now found on the Insert tab. Also, keep in mind that Excel
2007 doesn’t have an equivalent to the ChartWizard button on the Standard
toolbar because you can create a chart in a split-second by clicking the
Column, Line, Pie, Bar, Area, XY (Scatter), or Other Charts command buttons
on the Insert tab (see Chapter 8).
Finding the Formatting Toolbar
buttons equivalents
Finding the Excel 2007 equivalents for the buttons on the Formatting toolbar
in earlier versions of Excel couldn’t be easier: Every one of the buttons on the
Formatting toolbar is prominently displayed on the Home tab of the Excel 2007
43
Chapter 1: The Excel 2007 User Experience
05_037377 ch01.qxp 11/16/06 9:23 AM Page 43