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.
Click View > Page Break Preview.
Drag a page break to a new spot in your worksheet.
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:
Click File > Options > Advanced.
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.