View 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 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).

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×