Remove a page break

This article explains how to delete manually-inserted page breaks (represented by a solid line) by using Page Break Preview view. It also explains how to quickly remove all manually-inserted page breaks, and then return to Normal view.

In this article

Delete a manually-inserted page break

Remove all manually-inserted page breaks

Return to Normal view

Delete a manually-inserted page break

Note: You cannot delete page breaks that Excel has added automatically. Also, remember that manually inserting 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

  1. Select the worksheet that you want to modify.

  2. On the View tab, in the Workbook Views group, click Page Break Preview.

    Click Page Break Preview on the View tab

    This step makes the page breaks easier to see.

    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.

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

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

    Click Breaks on the Page Layout tab

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

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.

    Click Page Break Preview on the View tab

    This step makes the page breaks easier to see.

    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.

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

    Click Breaks on the Page Layout tab

  4. Click Reset All Page Breaks.

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

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.

    On the View tab, click Normal

    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 are turned on automatically. To turn them off, click the File tab, click Options, click the Advanced category, scroll down to the Display options for this worksheet section, and clear the Show page breaks check box.

Top of Page

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×