Inserting and Removing Page Breaks in Excel

When the data in your worksheet does not fit on one printable page, Excel automatically inserts page breaks, dependent on the page setup of the document (margins, paper size, etc.). The automatic page breaks appear as dashed lines on the worksheet. In the example below, any data after column E and row 50 will print on a separate page. You can adjust these page breaks manually by displaying your worksheet in Page Break Preview and then adjusting the page break borders by dragging the thick page break borders to a new location.

You can also insert a manual page break in your worksheet by clicking the Breaks button on the Page Layout tab and then choosing Insert Page Break from the menu. This will override the automatic page breaks.

To Insert a Manual Page Break

1. Click any cell below the row where you wish to insert a manual page break.
2. Click the Page Layout tab on the Ribbon.
3. Click the Breaks button under the Page Setup group.
4. Select Insert Page Break from the menu.

To Remove a Manual Page Break

1. Click the cell below the row where you inserted a manual page break.
2. Click the Page Layout tab on the Ribbon.
3. Click the Breaks button under the Page Setup group.
4. Select Remove Page Break from the menu.

To Remove all Manual Page Breaks

1. Click the Page Layout tab on the Ribbon.
2. Click the Breaks button under the Page Setup group.
3. Select Reset All Page Breaks from the menu.

Similar Posts:

None Found

Tagged as: Excel 2007 Tips, Microsoft Office Tips