Part I: Getting Started with Excel
■ (^) Prints the entire active worksheet
■ Prints in portrait mode
■ (^) Doesn’t scale the printed output
■ Uses letter-size paper with 0.75-inch margins for the top and bottom and 0.70-inch
margins for the left and right margins (for the U.S. version)
■ Prints with no headers or footers
■ (^) Doesn’t print cell comments
■ Prints with no cell gridlines
■ (^) 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 work-
sheet contains any embedded charts or other graphic objects (such as SmartArt or shapes),
they’re also printed.
Using Print Preview
When you choose File ➪ Print (or press Ctrl+P), Backstage view displays a preview of your printed out-
put, exactly as it will be printed. Initially, Excel displays the first page of your printed output. To view
subsequent pages, use the page controls along the bottom of the preview pane (or use the vertical
scrollbar along the right side of the screen).
The Print Preview window has a few other commands (at the bottom) that you can use while preview-
ing your output. For multipage printout, use the page number controls to jump quickly to a particular
page. The Show Margins button toggles the display of margins, and Zoom to Page ensures that a
complete page is displayed.
When the Show Margins option is in effect, Excel adds markers to the preview that indicate column bor-
ders and margins. You can drag the column or margin markers to make changes that appear onscreen.
Changes that you make to column widths in preview mode are also made in the actual worksheet.
Print Preview is certainly useful, but you may prefer to use Page Layout view to preview your output
(see “Changing Your Page View”).
Changing Your Page View
Page Layout view shows your worksheet divided into pages. In other words, you can visual-
ize 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
Normal The default view of the worksheet. This view may or may not show page breaks.
Page Layout Shows individual pages.