Datasheet
14 Part 1: Getting to Know Excel 2010
You can add an entire Ribbon command group to the QAT. Just right-click an
area in the command group name (for example, Font) and choose Add to Quick
Access Toolbar.
Follow these steps to remove a command (including the default commands)
from the toolbar:
1. Right-click the command you want to remove from the toolbar.
2. Choose Remove from Quick Access Toolbar in the menu that appears.
If you think you’ll be adding a lot of commands to the QAT, it’s a good idea to
move the toolbar from the title bar to a separate location below the Ribbon.
Right-click anywhere on the QAT and choose Place Quick Access Toolbar below
the Ribbon in the menu that appears. You can regain screen area for working in
the worksheet by hiding the Ribbon controls temporarily.
You can access commands on the Quick Access toolbar using the keyboard.
Press the Alt key and then a number key that represents the KeyTip for the
command you want to access. See also “Tipping off your keyboard,” earlier in
this part.
Going Backstage
E
X
C
E
L
2
0
1
0
Excel 2010 introduces a new view for working with documents called the
Backstage view. This view is accessed by clicking the File tab on the Ribbon.
See Figure 1-7.
The Backstage view consolidates all document management tasks, such as
opening, closing, and sharing files; printing; and setting document properties. In
previous versions of Excel, many of these tasks were scattered all over the user
interface.
On the left side of Backstage view is a navigation pane that consists of a mix of
quick command buttons (such as open, close, and save) and vertically aligned
tabs (Info, Recent, New, Print, Send & Save, and Help). The buttons execute com-
mands directly, and the vertical tabs, like traditional horizontal tabs, expose a
set of options. If you don’t have any workbooks currently open, some of the but-
tons and tabs will be disabled.
A distinguishing feature of Backstage view is that while you work in this view,
no part of the worksheet is visible. Also, Excel minimizes the Ribbon (assuming
that you haven’t previously minimized the Ribbon yourself). To return to the
worksheet display view, click any Ribbon tab or press Esc.
03_527559-ch01.indd 1403_527559-ch01.indd 14 4/1/10 6:59 PM4/1/10 6:59 PM