Move a page break

Page breaks automatically divide your worksheets into separate pages when you print. If you’re not happy with where the page breaks are, you can move them.

  1. Click View > Page Break Preview.

Page Break Preview button

  1. Drag a page break to a new spot in your worksheet.

  2. Do this until the page breaks are where you want them, and then click View > Normal.

If you can’t move a page break, try this:

  1. Click File > Options > Advanced.

  2. Under Editing options, check Enable fill handle and cell drag-and-drop, and then click OK.

You can also delete a page break.

What do page breaks look like?

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!