Excel Page Break Dashed Line: What It Means

An Excel dashed line usually marks an automatic page break: the boundary Excel currently expects to use when splitting a worksheet across printed pages. It does not change your cell data; it is a print-layout guide, and you can adjust the break, change the print settings, or hide the on-screen indicator.

What the dashed line means

Excel divides a worksheet into pages when it prepares a printout or PDF. A dashed line across rows or columns indicates where one printed page is expected to end and the next to begin. A horizontal break separates rows; a vertical break separates columns. In the usual worksheet view, dashed lines indicate automatic breaks that Excel calculates from the paper size, margins, orientation, scaling, and the printable area.

A page break is not the same as a border, gridline, or cell-formatting mark. It does not insert a blank row or column, and it is not printed as a dashed rule on the page. It is a visual cue on the screen. The actual printed result depends on the page setup and printer or PDF settings in effect when you print.

Excel can also have manual page breaks, which a user inserts or moves. These are generally shown as solid lines, while automatic breaks are dashed. The appearance can differ somewhat depending on the worksheet view, so check Page Break Preview if you need to distinguish or reposition the boundaries.

How Excel decides where pages end

Excel calculates automatic breaks from the dimensions of the printable page and the worksheet content. For example, a portrait-oriented page with narrow margins can fit more columns than a portrait page with wide margins. A long worksheet may need several horizontal breaks, while a wide worksheet may be split into multiple printed pages from left to right.

Several settings influence the calculation:

Paper size and orientation: Legal paper or landscape orientation can accommodate a different amount of content than letter paper in portrait orientation.
Margins: Larger margins reduce the space available for cells.
Scaling: Fit-to-page settings shrink a sheet to fit a chosen number of pages; a percentage scale changes its printed size too.
Print area: If a print area is set, Excel paginates that area rather than necessarily printing every used cell.
Row heights and column widths: Larger dimensions take up more page space and can move a break.

Consequently, a dashed line can move after you change one of these settings, even if you have not edited the values in the worksheet. Excel may recalculate the layout when you open Print, change the printer, or modify page setup. The worksheet view is a useful preview, but Print Preview is the better check of the final page arrangement.

Where to see page breaks

In Excel for Microsoft 365 on Windows, select View > Page Break Preview to see page boundaries more clearly. The view shows page regions and their numbering. You can return to the regular worksheet display with View > Normal. Another route to a print-oriented view is View > Page Layout, although Page Layout focuses on how the sheet sits on a page rather than on managing break boundaries.

After you have opened Print or Print Preview, Excel may also display page-break indicators in Normal view. This is why a dashed line can seem to appear unexpectedly after printing a worksheet. The indicators are a convenience for editing; they do not mean that Excel has altered the worksheet content.

On Mac, the workbook has comparable worksheet views and page-break controls, though the precise placement of some settings can differ by Excel release. Excel for the web has more limited page-layout and break-editing controls than the desktop application. If you cannot find a command or adjust a break in the browser, open the workbook in desktop Excel.

Move, insert, or remove a page break

To control exactly where a printed page starts or ends, use a manual break. On Windows, switch to View > Page Break Preview. To insert a horizontal break above a row, select that row; to insert a vertical break to the left of a column, select that column. Then choose Page Layout > Breaks > Insert Page Break. If you select a cell instead, Excel inserts breaks above and to the left of that cell.

In Page Break Preview, you can also drag a break boundary to a new position. This makes the selected boundary a manual break. Be aware that moving a break can change which rows or columns appear together on a printed page; it does not resize the cells themselves.

To remove an individual manual break, select the row below a horizontal break or the column to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. To clear manual breaks from the sheet, choose Page Layout > Breaks > Reset All Page Breaks. Resetting manual breaks allows Excel to calculate automatic breaks again; it does not erase data or formatting. These commands are not a way to delete the dashed automatic boundaries one at a time.

Hide the dashed lines without changing printing

If the lines are distracting while you edit, you can turn off their display without changing how the workbook prints. In Excel for Microsoft 365 on Windows, select File > Options > Advanced. Under Display options for this worksheet, choose the relevant sheet from the dropdown if necessary, clear Show page breaks, and select OK.

This setting hides the worksheet indicators; it does not remove page breaks, change the print area, or make a multi-page sheet fit on one page. You can still check the output through Print Preview. The option is associated with the selected worksheet, so verify that you are changing the sheet where the lines are visible. On Mac, look in Excel’s view or preferences settings for the page-break display option; wording and location may differ between versions.

If the goal is to change the printed layout rather than merely reduce screen clutter, adjust the page setup instead. For example, choose Page Layout > Orientation > Landscape to give a wide table more horizontal room, or review Page Layout > Margins. Use File > Print to inspect the result before printing or saving to PDF.

Why the line may appear in an awkward place

A break through a table or in the middle of a group of related rows is often the result of the available page area, not a damaged workbook. First check Print Preview to confirm the actual split. Then consider whether the print area includes unwanted blank or distant cells, whether a large row height is consuming space, or whether the selected paper size and orientation match the document you intend to print.

Common remedies include changing to landscape for a wide report, reducing margins, or scaling the sheet. In the Page Layout tab, the Scale to Fit controls let you set width and height to a number of pages, or adjust the scale. Setting the width to one page can keep columns together, but it may make text very small if the worksheet has many columns. Fitting both width and height to one page can make a long report difficult to read. Check legibility rather than treating a single-page printout as automatically better.

If an automatic line does not move as expected, check for manual breaks already set in the sheet. Use Page Break Preview and, if appropriate, Page Layout > Breaks > Reset All Page Breaks before judging the automatic layout. Also remember that printer drivers can report different printable areas, which can affect pagination. A PDF preview and a physical printer preview may not always paginate identically.

Example: keeping a report readable

Suppose a sales worksheet has twelve columns and enough rows to fill several pages. A vertical dashed line after column H tells you Excel currently expects the remaining columns to print on another page. If readers need to compare each month’s figures across the full row, that split may be inconvenient. Switching to landscape and reviewing Print Preview may let more columns fit across the page. If it still splits, reducing margins or setting the print width to one page may help, but inspect the resulting text size.

For the rows, a horizontal dashed line shows where Excel expects one page to end. If a section heading would be stranded at the bottom, you could insert a manual break above that section or adjust row heights and scaling. Then check the next page as well: moving one boundary can create an undesirable split elsewhere. A print layout is a series of trade-offs between page count, readability, and keeping related information together.

Frequently Asked Questions

Does the Excel dashed page-break line print?
No. It is an on-screen guide showing the expected page boundary. The printed page contains worksheet content, not the dashed indicator itself.

Why did a dashed line appear after I printed?
Opening Print or Print Preview can cause Excel to show page-break indicators in the worksheet. You can hide them through the worksheet’s Show page breaks setting; this does not change the print layout.

What is the difference between a dashed and solid page-break line?
Typically, a dashed line marks an automatic break calculated by Excel, while a solid line marks a manual break. Page Break Preview makes the break layout easier to inspect.

How do I get rid of a page-break line in Excel?
To hide the indicator, clear Show page breaks in Excel Options for the worksheet. To remove a manual break, use Page Layout > Breaks > Remove Page Break, or reset all manual breaks. An automatic break is recalculated from the page setup.

Will hiding page-break lines stop Excel from splitting the printout?
No. Hiding changes only what you see while editing. To change pagination, adjust page setup, scaling, the print area, or manual breaks, and confirm the result in Print Preview.

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.