Show All

Hide All

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.

• Enlarging spread sheet for printing?
• When printing, I get 5 extra blank pages. How do I delete them?
• How can I move a page of my spreadsheet?
• How do I insert page breaks in .txt for use in excel?
• How do I set view page breaks as a default.