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

Need more help?

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

Was this information helpful?