Controlling Where Pages Break

If your worksheet is too large to fit on one page, Excel splits the work over 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.

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 a dashed line. Onscreen, manual page breaks have longer, thicker dashed lines than automatic page breaks (see Figure 7.8).

Figure 7.8. Inserting a manual page break.


If you're using the Fit To page setup option, the manual page break does not appear.

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.


The Remove Page Break option appears in the Insert menu only when the cell pointer is in the correct cell, row, or column. Be sure to click in the right place to remove the page break.

    Part I: Excel Basics