Excel Page Break Lines: How to View and Remove Them

Excel page break lines mark where worksheet content will be divided across printed pages. To inspect them, choose View > Page Break Preview; to hide the lines in the normal worksheet view, go to File > Options > Advanced, find Display options for this worksheet, and clear Show page breaks. Hiding the lines changes only what you see on screen—it does not change how the sheet prints.

What Excel page break lines mean

A page break is a boundary between one printed page and the next. Excel calculates page boundaries from the paper size, page orientation, margins, print area, scaling settings, and the amount of worksheet content. Because a worksheet can be much larger than a sheet of paper, Excel may divide it into several pages horizontally, vertically, or both.

In Normal view, Excel may show page boundaries as dashed lines after you have opened Print or Print Preview. These indicate automatic page breaks: boundaries Excel has calculated to fit the current print setup. A manually inserted break is commonly shown as a solid line in Normal view. In Page Break Preview, blue lines show page boundaries; dashed blue lines are generally automatic, while solid blue lines indicate manual breaks. The display can vary somewhat with the view and Excel version, but the key distinction is whether a break is automatic or one you inserted.

Page break lines are not cell borders, gridlines, or worksheet content. They do not appear as marks on the printed page. They indicate where one page ends and another begins.

View page breaks and inspect the printed layout

For a clear overview of how a sheet will be divided, use Page Break Preview in Excel for Microsoft 365 on Windows:

Select the worksheet you want to inspect.
Choose View > Page Break Preview.
Review the blue page boundaries and the page numbers displayed over the sheet.
When finished, choose View > Normal to return to the usual worksheet view.

In Page Break Preview, the white regions represent printable pages, while gray areas are outside the current print area or page layout. A page number shown over a region is an on-screen guide, not worksheet data. You can also open File > Print to check the print preview and use its navigation controls to review individual pages before printing.

On a Mac, use the View tab to switch between Normal and Page Break Preview; ribbon labels can differ slightly by Excel release. The print preview is available through File > Print. Excel for the web has a more limited set of page-layout controls than the desktop app, so use desktop Excel if you need to manage manual breaks or inspect the full Page Break Preview workflow.

Hide page break lines without changing printing

If the lines are distracting while you work, turn off their display for the current worksheet. In Windows desktop Excel, open File > Options > Advanced. Scroll to Display options for this worksheet, select the appropriate sheet in the dropdown if necessary, and clear Show page breaks. Choose OK. This setting affects the worksheet display; it does not remove manual breaks or revise the printed layout.

On Mac, look under Excel > Preferences (called Settings in some releases) > View for the page-break display option. The exact wording or location can vary by version. If you cannot find it, switch to Normal view or check the View preferences for the selected worksheet. To see the boundaries again, select the option or return to Page Break Preview.

There is an important difference between hiding lines and removing breaks. Clearing Show page breaks suppresses the marks in Normal view, but Excel still uses its page layout when printing. If the actual page divisions are wrong, change the layout or break positions instead.

Insert, move, or remove a manual page break

Manual breaks let you choose where a page ends, which is useful when a table should not split between its heading and its rows. In Windows Excel, select a cell in the row below the desired horizontal break, or in the column to the right of the desired vertical break. Then choose Page Layout > Breaks > Insert Page Break. When a cell is selected, Excel inserts a horizontal break above its row and a vertical break to the left of its column; selecting a cell away from the worksheet edges can therefore insert both.

To move a break, switch to View > Page Break Preview and drag a solid blue boundary to a new row or column. Moving a boundary changes how content is divided, so inspect the page count and text size afterward. Excel may not let you drag a boundary beyond a limit imposed by the print area or page setup.

To remove a specific manual break, select a cell immediately below a horizontal break or immediately to the right of a vertical break, then choose Page Layout > Breaks > Remove Page Break. If you want to remove all manual breaks on the sheet, choose Page Layout > Breaks > Reset All Page Breaks. Resetting manual breaks does not remove automatic boundaries; Excel recalculates those from the current settings. Menu names and ribbon placement can differ slightly on Mac, but use the Page Layout tab’s Breaks controls where available.

Adjust automatic breaks through page setup

Automatic breaks cannot usually be dragged or removed one at a time. Excel recalculates them when the printable area or the amount of content changes. If the split is inconvenient, adjust the cause rather than trying to erase the dashed line.

Change orientation: In Page Layout > Orientation, choose Landscape for a wide table or Portrait for a tall, narrow report.
Change paper size: In Page Layout > Size, choose the paper stock your printer or destination supports. A larger sheet can fit more columns or rows on each page.
Adjust margins: In Page Layout > Margins, select a preset or open custom margin settings. Smaller margins provide more printable space, subject to printer limits.
Set scaling: In the Scale to Fit group on the Page Layout tab, set Width to 1 page if all columns must print on one page. Leaving Height set to Automatic allows the rows to continue onto additional pages.
Set a print area: Select the relevant cells, then choose Page Layout > Print Area > Set Print Area. This prevents unrelated rows or columns from extending the printed report.

Scaling is a trade-off. Fitting every row and column onto one page may make the text too small to read, especially in a large worksheet. For a wide data table, fitting the width to one page while allowing multiple pages in height is often more legible. Check File > Print after changing settings; the preview shows whether the result is readable and whether headings or totals land in sensible places.

Why page break lines appear in unexpected places

A worksheet can seem to contain only a small table but still print across many pages. Formatting far below or to the right of the visible data, stray values, or a print area that includes extra cells can expand the effective print range. Scroll beyond the table and check for unintended content. You can also select the intended data and reset the print area through Page Layout > Print Area > Clear Print Area, then define it again if needed.

Another common cause is a mismatch between the page settings and the printer. A sheet configured for one paper size may break differently when sent to a printer using another size. Margins, printer capabilities, and scaling also affect the calculated boundaries. Confirm the paper size and orientation in Page Layout and review the actual printer selection in File > Print.

If a manual break appears to persist after you change the layout, use Reset All Page Breaks to clear the sheet’s manually inserted breaks, then let Excel recalculate automatic ones. Conversely, if the lines merely clutter the normal view, turn off Show page breaks rather than resetting breaks. These remedies solve different problems.

Page breaks compared with nearby Excel features

Page breaks are easy to confuse with other worksheet display features. Gridlines form a background grid between cells; they can be shown or hidden and are a separate print setting. Cell borders are formatting applied to selected cells and can print as part of the report. Neither one determines where Excel divides pages.

Freeze Panes is also unrelated. It keeps selected rows or columns visible while you scroll through a worksheet, but it does not create a print boundary. Similarly, a page break does not repeat a table heading automatically. To repeat headings on printed pages, use Page Layout > Print Titles and specify rows to repeat at the top or columns to repeat at the left. That setting changes the printed report, not the worksheet’s page-break markers.

Use Page Break Preview when you need to see and adjust page divisions. Use Print Preview to judge the final appearance page by page. Use the gridline or border settings only when the problem is the appearance of cell boundaries, and use Freeze Panes only to make on-screen navigation easier.

A practical example: printing a wide sales table

Suppose a sales report has a date, salesperson, region, and twelve monthly columns. In Portrait orientation, Excel may split the months across several pages, making comparisons difficult. Switch to Landscape and inspect Page Break Preview. If the columns still cross pages, set the width to one page in the Scale to Fit group, but leave the height automatic so each month remains large enough to read and the rows continue onto later pages.

If the report has a title row, use Print Titles to repeat that row on each printed page. Then check the Print preview for text size and page count. If the report becomes too small when all columns are forced onto one page, consider using a larger paper size, reducing unnecessary columns, or accepting two pages across with a repeated heading. The best result is not necessarily the fewest pages: it is a layout readers can interpret without losing context.

Frequently Asked Questions

Why are dashed lines appearing on my Excel sheet?
They are usually automatic page breaks shown after you open Print or Print Preview. Excel uses them to indicate where the current print setup divides the worksheet. Switch to Page Break Preview to inspect them, or turn off Show page breaks in Advanced display options if you only want to hide them in Normal view.

How do I get rid of page break lines in Excel?
To hide the lines without changing printing, clear File > Options > Advanced > Display options for this worksheet > Show page breaks. To remove manual breaks, use Page Layout > Breaks > Reset All Page Breaks. Automatic breaks are recalculated rather than individually deleted.

Do page break lines print?
No. The lines are worksheet guides, not printed marks. They indicate page boundaries. The content on each side of a boundary may print on separate pages, but the line itself does not appear as a border on the paper.

Why can’t I drag a page break?
You may be trying to move an automatic boundary, working outside Page Break Preview, or encountering a limit set by the print area or page setup. Switch to Page Break Preview and try a solid manual boundary. If the division is automatic, change margins, orientation, paper size, scaling, or the print area instead.

Does resetting page breaks change my worksheet data?
No. Reset All Page Breaks removes manually inserted print boundaries on the active sheet and lets Excel calculate automatic ones again. It does not delete cell values or formatting, though the resulting printed pages may be arranged differently.

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.