Excel Showing Page Break Lines? How to Hide Them

If Excel is showing page break lines, hide them in Microsoft 365 for Windows by choosing File > Options > Advanced, finding Display options for this worksheet, and clearing Show page breaks. To leave a view that emphasizes pagination, choose View > Normal; that changes the view, while the checkbox hides page-break guides in Normal view for the selected worksheet.

What Excel’s Page Break Lines Mean

Page break lines mark where Excel expects printed pages to end and the next page to begin. They are guides on the worksheet, not borders or formatting applied to your cells. Hiding them does not delete data, change cell contents, or by itself alter the printout.

Excel calculates automatic breaks from factors such as the sheet’s dimensions, paper size, page orientation, margins, scaling, and printer settings. If a worksheet is wider than one printed page, for example, Excel may show a vertical break between columns. A horizontal break indicates where one printed page ends before the next begins.

In Normal view, breaks are often shown as dotted lines. In Page Break Preview, Excel displays the printable pages and their boundaries more prominently, usually with blue lines and page numbers. The appearance can vary with the view and Excel release, but the key distinction is whether the line is an automatic guide or a break that has been manually set.

Automatic and Manual Breaks

An automatic page break is calculated by Excel. It can move if you change the print area, page setup, column widths, row heights, or scaling. A manual page break is one you add yourself to control where a printed page starts. In Normal view, automatic breaks typically appear dotted and manual breaks solid; Page Break Preview makes the distinction easier to inspect.

This is a common source of confusion: a dotted line appearing after printing or print preview does not necessarily mean someone inserted a permanent break. Excel may simply be showing where the current print settings divide the sheet. Conversely, a manually inserted break can remain even after the worksheet is resized, until it is moved or reset.

Hide the Lines in Excel for Windows

To hide the guides on one worksheet without changing its print setup, use the worksheet-specific display option:

Open File > Options.
Select Advanced.
Scroll to Display options for this worksheet.
Use the dropdown to choose the sheet whose lines you want to hide.
Clear Show page breaks, then select OK.

The setting applies to the worksheet chosen in the dropdown, not automatically to every sheet in the workbook. Repeat the steps for other sheets if needed. If you cannot find the checkbox, confirm that you have selected the intended worksheet in the dropdown and scrolled to the worksheet display options rather than the workbook display options.

This setting changes what you see on screen. It does not remove manual breaks or change how Excel paginates the sheet when printing. If you later turn the option back on, the guides can appear again because the underlying print layout remains.

Switch Back to Normal View

If the worksheet is covered by blue page boundaries, large page numbers, or gray areas outside the printable pages, it is probably in Page Break Preview. Choose View > Normal on the ribbon to return to the standard worksheet view. You can also use the view buttons near the lower-right corner of the Excel window, where available.

Changing to Normal view is often the quickest fix when you only want to work with the cells and do not need to adjust pagination. It does not erase manual page breaks. If dotted break lines still appear in Normal view, use the worksheet-specific Show page breaks option described above.

Page Layout view is a separate option. It shows a page-oriented view with margins and headers or footers, which can be useful for checking how the sheet will look on paper. It is not the same as hiding page-break lines in Normal view, and it may make the worksheet look more like a printed page rather than a regular grid.

Hide Lines on Excel for Mac or the Web

In Excel for Mac, first try View > Normal if the worksheet is in Page Break Preview. To hide break guides in Normal view, look in Excel’s Preferences or Settings under View for the Page breaks option; the exact wording and location can vary between Mac releases. Turn that option off for the display you want to change.

Excel for the web has a more limited set of page-layout controls than the Windows desktop application, and it may not provide the same Page Break Preview or worksheet display options. If the lines remain and you need to manage breaks precisely, open the workbook in the desktop Excel app. When you use a shared workbook, remember that a display preference is not the same as changing the workbook’s print layout.

Move, Add, or Reset Page Breaks

If the lines indicate an undesirable print division, hiding them only removes the visual guide. To change the pagination, use Excel’s page-break tools instead. First select the worksheet and, if useful, switch to View > Page Break Preview to see how the pages are divided.

Move a break: In Page Break Preview, drag a break line to a new position. This creates or adjusts a manual break and can change the page arrangement.
Insert a break: Select the row below where a new page should start, or the column to the right of where a new page should start. Choose Page Layout > Breaks > Insert Page Break. Selecting a cell rather than a full row or column can insert both a horizontal and a vertical break, depending on its position.
Remove a manual break: Select the row below the horizontal break, or the column to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. The exact selection matters, so inspect the break in Page Break Preview if the command does not remove the intended line.
Clear manual breaks: Choose Page Layout > Breaks > Reset All Page Breaks. This removes manually set breaks and returns pagination to Excel’s automatic arrangement; it does not delete worksheet data.

Resetting breaks is useful when a sheet has accumulated manual adjustments and the printed layout is difficult to understand. It may change page count or where content falls, so review Print Preview afterward. It is not the same as turning off the display of page-break guides.

Why Page Breaks Can Change Unexpectedly

Excel’s page divisions are tied to print settings, so a change that seems unrelated to the grid can move a break. Common causes include changing from portrait to landscape, selecting a different paper size, changing margins, modifying column widths, or choosing a scaling option such as fitting a sheet to a set number of pages.

Printer selection can matter too. Different printers or printer drivers may report different printable areas, and Excel uses that information when calculating breaks. A workbook can therefore show a slightly different page arrangement on another computer, even when its cells look identical. If the pagination matters, check it on the computer and printer that will produce the final output.

To diagnose a surprising break, check these settings before inserting manual breaks:

Open Page Layout and confirm the paper size, orientation, and margins.
Check Scale to Fit settings, including whether the sheet is being forced to fit a particular number of pages.
Review Print Area if Excel is printing only part of the worksheet or including an unexpected range.
Use File > Print to inspect the preview and page count before making further changes.

For example, a report that unexpectedly prints across two pages horizontally may have one or more columns extending beyond the printable width. Switching to landscape, reducing margins, or fitting the sheet to one page wide may help, but each choice affects readability. Shrinking a large table onto one page can make its text too small to read.

Check the Printout, Not Just the Worksheet

Page-break lines are useful indicators, but Print Preview is the better place to confirm what will actually print. Open File > Print and inspect each page. Look for clipped columns, blank pages, repeated headings, or content split in an awkward place. A line on the worksheet alone does not tell you whether the result is readable or whether the print area is correct.

If a table spans several pages, you can repeat heading rows or columns using Page Layout > Print Titles. This is different from inserting page breaks: print titles repeat selected labels on each printed page, while breaks determine where pages begin. Keeping a column heading visible on every page often makes a multi-page report easier to use without forcing all of the data onto a single sheet of paper.

Also distinguish page breaks from cell borders and gridlines. Borders are formatting attached to cells and can print if configured to do so. Worksheet gridlines are the faint cell guides; their on-screen and print settings are separate. Turning off page-break lines will not remove either borders or gridlines.

Frequently Asked Questions

Why are dotted lines suddenly showing in my Excel sheet?
Excel may have displayed them after you opened Print Preview or changed print settings. They usually indicate automatic page divisions for the active worksheet. Hide them with the worksheet’s Show page breaks option, or change to Normal view if you are in Page Break Preview.

Does hiding page-break lines change what prints?
No. The display option hides the guides on screen; it does not remove manual breaks or change the print area, scaling, or page setup. Check File > Print to verify the actual output.

How do I get rid of a solid page-break line?
It may be a manual break. Select the row below a horizontal break or the column to the right of a vertical break, then use Page Layout > Breaks > Remove Page Break. Use Reset All Page Breaks to clear manual breaks across the sheet.

Why does the line return after I hide it?
The setting is for a particular worksheet, so you may have switched to another sheet. Also, changing view or reopening the workbook can make the guides visible depending on the sheet’s display setting. Check the selected sheet’s Show page breaks option.

Can I turn off page breaks for every worksheet at once?
The Windows option is selected per worksheet through the Display options for this worksheet dropdown. There is no single checkbox there that applies the change to every sheet automatically; repeat it for each worksheet that needs a different display.

Are page-break lines the same as gridlines?
No. Page breaks show where printed pages are divided. Gridlines outline worksheet cells on screen and may have their own print setting, while cell borders are formatting. Each can be changed independently.

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.