Excel Print Area Lines: How to View, Show, Hide, and Fix

Errors & fixes · Updated November 21, 2026

To view Excel print area lines in Microsoft 365 for Windows, open the View tab and choose Page Break Preview; blue lines show page boundaries, while the gray area is outside the printable pages. To show or hide page-break lines in Normal view, use File > Options > Advanced and toggle Show page breaks for the worksheet. These lines are guides: they do not print on the paper.

What Excel print area lines mean

People use “print area lines” to describe a few different things in Excel. The dashed or solid lines on a worksheet are usually page-break indicators: they show where one printed page ends and the next begins. A print area, by contrast, is a worksheet setting that tells Excel which cells to include when printing. It is possible to have a print area without seeing its boundary in the current view, or to see page-break lines even when no custom print area has been set.

In Normal view, Excel may show page breaks as dotted lines after you have opened Print or used print-related settings. In Page Break Preview, page boundaries are more prominent. Blue lines mark the edges of pages, and the page numbers appear over the sheet. Cells outside the printable page area are shaded gray. A solid blue line generally indicates a manual page break; a dotted or dashed line indicates an automatic break that Excel has placed based on the paper size, margins, scaling, and current layout.

Neither kind of line is a border on your worksheet data. They are on-screen layout guides, not marks that will appear in the printed document.

Show page-break lines in Normal view

If you want the guides visible while editing cells, turn on the worksheet’s page-break display option. In Excel for Microsoft 365 on Windows:

  1. Open File > Options.
  2. Select Advanced.
  3. Scroll to Display options for this worksheet.
  4. If necessary, select the worksheet you want from the drop-down list.
  5. Check Show page breaks, then select OK.

The setting applies to the selected worksheet, so check the correct sheet if the workbook has several tabs. To hide the lines, repeat those steps and clear Show page breaks. This hides the guides; it does not clear a print area, remove manual page breaks, or change what Excel is set to print.

Page-break indicators can also appear after you view the print layout. If they are distracting, switch back to Normal view through View > Normal, then turn off Show page breaks if the lines remain. The option changes the worksheet display rather than the printed result.

Use Page Break Preview to inspect pages

For a clearer view of how a large sheet will divide across paper, select View > Page Break Preview. This view is more useful than Normal view when the question is not merely where a dotted line is, but whether a table will be split across pages. Look for headings separated from their rows, narrow columns pushed onto an extra page, or a short final page containing only a few cells.

You can drag a blue page-break line in this view to change where a page ends. Doing so may create a manual page break, which takes precedence over Excel’s automatic placement. If a later change to paper size or scaling makes the layout awkward, you may need to adjust or reset the break. Return to Normal view with View > Normal when you are finished.

Page Break Preview is a layout aid, not a guarantee that every printer will produce identical output. Printer capabilities and settings can affect the final page. Use File > Print to check the print preview with the selected printer, paper size, orientation, margins, and scaling.

Set or clear the print area

If Excel is printing too many cells—or leaving out part of a report—set the intended range explicitly. Select the cells you want, then choose Page Layout > Print Area > Set Print Area. Excel saves that print area with the worksheet. For example, if a monthly report occupies A1:G42, selecting that range before setting the print area prevents unrelated notes farther down or to the right from being included.

To remove the saved print area, choose Page Layout > Print Area > Clear Print Area. Clearing it does not erase cell contents or formatting. It returns the sheet to Excel’s default behavior, in which the used portion of the worksheet may be included when you print the active sheet. Check Print Preview afterward, especially if the worksheet contains distant stray values or formatting.

Nonadjacent selections can be added as separate print areas, but Excel prints each separate area on its own page. That can be useful for printing independent blocks, but it may not produce one continuous report. If you expected several blocks to appear together, consider moving them into one contiguous range or adjusting the layout before setting the print area.

Print area boundaries versus page breaks

A common source of confusion is assuming that a visible line is the print-area boundary. The print area controls which cells are eligible to print; page breaks divide the printable content into pages. A single print area can span many pages, so its outer extent and the internal page-break lines are different things. In Page Break Preview, the blue page edges and gray shading help reveal the printable page layout, but they should not be mistaken for cell borders.

There is also a difference between changing the display and changing the print setup. Turning off Show page breaks only hides indicators in Normal view. Clearing the print area changes the range Excel uses. Moving a page-break line changes pagination. These actions solve different problems, even if all three are described as removing or fixing lines.

To check what will actually print, open File > Print. The preview shows the pages generated from the current print area and page settings. If the preview is wrong, changing a display option alone will not fix it; adjust the print area, page breaks, or scaling instead.

Fix common line and layout problems

  • Lines remain after returning to Normal view: Turn off File > Options > Advanced > Show page breaks for the active worksheet. Make sure the correct sheet is selected in the options list.
  • A dashed line cuts through a table: It is likely an automatic page break. Check paper size, orientation, margins, and scaling in the Page Layout tab, or inspect the page in Page Break Preview.
  • A solid line will not move as expected: It may be a manual page break. In Page Break Preview, adjust it directly, or use Page Layout > Breaks > Reset All Page Breaks to remove manual breaks and return to automatic pagination.
  • Extra blank pages appear: Inspect the print area and look for stray content or formatting far from the main table. Also review scaling and page breaks in Print Preview.
  • The printout does not match the worksheet view: The screen gridlines are not necessarily printed. Check the preview and, if needed, use the worksheet’s gridline print setting on the Page Layout tab.

Before resetting breaks, note any deliberate page divisions you want to keep. Resetting all page breaks can remove manual pagination across the worksheet. If only one break is the problem, changing that break is usually more precise than resetting every break.

Make the printed pages easier to read

When the lines reveal that a report is splitting poorly, fix the layout rather than merely hiding the guides. In Page Layout, review Orientation, Size, and Margins. A wide table may fit better in landscape orientation, while a compact table may be clearer in portrait. Smaller margins can create more usable space, but extremely tight margins may not be supported by the printer.

Scaling options can also change the page breaks. In the Page Layout tab, the Scale to Fit controls let you fit the sheet to a chosen number of pages wide or tall. Setting one page wide can keep columns together, but it may shrink text substantially if the sheet has many columns. Check the preview at readable size before printing; fitting an entire large worksheet onto one page is often less useful than allowing it to span several pages.

If a multi-page list needs its column headings repeated, set print titles through Page Layout > Print Titles. Repeating a heading row is not the same as setting a print area: the print area defines the cells to include, while print titles repeat selected rows or columns on subsequent pages.

Excel on Mac and Excel for the web

On Excel for Mac, the names and placement of settings can vary slightly by release. Page Break Preview is available from the view controls, and page-break display preferences are found in Excel’s preferences or settings under the View area. To set or clear a print area, use the Page Layout tab’s Print Area commands where available. If a menu differs from the Windows steps, consult the current ribbon labels in your installed version rather than assuming the Windows Options path is identical.

Excel for the web has a different interface and may not offer every desktop page-break control. For detailed manual pagination or worksheet display options, open the workbook in the desktop app. Regardless of platform, the print preview is the useful final check because it shows the output settings applied to the current print job.

Frequently Asked Questions

How do I show print area lines in Excel?
Choose View > Page Break Preview to see page boundaries clearly. To show page-break indicators in Normal view, enable Show page breaks under File > Options > Advanced for the worksheet.

How do I get rid of the dotted lines in Excel?
To hide page-break indicators in Windows, clear Show page breaks in the Advanced options for that worksheet. This only hides the lines on screen; it does not change the print area or page breaks used for printing.

Do print area lines print on the page?
No. Page-break indicators and the blue guides in Page Break Preview are editing aids. They do not print as lines. Use File > Print to inspect the actual pages.

Why is my Excel print area not printing everything I selected?
Check that the intended cells are inside the saved print area and that the correct worksheet is active. Then review Print Preview for scaling, page breaks, paper size, and orientation. If needed, select the range again and choose Page Layout > Print Area > Set Print Area.

How do I remove a solid page-break line?
Open Page Break Preview and adjust the break, or choose Page Layout > Breaks > Reset All Page Breaks to clear manual breaks on the worksheet. Resetting all breaks affects every manual break on that sheet, so use it only when that is what you intend.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.