Excel Page Break Not Going Away? Fix Persistent Lines

If an Excel page break will not go away, first switch to View > Normal; if the line still appears, turn off Show page breaks for that worksheet in File > Options > Advanced. A remaining line may also be an automatic print boundary, not a manually inserted break, so the right fix depends on what kind of line you are seeing.

Quick fixes for persistent page-break lines

Try these in order. They address the most common reasons page-break indicators remain visible in Excel for Microsoft 365 on Windows:

Open the affected worksheet and select View > Normal. If the lines disappear, the sheet was displaying Page Break Preview.
If dashed lines remain, open File > Options > Advanced. Under Display options for this worksheet, clear Show page breaks, then select OK. Confirm the correct worksheet is selected in the setting’s worksheet selector.
If you inserted a manual break and want to remove it, select a cell below a horizontal break or to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break.
To restore the sheet’s breaks to Excel’s automatic arrangement, choose Page Layout > Breaks > Reset All Page Breaks.

These actions do different things: changing the view or display option hides indicators, while removing or resetting breaks changes the worksheet’s page layout for printing. If a line returns after you print or open Print Preview, check the display option and print settings rather than repeatedly deleting breaks.

Why page breaks stay visible

Excel uses page breaks to divide a worksheet into pages when it is printed or exported to PDF. It can calculate these divisions automatically from the paper size, margins, orientation, scaling, and amount of content. You can also insert manual breaks to control where a page ends. Excel may show the boundaries on the worksheet after you have viewed Print Preview, even after you return to Normal view.

That is why “I removed the page break” does not always mean “the line disappeared.” Removing a manual break allows Excel to calculate a break at that location again if the sheet still needs one. And hiding page-break indicators does not remove the print pagination: the same worksheet can still print across several pages.

Page breaks are also worksheet-specific. If a workbook has several tabs, changing the display setting or resetting breaks on one sheet does not necessarily change the others. Check that you are working on the correct tab, especially if the workbook contains similarly named sheets or grouped worksheets.

Tell manual breaks from automatic breaks

Look at the worksheet in View > Page Break Preview. Excel displays the printable pages and their boundaries; manual breaks are generally shown as solid blue lines, while automatic breaks are generally dashed. In Normal view, page-break indicators usually appear as dashed lines. The appearance can be less obvious when the sheet is zoomed out, so use Page Break Preview to inspect the layout.

A manual break is one you or another user inserted to force a page to end at a particular row or column. An automatic break is Excel’s response to the current print setup. For example, a wide table may need several pages across, and a long list may need several pages down. If the break you removed was manual, Excel can still place an automatic break nearby.

Do not confuse page-break lines with gridlines, borders, or the edge of a selected print area. Gridlines form a repeated cell pattern; a page break marks a print boundary. A thick border is part of cell formatting, and a print-area outline indicates which cells are included when printing. Changing Show page breaks will not remove borders or alter the print area.

Remove a manual break or reset the sheet

To remove one manual break, first identify the row or column where it divides the page. For a horizontal break, click a cell in the row immediately below it. For a vertical break, click a cell in the column immediately to its right. Then select Page Layout > Breaks > Remove Page Break. If the command is unavailable or the line remains, it may be automatic rather than manual.

If you want Excel to recalculate all breaks on that worksheet, select Page Layout > Breaks > Reset All Page Breaks. This clears the worksheet’s manual page breaks and returns its pagination to automatic breaks. It does not hide the indicators, and it does not guarantee that all lines disappear: Excel still needs to show where the printed pages would divide.

Resetting can undo careful page layout work. Before using it on a report, check whether other manual breaks were intentionally placed to keep a heading with its table or to start a section on a new page. If you only want a cleaner editing view, use Normal view or turn off the display setting instead of resetting the layout.

Hide the indicators without changing printing

On Windows, select File > Options > Advanced. Scroll to Display options for this worksheet, choose the sheet from the dropdown if needed, clear Show page breaks, and select OK. This suppresses the page-break marks for that worksheet while leaving its print pagination intact. If the workbook is open on another computer, that copy may have different display behavior.

You can also work in View > Normal instead of Page Break Preview. Normal view is usually more convenient for entering data and editing formulas; Page Break Preview is useful when you need to see how the sheet is divided for printing. Switching views does not delete breaks. If the lines persist in Normal view, use the Advanced display option.

In Excel for Mac, switch to View > Normal to leave Page Break Preview. To hide persistent page-break indicators, open Excel > Settings (or Preferences in some versions) > View and clear the Page breaks option, if it is shown. Menu wording and the precise setting location can vary by Mac version. Excel for the web has a more limited set of desktop print-layout controls; if you cannot find the worksheet display setting, open the workbook in the desktop app.

Check print settings that create new breaks

If removing a manual break changes little, review the settings that determine how many pages Excel needs. Select Page Layout and inspect Orientation, Size, Margins, and the Scale to Fit controls. A portrait page has less horizontal space than a landscape page. Narrower margins or landscape orientation may fit more columns across, although the result depends on the paper size and the content.

Scaling can also affect page boundaries. Under Scale to Fit, setting Width to 1 page tells Excel to shrink the sheet’s columns to fit one page across; it does not necessarily make the whole worksheet one page tall. Setting Height to 1 page attempts to fit the sheet vertically as well, which can make text very small. Returning Width and Height to Automatic can restore more natural pagination. Check Print Preview before printing so you can see the practical result.

For example, a worksheet with twelve columns may show vertical page breaks when printed on portrait paper. Changing to landscape or fitting the width to one page may remove the need for multiple pages across. It will not necessarily remove horizontal breaks: if there are many rows, Excel can still divide them among multiple pages. The visible line reflects the current print setup, not a defect in the worksheet.

Also check whether a manual break is being obscured by a print setting. Fit-to-page scaling can change the layout you expected, and a change in paper size or printer settings can move automatic boundaries. When the printed result matters, use File > Print and inspect the preview after changing settings; do not rely only on how a line looks in the grid.

Review the print area and page layout

A print area determines which cells Excel includes in a print job; it does not itself remove page breaks. To clear an existing print area, select Page Layout > Print Area > Clear Print Area. To define a new area, select the desired cells and choose Page Layout > Print Area > Set Print Area. A different print area can change how many pages are needed, so the visible boundaries may move.

If a sheet prints unexpectedly, open File > Print and review the preview, selected printer, paper size, orientation, margins, and scaling choices. A printer may use a different printable region from another printer, even when the worksheet settings are unchanged. Exporting to PDF can also produce a different-looking result from a physical printer if the selected paper size or scaling differs.

Use Page Layout > Breaks > Insert Page Break only when you want to control pagination deliberately. Excel places a horizontal break above the selected row and a vertical break to the left of the selected column. A break inserted at a cell that is not at the top-left of a print page can create both a horizontal and vertical division. If that is not what you intended, remove the break or reset the sheet and inspect the layout again.

Common problems and practical checks

The line returns after reopening the file: The worksheet may still be set to display page breaks, or Excel may show them again after Print Preview. Turn off Show page breaks for the affected worksheet.
Remove Page Break does not help: The boundary may be automatic. Change the print layout or hide the indicators instead of trying to delete it.
Only one sheet is fixed: The setting and break layout are worksheet-specific. Repeat the relevant action on each sheet that needs it.
The printed pages still split: Hiding lines changes only the display. Adjust page setup, scaling, or manual breaks to change the printed pagination.
The page looks cramped after fitting it: Fitting too many columns or rows onto one page can shrink text. Consider landscape orientation, a larger paper size, narrower margins, or printing across more pages.

One frequent misconception is that page-break lines are worksheet content that can be erased like a border. They are layout indicators, and some represent automatic decisions Excel must make for printing. If your goal is simply to work without visual clutter, hiding the indicators is usually the least disruptive fix. If your goal is a specific printed result, adjust the breaks and page setup, then verify the preview.

Frequently Asked Questions

Why do page breaks appear in Excel after I print?
Excel can display page-break indicators after you use Print Preview or print a worksheet. They show where the current print layout divides the sheet. Switch to Normal view or clear Show page breaks in the worksheet’s Advanced display options to hide them.

Can I delete automatic page breaks in Excel?
Automatic breaks are calculated from the worksheet’s print settings, so there is no individual automatic break to delete. Change paper size, orientation, margins, or scaling to influence where they fall, or hide the indicators if you only want them off the screen.

Does Reset All Page Breaks remove every page boundary?
No. It removes manual breaks on the active worksheet and lets Excel paginate automatically. Automatic boundaries remain because Excel still divides the content into printable pages.

Will hiding page breaks change my printed worksheet?
No. Turning off Show page breaks or switching to Normal view hides the on-screen indicators; it does not alter the page layout used for printing. Use Page Layout settings and Print Preview to change or verify printed pages.

Why do I still see lines after switching to Normal view?
Normal view does not always suppress the worksheet’s page-break indicators. In Excel for Windows, go to File > Options > Advanced, select the relevant sheet under Display options for this worksheet, and clear Show page breaks.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.