Page 199 - Excel 2007 Bible

14_044039 ch10.qxp 11/21/06 11:03 AM Page 156
Part I
Getting Started with Excel
n Prints in portrait mode.
n Doesn’t scale the printed output.
n Uses letter-size paper with .75-inch margins for the top and bottom and .70-inch
margins for the left and right margins (for the U.S. version).
n Prints with no headers or footers.
n Doesn’t print cell comments.
n Print with no cell gridlines.
n For wide worksheets that span multiple pages, prints down and then over.
When you print a worksheet, Excel prints only the active area of the worksheet. In other
NOTE
NOTE
words, it won’t print all 17 billion cells — just those that have data in them. If the worksheet
contains any embedded charts or other graphic objects (such as SmartArt or Shapes), they’re also printed.
To quickly determine the active area of the worksheet, press Ctrl+End to move to the last
TIP
TIP
active cell in the worksheet. The active area is between cell A1 and the last active cell. You may
notice that Ctrl+End isn’t always accurate. For example, if you’ve deleted some rows, Ctrl+End will take you
to the last row that you deleted. However, when the sheet is printed, the active area is reset, so the empty
rows are not printed.
Using Print Preview
xcel’s Print Preview feature displays a worksheet exactly as it will be printed. To use Print Preview, choose
EFile ➪ Print ➪ Print Preview. Excel displays the first page of your printed output. To view subsequent
pages, choose Print Preview ➪ Preview ➪ Next Page (or, use the vertical scrollbar).
For easier access to Print Preview add a button to your Quick Access Toolbar (QAT) :
1. Click the downward-point arrow to the right of the QAT, which displays a menu.
2. Choose Print Preview from the menu. Excel adds the Quick Print icon to your QAT.
The Ribbon displayed in the Print Preview window has a few other commands that you can use while pre-
viewing your output. For example, choose Print Preview ➪ Preview ➪ Show Margins to display margins.
Excel adds markers to the preview that indicate column borders and margins. You can drag the column or
margin markers to make changes that appear on-screen.
Print Preview is certainly useful, but you may prefer to use the new Page Layout View introduced in Excel
2007. to preview your output (see “Changing Your Page View”). The Print Preview feature remains, but it prob-
ably won’t get much usage.

156