Page Breaks in Excel Won’t Go Away? How to Fix Them

Page Breaks in Excel Won't Go Away? How to Fix Them

If page-break lines in Excel won’t go away, switch to View > Normal to leave Page Break Preview, or hide the indicators in File > Options > Advanced by clearing Show page breaks for the affected worksheet. If you need to change the printed pages too, use Page Layout > Breaks > Reset All Page Breaks to remove manual breaks; automatic breaks are recalculated from the sheet’s print settings.

Why Excel keeps showing page breaks

Excel is showing where worksheet content is divided into pages for printing. That division can appear as blue lines in Page Break Preview or as dotted lines on a worksheet in Normal view, often after you print or open the print preview. The lines can look like cell borders, but they are page-break indicators, not formatting applied to the cells.

There are two important distinctions. First, changing the worksheet view or hiding the indicators changes what you see on screen, not necessarily the printed output. Second, some breaks are manual, meaning someone inserted or moved them, while others are automatic, meaning Excel calculated them to fit the current paper size, margins, scaling, and printable area. Automatic breaks are a normal part of pagination, so there may always be page boundaries even after you remove manual ones.

That is why one fix does not suit every case. If the goal is simply to stop seeing dotted lines while editing, hide the display. If an unwanted boundary is splitting a report across pages, adjust the break or the print layout. If you want to remove a particular manual break, delete that break rather than changing the whole worksheet’s view.

Hide the lines without changing the printout

In Excel for Microsoft 365 on Windows, the display option is set per worksheet. Select the sheet where the lines appear, then follow these steps:

Select File > Options.
In the Excel Options window, select Advanced.
Scroll to Display options for this worksheet. If the workbook has several sheets, use the dropdown to select the affected sheet.
Clear Show page breaks, then select OK.

The dotted indicators should disappear from that sheet in Normal view. This setting does not erase manual breaks and does not tell Excel to print the worksheet on one page. It only hides the on-screen page-break display. If you later need to see where pages will split, return to the same option and check Show page breaks, or inspect the worksheet in Page Break Preview.

A faster visual fix is to select View > Normal if the worksheet is currently in Page Break Preview. This returns to the ordinary grid view, but dotted page-break lines may still appear if their display is enabled. In other words, changing views and hiding the indicators are related but separate actions.

Remove a manual page break

If the blue boundary is forcing a print split in the wrong place, remove the manual break. In Page Break Preview, manual breaks are generally shown as solid blue lines, while Excel’s automatic boundaries are shown as dashed lines. The visual style can be easier to interpret in Page Break Preview than in Normal view.

To remove one manual break, select a cell below a horizontal break or to the right of a vertical break. Then choose Page Layout > Breaks > Remove Page Break. For a horizontal line between rows 20 and 21, for example, select a cell in row 21 before removing the break. For a vertical line between columns C and D, select a cell in column D. The break removal affects the relevant boundary; check the preview afterward to confirm the result.

If you are unsure which manual breaks have been added, or want to discard all of them on the active worksheet, select Page Layout > Breaks > Reset All Page Breaks. This clears manual page breaks on that sheet. It does not remove the worksheet’s data, cell formatting, print area, or automatic pagination. Excel may show boundaries again because it still needs to divide the printable content into pages.

Resetting all breaks can be more disruptive than removing a single one. If a carefully formatted report uses deliberate page divisions, resetting them may undo that layout. Consider saving a copy first or using the single-break command when you know which boundary is causing trouble.

Automatic breaks and why they return

Excel calculates automatic page breaks based on the printable dimensions of the worksheet. The paper size, printer settings, page orientation, margins, scaling, and amount of content all affect how many rows or columns fit on a printed page. Change one of those settings and Excel may recalculate the breaks, making the lines appear in different places.

Automatic breaks cannot be permanently removed in the same way as manual breaks: Excel must still determine where one printed page ends and another begins. For example, a wide table may need several pages across, while a long table may need several pages down. Resetting manual breaks does not stop that pagination. If an automatic break makes a report awkward, change the layout that determines the available printable space or adjust the content.

To review the printed division, select View > Page Break Preview. You can see the page boundaries and, where supported, drag a break to change the page division. Remember that moving a boundary can affect how much material appears on each page. A large amount of content squeezed onto one page may become too small to read, so inspect the preview at a useful zoom level and check the actual print preview before printing.

Check print area, margins, and scaling

When breaks keep appearing in inconvenient places, the cause may be the print setup rather than a stuck display setting. A defined print area can limit what Excel prints, while margins and scaling determine how that area fits on paper. Review the settings before repeatedly inserting and removing breaks.

Print area: Select Page Layout > Print Area > Clear Print Area if an old selection is restricting the intended output. Set a new print area only if you want Excel to print a specific range.
Orientation and paper size: On the Page Layout tab, check Orientation and Size. Landscape orientation can give a wide table more room across the page, but it does not necessarily solve a long vertical report.
Margins: Use Page Layout > Margins to review the printable space. Narrower margins can fit more content, but leave enough room for printer limitations and any required notes or binding space.
Scaling: Check the Scale to Fit controls on the Page Layout tab. Setting width or height to a page count can shrink the sheet to fit that dimension. Use this carefully: fitting many columns or rows onto one page may make text difficult to read.

You can also open File > Print to inspect the preview and available scaling choices before printing. This is useful because hiding page-break indicators does not change the print result. If the preview still shows an unwanted split, address the page setup or the relevant manual break rather than relying on the display option.

When the lines seem to ignore your changes

If the lines remain after you change a setting, identify which sheet and view you are looking at first. The Show page breaks option applies to the worksheet selected in its dropdown, not automatically to every sheet in the workbook. A second sheet can therefore keep showing its own indicators. Select that sheet and repeat the setting change if you want the display hidden there too.

Next, check whether the worksheet is still in Page Break Preview. The blue page outlines and page labels in that view are part of the preview, so hiding dotted indicators in Normal view does not replace leaving the preview. Choose View > Normal, then check the worksheet-specific display option if dotted lines remain.

Also distinguish page breaks from borders and gridlines. A line that appears only at a page boundary and changes when you adjust print settings is likely a page-break indicator. A line that stays attached to particular cells may be a cell border or a table style. To investigate, select a cell along the line and inspect its formatting; do not remove cell borders simply because they resemble a page boundary.

Finally, confirm that you are changing the correct workbook and sheet. If the file is shared or has multiple similar tabs, it is easy to change one sheet and then look at another. After changing print layout, reopen the print preview because Excel may recalculate automatic breaks from the updated settings.

Excel on Mac and other versions

The menu names and locations can vary by platform. In Excel for Mac, switch out of Page Break Preview using the View tab or menu and choose Normal. The page-break display preference is generally under Excel > Preferences > View, where you can turn off the page-break display; in some releases, Preferences may be labeled Settings. The Windows path File > Options > Advanced is not the Mac path.

Page setup and break commands may also be arranged differently on Mac, but look for the Page Layout tab and its Breaks controls. If a command is unavailable or appears in a different place, use Excel’s command search or the Help menu for the installed version. The central distinction remains the same: hide indicators to change the screen, and edit breaks or page setup to change pagination.

Excel for the web and older desktop releases may not expose every print-layout control in the same way as Microsoft 365 for Windows. If you cannot find a break-management command in the browser, open the workbook in the desktop app to access its fuller page layout options. Avoid assuming that an absent or hidden line means the workbook has no page divisions; check print preview in the version you will use to print.

Frequently Asked Questions

Why do dotted page-break lines appear after I print?
Excel can display page boundaries in Normal view after printing or viewing print preview. Turn off Show page breaks for that worksheet in File > Options > Advanced, or use Page Break Preview only when you need to inspect pagination.

Does Reset All Page Breaks remove automatic breaks?
No. It removes manual breaks from the active worksheet. Excel continues to calculate automatic page boundaries from the current content and print settings.

Will hiding page breaks change what gets printed?
No. Hiding the indicators changes their on-screen display only. To change the printed pages, adjust manual breaks, print area, margins, orientation, paper size, or scaling, then review File > Print.

How do I remove just one page break?
Select a cell below a horizontal break or to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. Check Page Break Preview afterward to make sure you removed the intended boundary.

Why does the line disappear on one sheet but not another?
The page-break display setting is worksheet-specific. Select each sheet that needs the change and turn off Show page breaks for it using the worksheet selector in Excel Options.

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.