Chapter 9: Printing Your Work
173
Just click one of the icons to change the view. You can also use the Zoom slider to change the mag-
nification from 10% (a very tiny, bird’s-eye view) to 400% (very large, for showing fine detail).The following sections describe how these views can help with printing.Normal view ...........................................................................................................
Most of the time when you work in Excel, you use Normal view. Normal view can display page
breaks in the worksheet. The page breaks are indicated by horizontal and vertical dotted lines.
These page break lines adjust automatically if you change the page orientation, add or delete rows
or columns, change row heights, change column widths, and so on. For example, if you find that
your printed output is too wide to fit on a single page, you can adjust the column widths (keeping
an eye on the page-break display) until the columns are narrow enough to print on one page.Note
Page breaks aren’t displayed until you print (or preview) the worksheet at least one time. Page breaks are also
displayed if you set a print area by choosing Page Layout ➪ Page Setup ➪ Print Area. n
When you choose File ➪ Print, Backstage View displays a preview of your printed output, 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).For one-click access to the Print Preview display, add a button to your Quick Access toolbar: Click the
downward-pointing arrow on the right of the Quick Access toolbar, and choose Print Preview from the
drop-down list. Excel adds the Print Preview icon (a dog-eared piece of paper with a magnifying glass)
to your Quick Access toolbar.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 quickly jump to a particular
page. The Show Margins button toggles the display of margins, and the 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
borders 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”).Using Print Preview