Adjust page breaks before printing

Important notice for users of Office 2003    To continue receiving security updates for Office, make sure you're running Office 2003 Service Pack 3 (SP3). The support for Office 2003 ends April 8, 2014. If you’re running Office 2003 after support ends, to receive all important security updates for Office, you need to upgrade to a later version such as Office 365 or Office 2013. For more information, see Support is ending for Office 2003.

Try Office 2010 In Excel 2010, new user interface has been added to make printing even easier.
Watch a video or try Office 2010!

To print the exact amount of pages you want, you can use the Page Break Preview view to quickly adjust page breaks (page break: Divider that breaks a worksheet into separate pages for printing. Excel inserts automatic page breaks based on the paper size, margin settings, scaling options, and the positions of any manual page breaks that you insert.). In this view, manually inserted page breaks appear as solid lines. Dashed lines indicate where Microsoft Excel will break pages automatically.

  1. On the View menu, click Page Break Preview.
  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 or 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.
  • To remove a 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.
Applies to:
Excel 2003