Excel Page Break Lines: How to Hide Them in Normal View

To hide page break lines in Excel for Microsoft 365 on Windows, go to File > Options > Advanced, scroll to Display options for this worksheet, and clear Show page breaks. The lines disappear from Normal view for that worksheet; this changes their display, not the way the worksheet is divided when printed.

Why page break lines appear in Normal view

Excel uses page breaks to show where worksheet content will fall across printed pages. After you open Print Preview, print a worksheet, or work with page layout settings, Excel may display those boundaries as dashed or dotted lines when you return to Normal view. They can be distracting when you are entering data, formatting cells, or reviewing a large table, but they are not marks in the cells and do not print as lines on the paper.

Normal view is the standard grid view, but it can still show print pagination as a visual guide. That is why changing back to Normal view does not necessarily make the lines go away. The setting that controls their visibility is separate from the view selector at the bottom of the Excel window.

Hide the lines in Excel for Windows

Use the worksheet-specific display setting to hide page break indicators while keeping the worksheet in Normal view:

Click the worksheet tab whose lines you want to hide. If several tabs are selected as a group, click one worksheet tab to work with a single sheet.
Select File > Options.
In the Excel Options window, select Advanced.
Scroll to Display options for this worksheet. If the workbook has multiple sheets, use the drop-down list in this section to choose the worksheet you are changing.
Clear the Show page breaks checkbox, then select OK.

The page break lines should no longer appear on the selected sheet in Normal view. If you still see them, check that the drop-down list was set to the sheet currently on screen and that the option was cleared rather than changed for a different worksheet.

The setting applies to individual worksheets

The phrase for this worksheet matters: the checkbox controls the selected sheet, not necessarily every sheet in the workbook. If the same lines appear on several tabs, repeat the steps and select each affected worksheet in the Advanced options list. This is useful when a workbook contains a print-ready report and a separate data-entry sheet: you can hide the guides on one without changing the other.

Hiding the lines does not remove page breaks from the worksheet. It only stops Excel from displaying the guides in Normal view. The worksheet retains its page setup, print area, scaling, and manual page breaks, so printed output should not change just because this checkbox was cleared. If you want to change where content prints, adjust the pagination or print settings instead.

Page break lines are not the same as manual breaks

Excel can place automatic page breaks based on the paper size, margins, scaling, and amount of content. You can also insert manual page breaks to control where a printed page ends. In Normal view, the lines indicate page boundaries; their appearance can vary, but the visual guides themselves are not objects that need to be deleted from cells.

This distinction resolves a common misunderstanding: hiding the guides is not the same as removing a break. If you only want a cleaner grid while editing, turn off Show page breaks. If a printed report starts a section on an unwanted page, change or remove the break itself. Removing a break may alter pagination, while hiding its indicator does not.

Remove or reset a manual page break

To remove one manual break in Excel for Windows, first identify the break in Normal view or Page Break Preview. Select the cell immediately below a horizontal break, or immediately to the right of a vertical break. Then select Page Layout > Breaks > Remove Page Break. The neighboring cell selection tells Excel which break you mean.

To remove manual breaks across the sheet, select Page Layout > Breaks > Reset All Page Breaks. This restores automatic pagination for that worksheet; it is different from unchecking Show page breaks. If the print layout is still not what you want after a reset, check the print area, paper size, orientation, margins, and scaling. For example, a worksheet set to fit all columns on one page may create very different page boundaries from a worksheet printed at its normal size.

Use the reset command carefully if someone deliberately added breaks to make a report easier to read. You can undo many worksheet actions with Ctrl+Z, but it is still sensible to inspect Print Preview after changing pagination, especially before printing a multi-page report.

When the lines return or do not disappear

If page break guides reappear after you hide them, verify the worksheet selection first. The setting is per sheet, and a workbook with similarly named tabs can make it easy to change the wrong one. Also confirm that you are viewing the workbook in Normal view; Page Break Preview is designed to show page boundaries, so hiding the Normal-view indicators is not a way to remove the boundary guides from that dedicated view.

Lines remain on one tab: Reopen Advanced options and make sure the worksheet drop-down names that tab.
The lines are solid or the print layout changes: You may be looking at manual page breaks or editing pagination, rather than merely viewing the Normal-view guides.
Content still prints on too many pages: Hiding the lines does not change print layout. Review scaling, margins, paper size, orientation, and the print area.
The checkbox is unavailable or missing: Check whether you are using Excel for the web or a version with a different interface. The Windows desktop Excel Options path is not identical across platforms.

To check the actual printed arrangement without changing the guide setting, use File > Print to review the print preview. This helps distinguish a cosmetic display issue from a pagination problem. If the preview is correct and the grid is simply cluttered, hiding the indicators is the appropriate fix.

Mac and Excel for the web

In Excel for Mac, open Excel > Preferences (called Settings in some releases), choose View, and clear Page breaks under the window display options. The labels and organization can vary slightly by Mac release, but look in the View preferences rather than Windows’ File > Options > Advanced dialog.

Excel for the web has a different feature set and does not use the same Windows Advanced-options path. If you need to change the desktop worksheet setting and cannot find an equivalent control in the browser, open the workbook in the Excel desktop application and use the steps for your operating system. The web app can still be useful for editing and viewing, but do not assume that a Windows ribbon path or dialog is present there.

Frequently Asked Questions

Do page break lines print in Excel?
No. The dashed or dotted guides shown in Normal view are display indicators, not cell borders or printed marks. They show where Excel expects pages to divide. If visible lines appear in the printed result, check for actual cell borders or other formatting.

Does hiding page break lines change my printout?
No. Clearing Show page breaks hides the guides in Normal view; it does not change the print area, page setup, or breaks. To change the printed pages, adjust those settings or insert, remove, or reset page breaks.

Why do page break lines appear after I print or open Print Preview?
Excel may display pagination guides in the worksheet after you have viewed or printed it. This is a visual aid for editing, not a sign that the worksheet has been altered. Clear Show page breaks for that sheet if you do not want the guides displayed.

Can I hide page break lines without removing the page breaks?
Yes. Clear Show page breaks in the worksheet’s Advanced display options on Windows. The breaks remain in effect for printing, but their guides are hidden in Normal view.

How do I remove all page breaks instead of hiding the lines?
On Windows, select Page Layout > Breaks > Reset All Page Breaks on the worksheet. That removes manual breaks and returns the sheet to automatic pagination; it does not merely hide the indicators.

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.