Add, delete, or move page breaks

To print the exact number of pages that you want, you can use Page Break Preview view to quickly adjust page breaks . In this view, manually-inserted page breaks appear as solid lines. Dashed lines indicate where Microsoft Office Excel will break pages automatically.

Page Break Preview view is especially useful for seeing how other changes that you make (such as page orientation and formatting changes) affect the automatic page breaks. For example, changing the row height and column width can affect the placement of the automatic page breaks. You can also make changes to the page breaks that are affected by the margin settings of the current printer driver.

1. On the View tab, in the Workbook Views group, click Page Break Preview.

   

   Tip You can also click Page Break Preview on the status bar.

2. Do one of the following:

   • To move a page break, drag the page break to a new location.

     Note Moving an automatic page break changes it to a manual page break.

   • To insert a vertical page break or a horizontal page break, select a row or column below or to the right of where you want to insert the page break, right-click, and then click Insert Page Break on the shortcut menu.
   • To remove a manual page break, drag the page break outside of the page break preview area.
   • To remove all manual page breaks, right-click any cell on the worksheet, and then click Reset All Page Breaks on the shortcut menu.
3. To return to Normal view after you finish working with the page breaks, on the View tab, in the Workbook Views group, click Normal.

   Tip You can also click Normal on the status bar.

See also:

• Preview worksheet pages before printing
• Print a worksheet or workbook