Microsoft Office Tutorials and References
In Depth Information
• Scale with Document . If you select this option, then when you change the print
scale to fit in more or less information on your printout (page 410), Excel
adjusts the headers and footers proportionately.
• Align with Page Margins . If you select this option, Excel moves the header
and footer so that they’re centered in relation to the margins. If you don’t
select this option, Excel centers them in relation to the whole page. The only
time you’ll notice a difference is if your left and right margins are significantly
All these settings affect both headers and footers.
Sooner or later it will happen to you—you’ll face an intimidatingly large worksheet
that, when printed, is hacked into dozens of apparently unconnected pages. You
could spend a lot of time assembling this jigsaw printout (using a bulletin board and
lots of tape), or you could take control of the printing process and tell Excel exactly
where to split your data into pages. In the following sections, you’ll learn several
techniques to do just that.
One of Excel’s often overlooked but surprisingly handy features is manual page
breaks . The idea is that you tell Excel explicitly where to start a new page. For
example, you can tell Excel to start a new page between subsequent tables on a
worksheet (rather than print a page that has the end of the first one and the
beginning of the next).
To insert a page break, move to the leftmost column (column A), and then scroll
down to the first cell that you want to appear on the new page. Then, choose Page
Layout ➝ Page Setup ➝ Breaks ➝ Insert Page Break. You see a dotted line that indicates
the dividing lines in between pages (Figure 14-44).
Note: There’s no limit to how many page breaks you can add to a worksheet—if you have a dozen tables
that appear one after the other, you can place a page break after each one to make sure they all start on a
You can also insert page breaks to split your worksheet vertically into pages. This
is useful if your worksheet is too wide to fit on one page, but you want to
control exactly where the page break will fall. To do so, move to the first row, scroll to
the column where the new page should begin, and then choose Page Layout ➝ Page
Setup ➝ Breaks ➝ Insert Page Break.
You can remove page breaks one at a time by moving to an adjacent cell and
choosing Page Layout ➝ Page Setup ➝ Breaks ➝ Remove Page Break. Or you can clear them
all using Page Layout ➝ Page Setup ➝ Breaks ➝ Reset All Page Breaks.