Excel Turn Off Page Break Lines on Screen

To turn off page break lines in Excel for Microsoft 365 on Windows, choose File > Options > Advanced, find Display options for this worksheet, and clear Show page breaks. If you are seeing blue page boundaries in Page Break Preview instead, switch to View > Normal; hiding the lines changes the worksheet display, not how it prints.

What page break lines mean

Excel divides a worksheet into pages when it prints or creates a print-ready file. The page break indicators show where one printed page ends and the next begins. In Normal view, automatic breaks commonly appear as dashed lines, while a manually inserted break may appear as a solid line. In Page Break Preview, blue boundaries outline the pages, and page numbers may appear over the worksheet. These are different views of the same pagination problem, so the right fix depends on which lines you see.

Lines may appear after you use Print, open Print Preview, or change page setup because Excel has calculated where the current sheet will divide. A line is not normally part of your cell contents: it will not show as a border in the data itself, and it is not printed as a mark on the page. It is a visual guide to pagination. This distinction matters if you are trying to remove an unwanted line from a printed report rather than simply clear clutter from the screen.

Hide the lines in Excel for Windows

Open the worksheet that shows the page break lines.
Select File > Options, then choose Advanced.
Scroll to Display options for this worksheet.
If needed, use the drop-down list in that section to select the worksheet you want to change.
Clear Show page breaks, then select OK.

Return to the worksheet and check that the lines are gone. The option is associated with a particular worksheet, so hiding the breaks on one sheet does not necessarily hide them on every sheet in the workbook. If several sheets show the lines, repeat the setting for each one. You do not need to delete data, change cell borders, or alter the page setup just to hide the indicators.

Choose the right worksheet in the options

The Advanced page contains settings that can apply to different worksheets. The selector under Display options for this worksheet is easy to overlook: it determines which sheet the nearby Show page breaks checkbox affects. If you clear the checkbox while another sheet is selected, the worksheet you meant to change may still display its lines.

For example, if a workbook has sheets named January, February, and Summary, select February in the options section before clearing the setting if February is the sheet with the indicators. Then open Summary and repeat only if it also needs the change. This is useful in workbooks where one tab is designed for printing and another is used for calculations; you can keep the visual guidance where it helps and hide it where it distracts.

Normal view versus Page Break Preview

Before changing options, check the view mode. Choose View > Normal to return to the standard worksheet grid. If you were in Page Break Preview, this removes the blue page outlines and page-number overlays because those belong to the preview view. It does not erase manual page breaks or change the actual printed page layout.

If dashed or solid lines remain in Normal view, use the Show page breaks setting described above. Page Layout view is another display mode; it is intended to show the sheet in a page-oriented layout, so it may still make page boundaries apparent. Switching views is a display choice, not a print-setting fix. A useful check is to open Print Preview after hiding the lines: the preview should still show how Excel plans to paginate the worksheet.

Hiding indicators does not change printing

The checkbox hides page break indicators on the worksheet. It does not remove the page breaks Excel uses when printing, and it does not force a report onto one page. If your goal is to change the printed result, adjust the print layout instead. First look at Print Preview, because it shows the output more reliably than the worksheet grid alone.

To fit a wide table across fewer pages, select the Page Layout tab and review the Scale to Fit controls, such as Width and Height. Setting Width to one page can shrink columns to fit across a single printed page, though the text may become small. You can also choose a different orientation, adjust margins, or set a print area. These changes affect pagination, so review the preview afterward to make sure the result remains readable.

For instance, a table with twelve columns might spill onto two pages side by side in portrait orientation. Changing to landscape or fitting the sheet to one page wide can reduce that split. It may also reduce the printed font size. Hiding the page break lines alone would leave the two-page output unchanged, which is why it is important to distinguish screen appearance from print layout.

Remove or change a page break

If you want to alter pagination rather than conceal its indicators, use the controls on the Page Layout tab. Excel creates automatic breaks based on paper size, margins, scaling, and the amount of content. You can also insert manual breaks to control where a page ends. A manual break is useful when a group of rows should stay together, but it can create unexpected extra pages if the worksheet later changes.

To insert a manual break, select the cell below and to the right of where the break should be, then choose Page Layout > Breaks > Insert Page Break.
To remove a particular manual break, select a cell below or to the right of that break, then choose Page Layout > Breaks > Remove Page Break.
To clear manual breaks from the worksheet, choose Page Layout > Breaks > Reset All Page Breaks.

Resetting page breaks does not turn off their display. It removes manual break settings and lets Excel paginate the sheet automatically; automatic breaks can still be visible in Normal view if Show page breaks is enabled. Conversely, turning off that display option does not remove manual breaks. Keep these as two separate tasks: reset breaks to change pagination, or hide indicators to reduce on-screen clutter.

If the lines are still visible

When page break lines remain after you change a setting, work through a few checks rather than changing print settings at random:

Confirm that the worksheet is in Normal view and not Page Break Preview.
Reopen File > Options > Advanced and verify that the correct sheet is selected in Display options for this worksheet.
Make sure Show page breaks is cleared, then select OK to apply the change.
Check whether the line is actually a cell border. Page break indicators cross the sheet according to print pagination; borders are formatting attached to cells and may surround only a chosen range.
If you are viewing a different workbook or worksheet, repeat the setting there; it is not a universal switch for every open sheet.

A border can look like a page break when it runs across a row or column. To check, select a cell next to the line and inspect Home > Borders. Do not clear borders across a large range unless you are sure they are unwanted formatting; doing so can remove intentional table outlines. Page break indicators do not respond to border formatting, and removing a border will not hide a true pagination guide.

Excel for Mac and Excel for the web

In Excel for Mac, return to Normal view with the View controls if you are in Page Break Preview. For page break indicators in Normal view, open Excel > Preferences > View and clear the Page breaks option if it is available in your version. Menu labels and placement can vary slightly between Mac releases, but the relevant control is in Excel’s View preferences rather than the worksheet’s cell formatting.

Excel for the web has a different interface and does not provide the same Windows File > Options > Advanced path. If you cannot find a control to hide the indicators in the browser, open the workbook in the desktop app and use its display setting. The desktop setting affects what you see in the desktop worksheet; check the browser view separately if you regularly switch between the two environments.

Frequently Asked Questions

Does turning off page break lines change what gets printed?
No. It hides the guides on the worksheet. Print Preview and the printed output still follow the page size, margins, scaling, print area, and manual breaks configured for the sheet.

Why do page break lines appear after I print?
Excel may display the calculated page boundaries after pagination has been determined for printing or preview. Clear Show page breaks for that worksheet, or return to Normal view if you are seeing the blue outlines of Page Break Preview.

Can I hide page break lines on every worksheet at once?
The Windows option is set for the worksheet selected in Display options for this worksheet. Apply it to each sheet where you want the lines hidden; changing one sheet’s setting should not be assumed to change all the others.

Will resetting page breaks hide the lines?
No. Page Layout > Breaks > Reset All Page Breaks clears manual breaks and returns pagination to automatic breaks. Use the Show page breaks checkbox to hide indicators in Normal view.

Are the gray lines cell borders?
Not if they are page break indicators. They mark where Excel expects printed pages to divide. A cell border is formatting and may be removed through the Borders controls, but that will not change a genuine page break guide.

How do I make a worksheet print on one page?
Use the Page Layout scaling controls or Print settings to fit the sheet to the desired page count, then inspect Print Preview. Fitting a large sheet onto one page can make its contents difficult to read, so adjust orientation, margins, or the print area as needed.

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.