Insert a Page Break
You can create manual page breaks in Normal view in Excel, but the Page Break Preview view enables you to see details such as the difference between an automatic page break and a manual page break. Excel denotes an automatic page break by a dashed line. It denotes a manual page break by a solid line. Now that you know what you’re looking for, complete the following steps to insert a manual page break in your workbook:
Edit a Page Break
You can edit page breaks in Excel in three ways: For a horizontal page break: Select the column to the right of where the break will be.
Move a specific page break.Delete a specific page break.Remove all manual page breaks.
Move a Specific Page Break
To move a specific page break, select the page break you want to move, and drag it to the new location.
Delete a Specific Page Break
To delete a specific page break:
Remove All Manual Page Breaks
To remove all manual page breaks, select Page Layout > Breaks > Reset All Page Breaks.
