If your worksheet is too large to fit onto one page Excel splits the work onto two or more pages. Excel makes the split based on your current page dimensions, margins, and cell widths and heights. Excel always splits the worksheet at the beginning of a column (vertically) and/or row (horizontally), so the information in a cell is never split between two pages.
An automatic page break appears as a dashed line with short dashes in your worksheet. These dashed lines run down the right edge of a column, as shown in Figure 46.4.
Figure 46.4. Automatic page breaks.
If the automatic page breaks are not right for your worksheet, one of the many ways to make adjustments is to override Excel's defaults. The worksheet still prints on two or more pages, but you can control where each new page begins.
Setting a Manual Page Break
As long as each page fits into the prescribed page size and margin setting, you can set a manual page break anywhere on the worksheet. Manual page breaks remain active until you remove them. Establishing new page breaks does not alter existing breaks; it simply adds to them.
To set a page break, click in any cell, row, or column where you want the break to appear. Click the Insert menu and choose Page Break. Excel inserts a manual page break, which is indicated by the page break dashed line. Onscreen, manual page breaks have longer, thicker dashed lines than automatic page breaks do.
To remove a manual page break, just select the cell, row, or column that was used to create the break and choose Insert, Remove Page Break.