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 7-18).
Figure 7-18. Using a page break, you can make sure the second table (2006 Purchases) always begins on a new page. The dotted line shows where one page ends and the new page starts. When you add a page break, you see a dotted line for it, and you see a dotted line that shows you where additional ...