Excel Clear Print Area: What Dotted Lines Mean

How-to basics · Updated November 18, 2026

To clear a worksheet’s print area in Excel for Microsoft 365 on Windows, select the sheet and choose Page Layout > Print Area > Clear Print Area. If dotted lines remain, they are page-break indicators, not the print-area outline; hide them through File > Options > Advanced by clearing Show page breaks under Display options for this worksheet.

Print areas and dotted lines are different

A print area tells Excel which cells to include when you print a worksheet. A page break tells Excel where one printed page ends and the next begins. These settings can affect the same printout, but they are not the same thing. Clearing a print area removes the defined print range; it does not switch off the worksheet’s page-break display.

Excel commonly displays dotted page-break lines in Normal view after you have opened Print or Print Preview. The lines give you a rough view of how the sheet will divide across printed pages. They may cross cells that are outside a print area, because they represent page boundaries rather than the edge of the selected print range. They can also remain after you clear a print area because Excel still needs to show how the worksheet would paginate if printed.

This distinction helps avoid a common mistake: repeatedly choosing Clear Print Area when the real goal is to make the dotted lines disappear. Use Clear Print Area to change what Excel prints; change the page-break display setting to hide the lines on screen.

Clear a print area in Excel for Windows

Use these steps when you want Excel to stop restricting a sheet to a previously selected range:

  1. Click the worksheet tab whose print area you want to remove. A print area belongs to an individual worksheet, so clearing it on one tab does not clear it on every tab.
  2. Open the Page Layout tab on the ribbon.
  3. In the Page Setup group, select Print Area.
  4. Choose Clear Print Area.

The saved print-area restriction is removed from that worksheet. When you print, Excel can then include the sheet’s content according to the other print settings and page layout. If the worksheet contains a large formatted or used range, the resulting printout may cover more pages than the old print area did. Check File > Print before sending it to a printer.

If the menu command is unavailable or appears to have no effect, first confirm that you have selected the intended worksheet and that it has a print area. A sheet with no defined print area has nothing to clear. Also check whether the workbook is protected or shared in a way that restricts changes.

Hide dotted page-break lines

In Excel for Microsoft 365 on Windows, hide page-break indicators for a particular sheet this way:

  1. Choose File > Options.
  2. Select Advanced.
  3. Scroll to Display options for this worksheet.
  4. Use the dropdown to choose the worksheet showing the lines, if necessary.
  5. Clear the Show page breaks checkbox, then select OK.

This changes the on-screen display, not the way the sheet is divided when printed. The worksheet can still print across multiple pages, and its automatic and manual breaks still affect pagination. The setting is associated with the selected worksheet, so another sheet may continue to show its own page-break lines.

To see the lines again, return to the same option and select Show page breaks. If you simply need to check the output once, File > Print opens the print preview; close the preview and return to the worksheet. That is different from disabling page-break indicators in the Advanced options.

Check the printout before changing other settings

After clearing the print area, use File > Print to inspect the preview. Look at the page count and the edges of each page. If Excel is printing blank-looking pages or spreading a small table across many sheets, the cause may be a page layout setting, a manual break, or formatting far from the visible data—not a dotted line itself.

Review these options if the preview is not what you expect:

  • Orientation: Page Layout > Orientation lets you choose portrait or landscape. A wide table may fit better in landscape.
  • Paper size: Page Layout > Size determines the paper dimensions Excel uses for pagination. It should match the paper loaded in the printer.
  • Margins: Page Layout > Margins changes the printable space on each page.
  • Scaling: The scaling controls on Page Layout can shrink a sheet to fit a specified number of pages. A setting such as fitting all columns to one page can make text very small.
  • Print selection: In the print settings, confirm that Excel is set to print the intended scope, such as the active sheet, rather than a selection or the entire workbook.

Print preview is useful because a screen’s dotted lines are only a guide to pagination. Printer capabilities, paper size, margins, scaling, and the workbook’s page setup all influence the final result. If the preview shows the right pages, the dotted indicators can usually be treated as a display preference rather than a printing problem.

Automatic breaks, manual breaks, and Page Break Preview

Excel creates automatic page breaks based on the sheet’s content and print settings. As rows or columns change size, or as you change paper size, orientation, margins, or scaling, Excel may move those boundaries. The dotted lines commonly seen in Normal view are indicators of these automatic breaks.

Manual page breaks are different: someone has inserted a boundary to control where printing starts a new page. In Page Break Preview, Excel makes the page divisions easier to inspect; automatic and manual breaks are shown with different line styles, commonly dashed for automatic breaks and solid for manual ones. The exact view depends on the display mode. Page Layout > Breaks includes commands for inserting or removing breaks, and Reset All Page Breaks returns the sheet’s breaks to automatic placement. This does not clear the print area.

To inspect the layout, choose View > Page Break Preview. Dragging a break in that view can change the page division, so avoid moving lines if your only goal is to hide them. Return to View > Normal when you are finished. If a manual break is causing an unwanted split, select a cell near that break and use Page Layout > Breaks to remove the page break, or use Reset All Page Breaks to discard manual breaks on that sheet.

Print area versus page breaks

Think of the print area as the boundary of the material Excel is asked to print, and page breaks as the internal divisions within that material. For example, if A1:H40 is the print area and Excel divides it into two pages, clearing the print area removes the A1:H40 restriction. It does not necessarily remove the two-page division, nor does it prevent the sheet from being divided into pages when printed.

Conversely, hiding the dotted lines does not change the defined print area. The sheet can continue to print only the selected range even when no page-break indicators are visible in Normal view. The distinction is important when sharing a workbook: a recipient may see different screen indicators, but the print area and page setup can still control the printed output.

Other print-related settings are separate too. Repeating rows or columns at the top or left of each printed page, print titles, headers and footers, and scaling are not removed by Clear Print Area. If the print preview still looks constrained after clearing the area, inspect those settings rather than assuming that the command failed.

Excel for Mac and Excel for the web

In Excel for Mac, the print-area command is also on the Page Layout tab: use Print Area and then Clear Print Area. The ribbon may look different from Windows depending on the Excel version and window size, but the command serves the same purpose. To print, use File > Print; Command+P is the Mac shortcut, compared with Ctrl+P in Windows.

The controls for displaying page breaks differ between Excel versions and platforms. On Mac, look in Excel > Settings (or Preferences in some releases) and the View section for a Page breaks or Show page breaks option. The wording and location can vary, so if that checkbox is not present, consult the View and print-related preferences available in your installed version. Changing this display preference is separate from clearing the print area.

Excel for the web has a more limited set of print-layout controls than the desktop app, and its interface can change over time. If you need to remove a saved print area or adjust detailed page-break settings and cannot find the relevant command in the browser, open the workbook in the desktop version of Excel and make the change there. Then save the workbook so the change is available when it is reopened.

Common problems and practical fixes

  • The dotted lines remain after clearing the area: expected behavior. Hide Show page breaks in the worksheet’s Advanced display options.
  • The sheet still prints on several pages: clearing the print area does not make a worksheet fit on one page. Check scaling, orientation, paper size, margins, and manual breaks.
  • Only part of the worksheet prints: check whether a print area is still set on the active sheet, then check the print scope in File > Print.
  • Unexpected blank pages appear: inspect Page Break Preview for manual breaks and check whether cells far to the right or below the visible table have formatting or content that expands the printable range.
  • The lines return later: the display preference is per worksheet. Another worksheet has its own setting, and opening print preview can make page-break indicators appear on a sheet again depending on its settings.

For a quick diagnosis, separate the two questions: “What cells will print?” and “What lines are displayed?” Use the Print Area menu for the first and the Show page breaks option for the second. Then verify the actual output in print preview instead of relying only on the worksheet view.

Frequently Asked Questions

Does Clear Print Area remove dotted lines in Excel?
No. It removes the worksheet’s defined print range. Dotted lines are page-break indicators; hide them through File > Options > Advanced > Display options for this worksheet > Show page breaks.

Will clearing a print area make Excel print the whole worksheet?
It removes the explicit print-area restriction, so Excel can print the worksheet’s content under the remaining print settings. It does not mean every empty cell in the worksheet will become a page. Check File > Print to see the pages Excel has prepared.

How do I remove a manual page break?
Select a cell near the break and choose Page Layout > Breaks > Remove Page Break. To remove manual breaks throughout the active sheet, choose Page Layout > Breaks > Reset All Page Breaks.

Are dotted lines the same as a print area border?
No. A print area defines which cells are included for printing; dotted lines usually mark automatic page boundaries. A print area can span more than one page, and page-break indicators can remain visible after the print area is cleared.

Does hiding page breaks change what gets printed?
No. The Show page breaks option controls the worksheet display. It does not remove a print area, change the page divisions, or stop Excel from printing multiple pages.

Related

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.