Chapter 7: Printing Your Work
7
Page Break Preview Allows you to adjust page breaks manually.Just click one of the icons to change the view. You can also use the Zoom slider to change
the magnification 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 dot-
ted 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.Page breaks aren’t displayed until you print (or preview) the worksheet at least one time. Page breaks are also dis-
played if you set a print area by choosing Page Layout ➪ Page Setup ➪ Print Area.
If you’d prefer not to see the page break display in Normal view, choose File ➪ Options and select the Advanced tab.
Scroll down to the Display Options for This Worksheet section and remove the check mark from Show Page Breaks.
This setting applies only to the active worksheet. Unfortunately, the option to turn off page break display is not on the
Ribbon, and it’s not even available for inclusion on the Quick Access toolbar.
Figure 7.1 shows a worksheet in Normal view, zoomed out to show multiple pages. Notice
the dotted lines that indicate page breaks.Page Layout view
Unlike the preview in Backstage view (choose File ➪ Print), Page Layout view is not a
view-only mode. You have complete access to all Excel commands. In fact, you can use Page
Layout view all of the time if you like.Figure 7.2 shows a worksheet in Page Layout view, zoomed out to show multiple pages.
Notice that the page header and footer (if any) appear on each page. If you’ve specified
any repeated rows and columns, they also display—giving you a true preview of the printed
output.