Excel 2010 Bible

Part I: Getting Started with Excel

172

of the default print settings (by using the Page Layout tab), Excel uses the new settings; otherwise,

it uses the following default settings:

l (^) Prints the active worksheet (or all selected worksheets), including any embedded charts
or objects
l (^) Prints one copy
l Prints the entire active worksheet
l (^) Prints in portrait mode
l Doesn’t scale the printed output
l (^) Uses letter-size paper with .75" margins for the top and bottom and .70" margins for the
left and right margins (for the U.S. version)
l (^) Prints with no headers or footers
l Doesn’t print cell comments
l (^) Prints with no cell gridlines
l 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 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.
Tip
To quickly determine the active area of the worksheet, press Ctrl+End to move to the last 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. n

Changing Your Page View .................................................................................................

Page Layout view, a feature introduced in Excel 2007, shows your worksheet divided up into

pages. In other words, you can visualize your printed output while you work.

Page Layout view is one of three worksheet views, which are controlled by the three icons on the

right side of the status bar. You could also use the commands in the View ➪ Workbook Views

group on the Ribbon to switch views. The three view options are

l (^) Normal: The default view of the worksheet. This view may or may not show page breaks.
l Page Layout: Shows individual pages.
l (^) Page Break Preview: Allows you to manually adjust page breaks.