To hide Excel’s dotted page-break lines without changing what prints, go to File > Options > Advanced, find Display options for this worksheet, and clear Show page breaks. The setting affects the selected worksheet’s display only: it does not clear the print area or remove page breaks from the printed output.
What Excel’s print-area lines actually show
People often call several different worksheet markings “print area lines,” but they do not all mean the same thing. In a normal worksheet view, dotted or dashed lines usually indicate page breaks: the boundaries between pages Excel expects to print. A solid line can indicate a manually inserted page break. Those markers help show how a large sheet will be divided across printed pages; they are not cell borders and do not print as lines over your data.
A print area is different. It is the range of cells Excel has been told to include when printing that worksheet. You set it with Page Layout > Print Area > Set Print Area. Excel may show page-break markers at or near the edges of that range, which is why the two concepts are easy to confuse. There is not a separate general-purpose switch called “hide print area border” in the Windows desktop app. The page-break display option is usually the one people need when they want a cleaner worksheet view.
To see what will actually print, use File > Print to open Print preview. The preview shows the printable pages, including how the selected print area and page setup affect them. A worksheet can have page breaks even when it has no custom print area, and a custom print area can remain in place when its page-break indicators are hidden.
Hide page-break lines in Excel for Windows
In Excel for Microsoft 365 on Windows, use the worksheet-specific display setting. First select the sheet whose lines you want to hide; then follow these steps:
- Select File > Options.
- In the Excel Options window, select Advanced.
- Scroll to Display options for this worksheet.
- If the workbook has several sheets, check that the correct sheet is named in the drop-down list.
- Clear Show page breaks, then select OK.
The dotted page-break markers should disappear from that sheet in Normal view. The option is attached to the selected worksheet, not applied as a universal workbook-wide switch. If you want the markers hidden on other sheets too, select each sheet in the drop-down and clear the option for it. Be careful when multiple sheets are grouped: changes made while sheets are grouped can affect all selected sheets.
This setting changes only what Excel displays in the worksheet window. It does not delete manual page breaks, alter a print area, change scaling, or prevent Excel from creating pages when you print. You can still open Print preview and adjust page layout as usual.
Check the worksheet view before changing settings
Sometimes the lines are visible because Excel is in a view designed to show page layout. Choose View > Normal to return to the standard worksheet view. If the sheet is in Page Break Preview, Excel emphasizes page boundaries and may show the printable region differently, including shaded areas outside it. Switching to Normal view changes the view, not the print setup.
Excel also has Page Layout view, which displays the worksheet in a more page-like arrangement. It is useful for checking margins, headers, and footers, but can make page-related boundaries more noticeable. If you only want to work with cells and do not need a page-oriented view, Normal is usually the least distracting choice. Use Print preview afterward to verify page output rather than relying only on the worksheet canvas.
View changes and the Show page breaks option address different aspects of the display. If you switch to Normal view and still see dotted breaks, clear Show page breaks as described above. If the markings disappear in Normal view but return in Page Break Preview, that is expected: the preview is specifically intended to make page divisions visible.
Do not confuse page breaks with gridlines
Gridlines are the faint cell boundaries that appear across much of a worksheet. They are not page-break markers, and hiding one type will not necessarily hide the other. In Windows, use View > Show > Gridlines to turn worksheet gridlines on or off for viewing. This setting can make a sheet look cleaner, but it does not remove page-break indicators.
Gridline printing has its own control. On the Page Layout tab, find the Sheet Options group and use the Gridlines checkbox in the Print column to choose whether gridlines are printed. The View checkbox in that group controls their on-screen display. These are separate from the page-break display option, so a sheet can have gridlines hidden on screen but printed, or visible on screen but omitted from printouts.
- Dotted lines between pages: usually page-break indicators; clear Show page breaks to hide them in Normal view.
- Faint lines around cells: gridlines; use the View control to change their screen display.
- Dark or colored cell edges: likely cell borders formatted onto the cells; remove or change the border formatting if those should not appear.
- Gray area around a page in Page Break Preview: a view cue for the printable region, not a gridline setting.
This distinction matters when a worksheet looks correct on screen but prints differently. Hiding gridlines or page-break indicators is not the same as changing cell borders, and only the print-related settings affect whether gridlines are included on paper or in a PDF.
Keep the print area while hiding its indicators
If your goal is to keep printing a specific range, do not choose Clear Print Area just to remove a dotted line. Clearing the print area removes the saved range restriction; it does not merely hide its on-screen indicators. Excel may then print a larger portion of the worksheet, depending on the content and page setup.
To check or change the range, select the worksheet and open Page Layout > Print Area. Choose Set Print Area after selecting the cells you want included, or choose Clear Print Area only when you intend to remove that restriction. For example, if a report occupies A1:F35, select that range before setting the print area. Then use File > Print to confirm that the preview contains the intended report and does not omit a title row or final total.
When you need a different page arrangement but want to preserve the same print area, adjust page setup rather than clearing the range. Options such as orientation, margins, paper size, and scaling can change how the selected cells fit on pages. Check the preview after any such change: fitting a wide table to one page may make the text very small, while allowing multiple pages across can improve readability.
Why the lines can come back
Page-break markers can seem to return after you print-preview a worksheet, change views, or reopen a workbook. The first thing to check is whether the worksheet is now in Page Break Preview, where boundaries are deliberately prominent. Return to View > Normal and confirm the Show page breaks option for that specific sheet is still cleared.
Also check that you are editing the same worksheet you changed earlier. Each sheet can have its own display setting, and the option in Excel Options includes a worksheet selector. A workbook with a monthly report on one tab and a summary on another may therefore show page breaks on one sheet but not the other. If the file is opened on another computer or in a different Excel environment, the screen presentation may also differ from the one you expect.
If the line is a manually inserted page break, hiding page-break display markers will not remove the break itself. To change page division, use Page Layout > Breaks to manage page breaks, or inspect the page layout and preview. Removing or moving a break changes pagination; hiding its marker changes only the worksheet display. Always check the preview if the printed page count or division matters.
Excel on Mac and Excel for the web
On Excel for Mac, the setting is in Excel’s preferences rather than the Windows File > Options dialog. Open Excel > Settings (called Preferences in some releases), choose View, and look for the Page breaks option to turn off their display. The exact wording and arrangement can vary by release. If you cannot find the checkbox, switch to Normal view and check the View settings available in your installed version.
Excel for the web does not expose the same Windows Advanced-options dialog, and its display controls are not identical to the desktop app. If the browser view does not offer a control for the page-break markers, open the workbook in the desktop app and change the sheet’s display setting there. The print area and page setup can still be checked through the available browser print controls, but desktop Excel provides the fuller set of worksheet display options.
Frequently Asked Questions
How do I hide the dotted lines in Excel after printing?
In Windows desktop Excel, select the affected sheet and clear File > Options > Advanced > Display options for this worksheet > Show page breaks. Printing or opening Print preview can make the page divisions noticeable, but hiding their worksheet markers does not change the printed pages.
Will hiding page-break lines change what prints?
No. The Show page breaks checkbox controls whether page-break markers appear on the worksheet. It does not remove page breaks, clear a print area, or change the print layout. Use Print preview to see the actual page output.
How do I remove a print area instead of hiding its lines?
Select the worksheet, then choose Page Layout > Print Area > Clear Print Area. This removes the saved print-range restriction; it is not a cosmetic display change. Review Print preview afterward because more worksheet content may now be included.
Why are gridlines still visible after I hide page breaks?
Gridlines are cell boundaries, not page divisions. Turn them off using View > Show > Gridlines. If they appear in the printed output, check the Print option under Page Layout > Sheet Options > Gridlines.
Can I hide page-break lines on just one worksheet?
Yes. In Windows Excel, select that sheet in the worksheet list under Display options for this worksheet, then clear Show page breaks. Repeat for other sheets only if you want their markers hidden too.
Related
- Can Excel Generate a PivotTable? How to Create One
- Excel Flash Fill for Rows: How It Works and When to Use It
- Excel Flash Fill: Does It Only Copy Data?
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Scatter Plot With Named Points: Add Name LabelsTo show names beside points in an Excel scatter plot, put the names in worksheet cells, select the…
- How to Insert a Functioning Checkbox in Microsoft WordTo insert a checkbox you can click to check or clear, use Word’s Check Box Content Control: show…
- Excel Table Headers on Each Printed Page: How to Repeat ThemTo print the same column headings on every page in Excel for Microsoft 365 on Windows, open Page…
- How to Remove a Section Break in Microsoft Word on MacTo remove a section break in Word on Mac, show formatting marks, click at the beginning of the…
- Excel: Turn Off Page Break Preview and Restore Normal ViewTo turn off Page Break Preview in Excel for Microsoft 365 on Windows, select View > Workbook Views…
- Working With Styles in Microsoft Word: A Practical GuideIn Microsoft Word, styles are named sets of formatting that you apply to text, such as Normal for…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.