Add a page break

Page breaks divide worksheets into separate pages when you print. Excel automatically puts breaks in your worksheets, but you can add your own so the worksheets print the way you want.

  1. Click View > Page Break Preview.

Page Break Preview button

  1. Select the row below or column to the right of where you want to insert a page break.

  2. Right-click in the row or column, and then click Insert Page Break.

  3. Do this until you have the page breaks you want, and then click View > Normal.

Tip:  If you still see page breaks, try closing and reopening the workbook.

After you add page breaks, you can always move them to different places in your worksheet.

What’s the difference between dashed and solid lines?

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

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!