View page breaks

Page breaks divide worksheets into separate pages when you print. In Page Break Preview you can insert page breaks, move page breaks, or remove them:

  • Click View > Page Break Preview

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

Manual and automatic page breaks

Tip:  If you don’t want to change the page breaks, you can see what the printed pages will look like in Print Preview (File > Print).

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!