Excel Page Break Lines Won’t Go Away? How to Hide Them

To hide page-break lines in Excel for Microsoft 365 on Windows, switch to View > Normal, then go to File > Options > Advanced and clear Show page breaks under Display options for this worksheet. The lines are worksheet guides, not marks that will print; hiding them does not change the printed pages.

The Quick Fix: Hide Page Breaks on the Worksheet

In Normal view, Excel can continue displaying page boundaries after you have used Print or Page Break Preview. To hide those boundaries, select the affected worksheet and change its display setting:

Click the worksheet tab where the lines appear. If you want to change several sheets, handle each one separately; the setting is for the selected worksheet.
Select File > Options > Advanced.
Scroll to Display options for this worksheet. If the workbook has multiple sheets, check the worksheet named in the section’s dropdown.
Clear Show page breaks, then click OK.

The gray or dotted boundaries should disappear from that sheet in Normal view. If you are currently looking at Page Break Preview, first select View > Normal; the checkbox controls whether page-break guides are shown in the worksheet view, while Page Break Preview is a separate view designed to display pagination.

Why Page-Break Lines Appear

Excel divides a worksheet into pages for printing. It calculates where one printed page ends and the next begins based on settings such as paper size, orientation, margins, scaling, print area, and the sizes of rows and columns. After you open Print or Page Break Preview, Excel may show the resulting page boundaries in the worksheet so you can see how the sheet will paginate.

Those guides can remain visible after you return to editing. That does not mean Excel is stuck in a printing mode, that the worksheet contains extra characters, or that the lines will appear on paper. They are a visual aid. Turning off Show page breaks hides the guides without removing data or changing the print setup.

Automatic Breaks and Manual Breaks Are Different

Excel uses automatic page breaks to fit a sheet across printed pages. It also lets you insert manual breaks to specify where a new page should begin. In Normal view, automatic boundaries are typically shown as dotted lines and manual ones as solid lines, although their appearance can vary with the view and Excel version. Their different appearance is a clue, not a change to the underlying distinction.

Automatic breaks are calculated by Excel from the current page setup and worksheet dimensions. They can move when you change the paper size, margins, scaling, print area, or row and column sizes.
Manual breaks are user-set pagination instructions. They can keep affecting the printed layout until you remove or reset them, or until other print settings change how the sheet fits.

Hiding the displayed lines is not the same as removing manual breaks. If the lines are distracting but the current print layout is correct, hide them. If you want Excel to recalculate pagination without your manually inserted boundaries, reset the breaks instead.

Remove Manual Breaks Without Changing the Display Setting

To clear manual breaks on a worksheet in Windows, select that sheet and use Page Layout > Breaks > Reset All Page Breaks. This removes manual page-break instructions and lets Excel calculate the layout again. It does not switch off the display of page breaks, so automatically calculated boundaries may still be visible in Normal view.

That distinction explains a common frustration: choosing Reset All Page Breaks may make a solid line disappear, yet dotted lines remain. Those remaining lines can be normal automatic page boundaries. To hide them, use the worksheet’s Show page breaks setting. Conversely, unchecking that option can hide the guides while leaving manual breaks in place for printing.

If you only want to remove one manual break, select a cell immediately below a horizontal break or immediately to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. The selection matters: Excel removes the break associated with the selected cell. If the command is unavailable or does not seem to affect the line, check whether the line is automatic rather than manual.

When the Lines Come Back

First check that you changed the correct worksheet. A workbook can have many sheets, and the Display options for this worksheet section applies to the sheet selected there. If the lines appear on another tab, select that tab and review its setting as well. Also confirm that Excel is in Normal view rather than Page Break Preview.

If the lines return after printing or reopening the file, revisit Show page breaks for the affected sheet. The setting is associated with the worksheet and workbook rather than being a single universal switch for every sheet you open. A copied sheet, a different workbook, or a sheet that was not selected in the options dialog can therefore still show guides.

Another possibility is that what looks like a page-break line is not one. Gridlines are the faint cell boundaries across the sheet; borders are formatting applied to cells; and page-break guides mark print-page boundaries. If a line continues through areas that do not match page dimensions, inspect cell borders and gridline settings rather than resetting breaks. A quick way to check is to change to Page Break Preview: genuine page boundaries become easier to distinguish from ordinary cell formatting.

Print Settings Can Change the Break Locations

If your goal is to make the printed worksheet fit better, hiding the lines is not a solution to pagination. Change the print setup instead. On the Page Layout tab, review Orientation, Size, Margins, and the scaling options in Scale to Fit. A wider paper size or landscape orientation may reduce the number of pages across; reducing scaling can fit more content on a page, but can also make text too small to read.

For a worksheet that should print only a particular range, select the cells and use Page Layout > Print Area > Set Print Area. An old or unintended print area can make the apparent page layout seem surprising. Use Page Layout > Print Area > Clear Print Area if you want Excel to consider the broader worksheet again. Check Print Preview before printing, since the preview reflects the actual paper and scaling choices better than the editing view.

For example, a report that prints four pages wide may show several vertical page boundaries in Normal view. Switching to landscape or choosing a fit-to-width setting can reduce that page count, but it can shrink the content. If the report already prints correctly and the only problem is visual clutter while editing, leave its print settings alone and simply turn off the page-break display.

Excel for Mac and Excel for the Web

In Excel for Mac, switch to Normal view from the View tab, then look for the page-break display setting under Excel > Preferences > View (the wording may appear as Settings in some releases). Clear Show page breaks for the relevant worksheet. The precise arrangement of preferences can differ between Mac releases, but the goal is the same: disable the display guide, not the page layout itself.

Excel for the web has fewer desktop page-setup and break-management controls. If you cannot find the worksheet checkbox or the Breaks commands there, open the workbook in the desktop Excel app and make the change in that version. Printing or viewing a print preview in a browser is not necessarily the same as changing the persistent display of page-break guides in the desktop worksheet.

What Hiding the Lines Does—and Does Not Do

Turning off Show page breaks changes what you see while working in the sheet. It does not delete rows, columns, formulas, or values; it does not remove manual breaks; and it does not change the number of pages Excel prints. Likewise, resetting breaks changes pagination instructions but does not erase worksheet content.

These controls are useful for different situations. Hide the lines when they obstruct reading or editing. Remove a particular manual break when it forces an unwanted page boundary. Reset all manual breaks when you want Excel to recalculate the layout. Adjust page setup when the printed result itself needs to change. Keeping those goals separate prevents a display fix from accidentally becoming a print-layout change.

Frequently Asked Questions

Why are page-break lines still visible after I click Normal?
Normal view and the page-break display checkbox are separate controls. Return to Normal view, then clear Show page breaks under File > Options > Advanced for the affected worksheet.

Will hiding page breaks stop them from printing?
No. Page-break guides do not print, and hiding them only changes the worksheet display. Excel still uses its automatic and manual breaks when it paginates the sheet for printing.

Why do dotted lines remain after Reset All Page Breaks?
Reset All Page Breaks removes manual breaks, but Excel still calculates automatic breaks. Hide those guides with the worksheet’s Show page breaks option if you do not need to see them.

Can I remove page breaks without hiding the lines?
You can remove a manual break with Page Layout > Breaks > Remove Page Break, or reset all manual breaks with Reset All Page Breaks. Automatic breaks are recalculated from print settings rather than removed as fixed instructions.

Do I need to change every worksheet?
If multiple sheets show the guides, check the setting for each affected sheet. The options dialog identifies the worksheet whose display settings you are changing; do not assume one change covers every tab in the workbook.

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.