Add, adjust or remove page breaks in Excel using Page Break Preview. Also, learn how to reset and hide page breaks.

You can adjust where automatic page breaks occur and add your own page breaks manually. You can also remove manual page breaks, but you cannot remove automatic page breaks.

Adjust where automatic page breaks occur in a worksheet by adding your own page breaks manually. You can remove manual page breaks, but you can't remove automatic page breaks. However, you …

Page breaks divide worksheets into separate pages when you print. In Page Break Preview you can insert, move, or remove page breaks. Click View > Page Break Preview In Page Break Preview, …

You can insert page numbers for a worksheet in Page Layout view, where you can see them, or you can use the Page Layout > Page Setup dialog if you want to insert page numbers for more than one …

You can use section breaks to change the layout or formatting of pages in your document. To change formatting in a document, insert a section break at the beginning of where you want the change.

To see all the print areas to make sure they’re the ones you want, click View > Page Break Preview in the Workbook Views group. When you save your workbook, the print area is saved too.

It is a good idea to review the entire PivotTable in Page Break Preview, in case you need to make additional adjustments of the page breaks. You can insert new manual page breaks and move and …

Add manual page breaks or adjust page breaks automatically using options settings.

You can control the order in which worksheet pages are numbered and printed when the data does not fit on one page. By default, Excel prints pages from the top down and then left to right on the …