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.

In this article


Video: Delete or remove a page break in Excel

Watch the following video to learn how to delete or remove a page break in Excel.

Top of Page Top of Page

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:

  1. Select the worksheet that you want to modify.
  2. On the View tab, in the Workbook Views group, click Page Break Preview.

Excel  Ribbon Image

 Tip   You can also click Page Break Preview PageBreakPreview 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.

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

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

Excel  Ribbon Image

  1. 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).

Top of Page Top of Page

Remove all manually-inserted page breaks

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

  1. Click the worksheet that you want to modify.
  2. On the View tab, in the Workbook Views group, click Page Break Preview.

Excel  Ribbon Image

 Tip   You can also click Page Break Preview PageBreakPreview 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.

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

Excel  Ribbon Image

  1. Click Reset All Page Breaks.

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

Top of Page Top of Page

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.

Excel  Ribbon Image

 Tip   You can also click Normal Button image 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).

Top of Page Top of Page

 
 
Applies to:
Excel 2010, Excel 2007