When you print a workbook, Excel determines the page breaks based on the paper size, the margins, and the selected print area. To make the pages look better and to break information in logical places, you might want to override the automatic page breaks with your own breaks. However, before you add page breaks, try these options:
Adjust the widths of individual columns to make the best use of space.
Consider printing the workbook using the Landscape orientation.
Change the left, right, top, and bottom margins to smaller values.
After trying these options, if you still want to insert page breaks, Excel offers you an option of previewing exactly where the page breaks appear and then adjusting them. Follow these steps:
Select the View menu and select Page Break Preview .
If a message appears telling you how to adjust page breaks, click OK . Your worksheet is displayed with page breaks, as shown in Figure 14.7.
Figure 14.7. Check your page breaks before printing your worksheet.
To move a page break, drag the blue line to the desired location.
To delete a page break, drag it off the screen.
To insert a page break, move to the first cell in the column to the right of where you want the page break inserted, or move to the row below where you want the break inserted. For example, to insert a page break between columns G and H, move to cell H1. To insert a page break between rows 24 and 25, move to cell A25. Then, open the Insert menu and select Page Break . A dashed line appears to the left of the selected column or above the selected row.
To exit Page Break Preview and return to your normal worksheet view, open the View menu and select Normal.
Once you have modified the page breaks, you may want to take a look at the pages in Print Preview (click the Print Preview button on the Standard toolbar). This allows you to see how well balanced the pages are in terms of the amount of printed data and white space on the page.