Microsoft Office Tutorials and References
In Depth Information
Going Backstage
A Tour of the Excel
Window
Average, Count,
Numerical Count,
Minimum, Maximum,
Sum
Show the result of a calculation on the selected cells. For example,
the Sum indicator shows the total of all the numeric cells that are
currently selected.
Upload Status
Does nothing (that we know of). Excel does show a handy indicator
in the status bar when you’re uploading files to the Web. However,
the upload status is always shown, and this setting doesn’t seem to
have any effect.
View Shortcuts
Shows the three view buttons that let you switch between Normal
view, Page Layout View (page 403), and Page Break Preview (page
411).
Zoom
Shows the current zoom percentage (like 100 percent for a
normalsized spreadsheet, and 200 percent for a spreadsheet that’s blown up
to twice the magnification).
Zoom Slider
Shows a slider that lets you zoom in closer (by sliding it to the right)
or out to see more information at once (by sliding it to the left).
Going Backstage
Your data is the star of the show. That’s why the creators of Excel refer to your
worksheet as being “on stage.” The auditorium is the Excel main window, which—as
you’ve just seen—includes the handy ribbon, formula bar, and status bar. Sure, it’s a
strange metaphor. But once you understand it, you’ll realize the rationale for Excel’s
Backstage view , which temporarily takes you away from your worksheet and lets you
concentrate on other tasks that don’t involve entering or editing data. These tasks
include saving your spreadsheet, opening more spreadsheets, printing your work,
and changing Excel settings.
To switch to Backstage view, click the File button that’s just to the left of the Home
ribbon tab. Excel temporarily tucks your worksheet out of sight (although it’s still
open and waiting for you). This gives it space to show extra information related to
the task you want to perform, as shown in Figure 14-14. For example, if you plan
to print your spreadsheet, Excel’s Backstage view has room to show a preview of the
printout. Or if you want to open an existing spreadsheet, Excel can show a detailed
list of files you’ve recently worked on.
To get out of Backstage view and return to your worksheet, just click the File button
again, or press Esc.
Excel Options
The Excel Options window provides a central hub where you can adjust how Excel
looks, behaves, and calculates (see Figure 14-15). To get to this window, choose
File Options.
Search JabSto ::




Custom Search