Remove a page break

If your worksheet isn’t printing correctly, it might have some extra page breaks in it. Removing misbehaving page breaks may help. There are two types of page breaks, manual page breaks that you add to the worksheet and automatic page breaks that Excel adds. You can remove the manual page breaks but you can’t remove the automatic ones.

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

Page Break Preview button

  1. Right-click a cell below or to the right of the manual page break you want to delete, and then click Remove Page Break.

Cell below or to the right of a manual page break

Tip:  To remove all manual page breaks at once, right-click any cell, and then click Reset All Page Breaks.

  1. Do this until you’ve removed all of the page breaks you want, and then click View > Normal.

Tip:  If you still see page breaks in Normal view, try closing and reopening the workbook.

If you remove all manual page breaks, Excel will add automatic page breaks at the end of each page because it needs them for printing.

How can I tell which page breaks were added manually?

In Page Break Preview, solid lines are breaks that were added manually. Dashed lines are page breaks Excel automatically added.

Manual and automatic page breaks

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!