Remove a page break

You cannot delete breaks that Excel has added automatically (represented by a dashed line) but you can delete any manually-inserted page breaks (represented by a solid line) in Page Break Preview view. You can also quickly remove all the manually-inserted page breaks. After you finish working with page breaks, you can return to Normal view.

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 Preview 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.

On the Page Layout tab, in the Page Setup group, click Breaks.

Click Remove Page Break.

Tip You can also remove a page break by dragging it outside of the page break preview area (to the left or right for vertical page breaks, or up or down for horizontal page breaks). If you cannot drag page breaks, make sure that the drag-and-drop feature is enabled (File tab, Options, Advanced category, Editing options section).

Remove all manually-inserted page breaks

Note This removes all manual page breaks and resets the worksheet to display only the automatic page breaks.

Click 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 Preview 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.

On the Page Layout tab, in the Page Setup group, click Breaks.

Click Reset All Page Breaks.

Tip You can also right-click any cell on the worksheet, and then click Reset All Page Breaks.

Return to Normal view

To return to Normal view after you finish working with the page breaks, on the View tab, in the Workbook Views group, click Normal.

Tip You can also click Normal on the status bar.

Note After working with page breaks in Page Break Preview view, you may still see the page breaks in Normal view because page breaks have been turned on automatically. To turn them off, clear the Show page breaks check box in the Excel Options dialog box (File tab, Options, Advanced category, Display options for this worksheet section).