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. …

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 …

Use the Page Setup dialog box to set up layout and print options of a page. Click on the Page Layout tab, then in the Page Setup group, click the Dialog Box Launcher .

Use the controls on the Print Setup and Page Size tabs to make changes to the printer paper and the diagramming page view independently. A thumbnail preview on each tab shows how your …

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

You can also use page breaks to divide your worksheet into separate pages for printing. While Excel does add page breaks automatically (indicated by a dashed line), you can also insert, …

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 …

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 …