Move a page break
Important To enable dragging of page breaks to another location in a worksheet, make sure that the cell drag-and-drop feature is enabled. If this feature is not enabled, you may not be able to move any page breaks.
To verify that drag-and-drop is enabled, do the following:
Click the
File tab.
- Under Help, click Options.
- In the Advanced category, under Editing options, select the Enable fill handle and cell drag-and-drop check box, and then click OK.
- Select the worksheet that you want to modify.
- On the View tab, in the Workbook Views group, click Page Break Preview.
- Tip You can also click Page Break Preview on the status bar.
- Note If you get the Welcome to Page Break Perview dialog box, click OK. To not see this dialog box every time you go to Page Break Preview view, select the Do not show this dialog again check box before you click OK.
- To move a page break, drag the page break to a new location.
Note: Moving an automatic page break changes it to a manual page break.
Delete a manually-inserted page break
Note You cannot delete page breaks that Excel has added automatically. Adding manual page breaks, changing the page orientation, or adjusting column widths and row heights may affect automatically-inserted page breaks.
To delete a manually-inserted page break, do the following:
- Select the worksheet that you want to modify.
- On the View tab, in the Workbook Views group, click Page Break Preview.
Tip You can also click
Page Break Preview on the status bar.
Note If you get the
Welcome to Page Break Perview dialog box, click
OK. To not see this dialog box every time you go to Page Break Preview view, select the
Do not show this dialog again check box before you click
OK.
- Do one of the following:
- To delete a vertical page break, select the column to the right of the page break that you want to delete.
- To delete a horizontal page break, select the row below the page break that you want to delete.
Note You cannot delete an automatic page break.
×