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.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.