Add, delete, or move page breaks

1. On the View menu, click Page Break Preview.

2. Do one of the following:

   View page breaks    Manually inserted page breaks appear as solid lines. Dashed lines indicate where Microsoft Excel will break pages automatically.

   Move a page break    Drag the page break to a new location. Moving an automatic page break changes it to a manual page break.

   Insert vertical or horizontal page breaks    Select a row or column below or to the right of where you want to insert a horizontal or vertical page break, right-click, and then click Insert Page Break.

   Remove page breaks    Drag the page break outside of the print area. To remove all manual page breaks, right-click any cell on the worksheet, and then click Reset All Page Breaks.