Excel Page Break Not Removing? How to Fix It

If an Excel page break will not go away, first check whether it is a manual break or an automatic page boundary: Excel lets you remove manual breaks, but automatic ones return when the sheet still needs to span multiple printed pages. In Microsoft 365 for Windows, select the cell immediately below a horizontal break or immediately to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break.

Why a page break can seem impossible to remove

Excel divides a worksheet into pages when it prepares the sheet for printing. Some boundaries are manual, meaning someone inserted a break to control where a new printed page starts. Others are automatic: Excel places them based on the paper size, margins, print area, scaling, and the amount of content. The two kinds can look similar in the worksheet, but they do not respond to the same fix.

A common source of confusion is the dotted line that remains on the sheet after printing or opening Print Preview. In Normal view, these lines can mark where Excel expects pages to end. They are often automatic page-break indicators, not manual breaks that need deleting. Removing a manual break does not prevent Excel from making another automatic boundary in roughly the same place if the layout still requires one.

It also helps to distinguish page breaks from page boundaries. A page boundary shows the edge of the printable page; it is not necessarily a break someone inserted. If the line appears only in a certain view, it may be a display guide rather than a change to the worksheet. Identifying which kind of line you are seeing prevents unnecessary changes to the print layout.

Remove one manual page break

Use the Page Break Preview view to locate the break before removing it. In Excel for Microsoft 365 on Windows, select View > Page Break Preview. The worksheet shows page divisions, with manual breaks generally shown as solid blue lines and automatic breaks as dashed blue lines. The exact appearance can vary with the view and Excel version, so use the line style as a clue rather than the only test.

For a horizontal break, click a cell in the row immediately below the break. For a vertical break, click a cell in the column immediately to its right.
Choose Page Layout > Breaks > Remove Page Break.
Check the page divisions again in Page Break Preview. If the break remains, confirm that the selected cell was on the correct side of the break and that it was a manual break.

For example, if a horizontal line divides rows 25 and 26, select a cell in row 26 before choosing Remove Page Break. If a vertical line divides columns C and D, select a cell in column D. Selecting a cell on the other side may target a different break or leave the intended one untouched. A break at the intersection of horizontal and vertical divisions can require removing each relevant break separately.

You can also work directly in Page Break Preview by dragging a break to a new position, but dragging changes where Excel divides the printed pages; it does not necessarily remove the break. Use the Breaks menu when the goal is specifically to clear a manual break.

Reset every manual page break

If you are unsure which manual breaks were added, or several are causing trouble, use Page Layout > Breaks > Reset All Page Breaks. This removes manual page-break settings on the active worksheet and lets Excel lay out pages automatically again. It is useful when the sheet has been edited repeatedly and its old breaks no longer match the current rows or columns.

Reset All Page Breaks affects the worksheet you are working on; it is not a command to hide page-break lines or erase content. It also does not guarantee a single printed page. Excel will still insert automatic breaks wherever the paper and scaling settings require them. If the sheet has a carefully arranged print layout, resetting all breaks can undo that work, so consider saving a copy or noting important break positions first.

Hide page-break lines that remain on screen

If your main problem is a dotted line in Normal view, you may not need to remove anything. On Windows, go to File > Options > Advanced. Under Display options for this worksheet, clear Show page breaks, then select OK. The setting applies to the selected worksheet, so repeat it for other sheets where you want to hide the guides.

This changes what Excel displays on screen; it does not change the printed pagination. The sheet will still print across multiple pages if its contents and page setup call for that. You can check the actual output with File > Print, where the preview shows how the worksheet is divided across pages.

On Excel for Mac, the equivalent display option is generally under Excel > Settings (or Preferences in some releases) > View, where you can turn off Show page breaks. Labels and locations can differ slightly between Mac releases. Excel for the web has fewer page-layout and display controls than the desktop application; if you cannot find the relevant break command, open the workbook in the desktop app.

Fix automatic breaks by changing the print layout

An automatic break cannot be permanently removed as if it were a manual one. Excel recalculates these boundaries when the sheet’s size or print settings change. To move an automatic boundary, adjust the layout so the content fits differently. In Page Layout view or Print Preview, make one change at a time and check the result rather than repeatedly inserting and removing breaks.

Check paper size and orientation. On the Page Layout tab, review Size and Orientation. A sheet set to portrait may need more pages across than the same sheet in landscape. The paper size selected in Excel should also match the paper loaded in the printer or chosen in the print dialog.
Review margins. Choose Page Layout > Margins and try a suitable preset or adjust the margins. Wider margins leave less printable space, which can push columns or rows onto additional pages.
Use scaling carefully. In the Page Layout tab’s Scale to Fit controls, set Width or Height to a specific page count when appropriate. Fitting a wide report to one page across can be helpful, but forcing both width and height to one page can shrink text until it is hard to read.
Inspect row heights and column widths. Oversized cells, wrapped text, or a few unusually wide columns can create extra pages. Adjust the relevant rows or columns if doing so preserves readability.

For instance, a report that spills onto a second page because its last column is just beyond the printable width may fit across one page in landscape orientation or with a modest width adjustment. That does not mean the page break was defective: Excel was responding to the available print area. If the font becomes too small after scaling, a two-page-wide printout may be more useful than forcing everything onto one page.

Check the print area and other layout settings

A defined print area can make a worksheet appear to have unexpected page divisions because Excel prints only the chosen range. To remove an existing print area on the active sheet, choose Page Layout > Print Area > Clear Print Area. You can then preview the full used range or set a new print area. Clearing it does not remove manual page breaks, so handle the two settings separately.

Also check whether rows or columns are hidden, whether the sheet contains content far beyond the visible table, and whether the print settings are set to print a selection or the entire workbook. A stray value or formatting far down the sheet can expand the area Excel considers when printing. Use the print preview to identify which pages contain content, then inspect the corresponding rows and columns in the worksheet.

Print titles are another separate feature. Repeating header rows at the top of each printed page does not create a manual page break, though it can affect how much room remains for data on each page. If a page seems to hold fewer rows than expected, check Page Layout > Print Titles as well as the break settings.

When the command is unavailable or appears not to work

If Remove Page Break is disabled or has no visible effect, verify that the active cell is adjacent to a manual break and that you are editing the intended worksheet. A protected sheet, restricted workbook permissions, or using Excel for the web instead of the desktop app can also limit which layout controls are available. If the workbook is shared or read-only, make sure you have permission to make and save changes.

Another possibility is that the line you are trying to clear is automatic. Try Reset All Page Breaks once if you want to remove manual breaks, then review the print layout. If a line still divides the page, change the page setup or hide the on-screen guide rather than trying the same removal command repeatedly. Remember that a break can disappear from the preview but still be represented by an on-screen indicator, or vice versa, because display and print settings are different.

For a reliable diagnosis, use this sequence: open Page Break Preview, identify the line, remove a manual break or reset all manual breaks, then inspect File > Print. If the pagination still does not meet your needs, adjust orientation, margins, scaling, or the print area. This separates the cause from the symptom and makes it easier to tell whether the worksheet or only its display has changed.

Frequently Asked Questions

Why does the page break come back after I remove it?
It is likely an automatic break. Excel recalculates automatic boundaries from the worksheet contents and print settings. Change the layout or hide the page-break display line; removing a manual break cannot stop automatic pagination.

Does Reset All Page Breaks delete data?
No. It clears manual page-break settings on the active worksheet. It does not delete cell contents, but it can change where pages end when you print.

How do I remove a dotted line in Excel?
If it is a page-break guide in Windows, clear File > Options > Advanced > Show page breaks for that worksheet. This hides the line on screen but does not change the printed pages.

Why is Remove Page Break greyed out?
You may have selected the wrong cell, be trying to remove an automatic break, or be using a protected or restricted sheet. Select a cell immediately below a horizontal manual break or immediately to the right of a vertical one, and try in desktop Excel.

Can I make the worksheet print on one page?
Yes, use the Scale to Fit controls on the Page Layout tab to fit the sheet to one page wide and one page tall. Check Print Preview afterward: a large worksheet may become too small to read, so fitting it to one page across or printing on several pages may be preferable.

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.