Excel Page Breaks Keep Appearing? How to Stop Them

Excel page-break lines keep appearing because Excel is showing where the worksheet will split across printed pages. To hide them in Excel for Microsoft 365 on Windows, choose File > Options > Advanced, find Display options for this worksheet, clear Show page breaks, and select OK. If you are looking at Page Break Preview, switch to View > Normal. These steps hide the guides; they do not necessarily change how the sheet prints.

What the page-break lines mean

A page break marks the boundary between one printed page and the next. Excel calculates these boundaries using the worksheet’s contents and print setup. In Normal view, breaks often appear as dashed lines after you have opened Print or printed the worksheet. In Page Break Preview, the sheet is shown divided into page-sized areas, with page numbers and draggable boundaries. The exact appearance can vary with the view and Excel version.

The lines are not cell borders and are not part of the data. They are guides for printing. A visible line may indicate an automatic break calculated by Excel, or a manual break someone added to control where a printed page starts. In Page Break Preview, a solid boundary typically indicates a manual break and a dashed one an automatic break.

This distinction matters: hiding page-break indicators solves a display annoyance, while changing or resetting breaks changes the worksheet’s print layout. If the printed pages are already correct, you may only need to hide the indicators. If pages split at inconvenient places, adjust the print setup or the breaks themselves.

Hide page breaks in Normal view

In desktop Excel for Windows, the Show page breaks option is attached to a particular worksheet. Use these steps on each sheet where the lines bother you:

Open the worksheet and select File > Options.
Choose Advanced in the Excel Options window.
Scroll to Display options for this worksheet. If the dropdown names another sheet, choose the sheet you want to change.
Clear Show page breaks, then click OK.

The page-break guides should disappear in Normal view. The setting does not remove manual breaks, change the print area, or guarantee that the sheet fits on fewer pages. It controls whether Excel displays the lines on that worksheet. If several tabs show the guides, repeat the procedure for each one. A workbook with many sheets may also have grouped sheets selected; check the sheet tabs before making other worksheet changes, since edits made while sheets are grouped can affect all selected sheets.

If the worksheet is currently in Page Break Preview, select View > Normal first. This exits the page-layout display, but it is different from clearing Show page breaks. If the guides return when you work in Normal view, use the Advanced setting as well.

Remove or reset manual page breaks

A manual page break is a print-layout instruction, not merely a visible guide. To remove one break, switch to View > Page Break Preview, 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. Excel removes the relevant manual break. The selected cell’s position matters: selecting a cell on the wrong side can make the command unavailable or target a different break.

To discard manual breaks across the worksheet, choose Page Layout > Breaks > Reset All Page Breaks. Excel then returns to automatically calculated page breaks. This does not mean there will be no boundaries; Excel still divides the printout into pages, and its automatic breaks may still be visible if page-break display is enabled.

Use Reset All Page Breaks when you want Excel to recalculate the layout from scratch, not as the first response to every dashed line. If only one printed page is awkward, removing or moving a particular manual break is less disruptive. If the worksheet’s print layout is important, note the current break positions or save a copy before resetting them.

Why the lines return after printing

Excel can show page-break guides after you view the print layout or print a worksheet. That often makes it seem as though the lines have been added again. In many cases, Excel is simply displaying its automatic page divisions in Normal view; the worksheet’s data has not changed. Clearing Show page breaks is the lasting display fix for that sheet.

Other changes can make the actual page boundaries move. Excel recalculates automatic breaks when relevant print settings or worksheet dimensions change. For example, changing from portrait to landscape, choosing a different paper size, changing margins, widening columns, or changing the scaling can alter how much content fits on a printed page. A different selected printer can also affect pagination because printer settings and printable areas can differ.

Manual breaks can remain in the workbook until removed or reset. So if a break keeps appearing in the same unexpected place, check whether it is manual before assuming the display option failed. Open Page Break Preview and inspect the boundary, or use Page Layout > Breaks to remove or reset it. Also remember that each worksheet has its own print layout and display setting; changing one tab does not automatically fix every tab.

Make the printed pages fit the way you want

If the lines reveal a real printing problem, decide first what the output should look like. A wide table that spills onto an extra page horizontally may need landscape orientation or a narrower print area. A long report may need to break between sections rather than halfway through a table. Hiding the lines will not solve either issue.

Check the print area: Choose Page Layout > Print Area to set or clear the range Excel should print. An old print area can exclude new rows or include unwanted columns.
Review orientation and paper size: Use Page Layout > Orientation and Page Layout > Size. Confirm the paper size matches the printer or intended PDF output.
Inspect scaling: In Page Layout, review the Scale to Fit controls. Fitting all columns to one page can make text very small, even though it prevents horizontal page splits.
Adjust margins or content: The Page Layout > Margins menu can reclaim space, while shorter column widths or smaller nonessential content may improve readability.
Preview the result: Choose File > Print and review the preview before printing. Check several pages, not only the first one, for clipped columns, blank pages, and awkward breaks.

For example, a 12-column report that prints across two pages may be better in landscape orientation with a modestly narrower margin than forced onto one page at unreadable scale. Conversely, a short table that should fit on one page might have an unnecessary manual break or an oversized print area. Use the preview to judge the output, then adjust the relevant setting rather than treating every guide as an error.

When the usual fix does not work

If the lines remain, check these likely causes in order. First, confirm the worksheet is in View > Normal, not Page Break Preview. Second, make sure the correct worksheet is selected in the Display options for this worksheet dropdown when you clear Show page breaks. Third, check whether the boundaries are manual and remove or reset them if appropriate. Finally, reopen the workbook’s print preview to see whether the page layout itself is being recalculated because of a changed printer, paper size, or scaling option.

If one sheet behaves differently from another, that is not necessarily a workbook-wide fault: the display checkbox is worksheet-specific, and print settings can also vary by sheet. If the workbook is shared, another person may have added manual breaks or changed print settings. Saving a copy before removing breaks is prudent when you do not know why they were added.

Windows, Mac, and Excel for the web

The steps above use Excel for Microsoft 365 on Windows. In Excel for Mac, the setting is generally found under Excel > Preferences (called Settings in some releases) > View; look for Show page breaks. The wording and arrangement can differ by release. To leave Page Break Preview on a Mac, use the view controls on the ribbon and choose Normal.

Excel for the web has fewer desktop print-layout controls, and the available commands can differ from the Windows ribbon. If you need to manage manual breaks or change a worksheet’s page-break display setting and cannot find the control, open the workbook in the desktop app. The workbook’s print appearance may also depend on the printer or PDF settings used when it is eventually printed.

Frequently Asked Questions

Why do page breaks appear in Excel after I print?
Excel may display the worksheet’s page boundaries after printing or opening Print. The guides show where the content is divided for printing; they do not mean that Excel inserted cell borders. Clear Show page breaks for that worksheet to hide them.

How do I remove dotted lines in Excel without changing the printout?
In Windows desktop Excel, go to File > Options > Advanced, select the correct sheet under Display options for this worksheet, clear Show page breaks, and click OK. This hides the indicators without removing manual breaks.

Does Reset All Page Breaks delete data?
No. It resets manual page-break instructions on the worksheet so Excel can calculate the breaks automatically. It does not delete cell contents, although the resulting printed page divisions may differ.

Why do page-break lines still show after I turn them off?
Check that you changed the option for the correct worksheet and that you are in Normal view. Page Break Preview displays page divisions as part of its purpose, and another sheet has its own display setting.

Do page-break lines affect formulas or worksheet data?
No. They are print-layout guides and do not alter formulas or values. They can affect where pages split when printed, so review the print preview if the printed layout matters.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.