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.

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