Applies ToExcel 2013

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?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.