Excel Page Break Dotted Lines: Meaning and Fixes Explained

Excel page break dotted lines mark where the worksheet is expected to split across printed pages. To hide them in Excel for Microsoft 365 on Windows, go to File > Options > Advanced, find Display options for this worksheet, and clear Show page breaks for the selected sheet.

What the dotted lines mean

A dotted line is Excel’s indication of an automatic page break: a boundary Excel calculates when it divides a worksheet into pages for printing. A horizontal line marks a division between rows, and a vertical line marks a division between columns. It does not change the worksheet’s cells, formulas, or data. It is a print-layout guide, not a cell border or a sign that something is wrong with the workbook.

In Normal view, Excel commonly shows automatic page breaks as gray dotted lines after you have viewed the sheet’s print layout or printed it. In Page Break Preview, the lines are easier to inspect: automatic breaks are generally shown as dashed blue lines, while breaks you add yourself appear as solid blue lines. The appearance can vary slightly with Excel’s display and version, but the key distinction is automatic versus manual.

Why the lines appear

Excel calculates page boundaries using the sheet’s printable area and settings. A change to the printer, paper size, margins, page orientation, print area, or scaling can move a boundary. For example, a worksheet that fits across one printed page in landscape orientation may require two pages across in portrait orientation. A different printer can also have different printable margins, which may affect pagination.

The dotted lines may become visible after you open File > Print and return to the worksheet. That does not mean Excel inserted a permanent break into your data. It has simply displayed the page divisions calculated for printing. If a line seems to cut through a table, it indicates where the current print layout would split the table unless you change the layout or add a manual break.

Excel’s automatic calculation is useful when a sheet is too large for one page, but it does not know which rows belong together. It may divide a long list between two pages or put a heading at the bottom of one page and its data on the next. Check the print preview before distributing a report, especially after changing page setup.

Hide dotted page breaks in Windows

The Windows setting controls whether Excel displays page breaks on the selected worksheet. Follow these steps:

Open the worksheet where the dotted lines appear.
Select File > Options.
Choose Advanced in the Excel Options window.
Scroll to Display options for this worksheet.
If necessary, use the worksheet dropdown to select the sheet you want to change.
Clear Show page breaks, then select OK.

The lines should disappear from that sheet’s Normal view. The setting is associated with the worksheet, so repeat the change for other sheets where you do not want the guides. Hiding them affects only the screen display; it does not remove page breaks, change the print layout, or prevent the sheet from printing across multiple pages.

If the worksheet is currently in Page Break Preview, return to View > Normal as well. Normal view is usually more comfortable for editing, while Page Break Preview is intended for adjusting printed page divisions. Switching views alone may not hide dotted lines that are enabled by the Show page breaks setting.

Change the setting on Mac or Excel for the web

In Excel for Mac, the preference is in a different place: open Excel > Preferences > View, then clear Page breaks if that option is available in your version. The wording and arrangement can differ between Mac releases. You can also use View > Normal to leave Page Break Preview, but that view change is separate from hiding page-break indicators.

Excel for the web does not provide the same Windows Excel Options dialog and worksheet-level checkbox. Its available print and view controls can differ from the desktop app. If you need to turn off the persistent page-break display and cannot find a matching control in the web interface, open the workbook in the desktop version of Excel and change the worksheet’s display setting there.

Automatic breaks versus manual breaks

Automatic breaks are calculated by Excel to fit the sheet to the current print settings. Manual breaks are boundaries that a person has inserted to control where printing starts on a new page. In Page Break Preview, dragging a break changes pagination; dragging an automatic boundary creates or adjusts a manual break. A solid line in that view therefore indicates a deliberate break rather than just a calculated boundary.

To add a break, select the row below where you want a horizontal break, or the column to the right of where you want a vertical break, then choose Page Layout > Breaks > Insert Page Break. Selecting a cell can insert both a horizontal break above its row and a vertical break to the left of its column. Use this when a report should start a new page at a particular heading or between logical groups.

A common misconception is that every dotted line can be deleted individually. Automatic breaks are recalculated, so Excel does not treat each one as a removable object. You can hide their display, change the page setup so they fall elsewhere, or add manual breaks to control pagination. If you inserted a manual break and want to undo that choice, select a cell in the relevant area and use Page Layout > Breaks > Remove Page Break. The menu also includes Reset All Page Breaks to clear manual breaks on the sheet and return to automatic pagination.

Adjust where printed pages split

If you want to fix the printout rather than merely hide the guides, open View > Page Break Preview. Excel shows the printable pages and their boundaries. You can drag a boundary to change how rows or columns are distributed. Then use File > Print to inspect the result before printing. This is particularly useful for a small report where one extra page or a split table would be inconvenient.

For broader layout changes, look at the controls on the Page Layout tab:

Orientation switches between portrait and landscape. Landscape can give a wide table more room across the page.
Size selects the paper size. Make sure it matches the paper or output format you intend to use.
Margins changes the space around the printable area. Narrower margins may fit more content, but text can become cramped.
Scale to Fit lets you set the printed width or height. For example, setting width to one page can prevent a wide table from spanning multiple pages, though it may shrink the text.
Print Area limits which cells are included in the printout. A selected range can be set with Page Layout > Print Area > Set Print Area.

Scaling is a trade-off: fitting a large sheet onto a single page can make it unreadable. If a report is too wide, consider landscape orientation or a smaller print area before shrinking everything. Also, when the sheet uses Fit to page scaling, Excel may disregard manual page breaks; review the resulting preview rather than assuming a manual break will control the final pages.

Diagnose unexpected page breaks

When a break appears in an odd place, first check the preview and the sheet’s page setup instead of deleting rows or changing the data. A break can be correct for the current paper size but surprising if the worksheet has a large used range, unusually wide columns, or a print area extending beyond the visible table.

Check the print area: Go to Page Layout > Print Area. If an old area includes blank or irrelevant columns, clear it and set the intended range again.
Check scaling: Look at the Width and Height choices in Page Layout > Scale to Fit. A setting such as one page wide can change where Excel divides the content vertically.
Check orientation and paper: Confirm that landscape or portrait and the selected paper size match the report you need.
Check for manual breaks: In Page Break Preview, look for solid boundaries. Use Remove Page Break or Reset All Page Breaks if those manual divisions are no longer wanted.
Inspect blank-looking areas: Formatting or content far from the main table may extend the worksheet’s used range and affect printing. Review the print preview to see whether those cells are included.

After changing any of these settings, review File > Print again. The preview is the practical check: it shows page count and how the selected print settings divide the sheet. A dotted line by itself does not guarantee that the printed result is wrong, and hiding it does not make the result better or worse.

Frequently Asked Questions

Do dotted page break lines print on the page?

No. The dotted lines are on-screen guides and are not printed as dotted borders. They indicate where Excel expects a printed page to end. The actual printout follows the page setup and print preview.

Why are page break lines still visible after I choose Normal view?

Normal view changes the worksheet view, but Excel can still show page-break indicators there. On Windows, clear Show page breaks under File > Options > Advanced for the relevant worksheet.

Can I remove an automatic page break?

You cannot remove an automatic break as a separate object. Adjust paper size, margins, orientation, scaling, or the print area to change where Excel calculates it. You can also hide its on-screen display.

What is the difference between a dotted and a solid line?

In Normal view, dotted lines usually indicate automatic page boundaries. In Page Break Preview, dashed boundaries are automatic and solid blue boundaries generally represent manual breaks. Use the preview to identify which type you are dealing with.

Will hiding page breaks stop Excel from splitting the worksheet when I print?

No. Hiding the guides changes only what you see while editing. To change the printed pages, adjust page setup or the print area, or insert and remove manual breaks 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.