Chapter 9: Printing Your Work
181
FIGURE 9.4
The Margins tab of the Page Setup dialog box.
Understanding page breaks .....................................................................................
When printing lengthy reports, controlling where pages break is often important. For example,
you probably don’t want a row to print on a page by itself, nor do you want a table header row to
be the last line on a page. Fortunately, Excel gives you precise control over page breaks.
Excel handles page breaks automatically, but sometimes you may want to force a page break —
either a vertical or a horizontal one — so that the report prints the way you want. For example, if
your worksheet consists of several distinct sections, you may want to print each section on a sepa-
rate sheet of paper.
Inserting a page break ...................................................................................
To insert a horizontal page-break line, move the cell pointer to the cell that will begin the new page.
Just make sure that you place the pointer in column A, though; otherwise, you’ll insert a vertical page
break and a horizontal page break. For example, if you want row 14 to be the first row of a new page,
select cell A14. Then choose Page Layout ➪ Page Setup ➪ Breaks ➪ Insert Page Break.
Note
Page breaks are visualized differently, depending on which view mode you’re using. See “Changing Your Page
View,” earlier in this chapter. n