Excel Print Area Lines: What They Mean and How to Hide Them

How-to basics · Updated November 21, 2026

Excel print area lines usually mark page breaks: dashed lines show where printed pages end, while solid lines generally indicate manually inserted breaks. They are guides, not worksheet borders, and they do not print. To hide the guides in Excel for Microsoft 365 on Windows, go to File > Options > Advanced, find Display options for this worksheet, and clear Show page breaks.

What the lines mean in Excel

Excel has several kinds of visual guides that can look like print-area lines, so the first step is identifying which one you are seeing. In Normal view, dashed lines across or down the sheet usually show automatic page breaks: Excel has calculated where the content will divide when printed. A solid page-break line usually marks a break inserted manually. These lines can appear after you open Print or use Page Break Preview, because Excel has worked out how the current sheet will paginate.

Page-break guides indicate divisions between printed pages; they do not necessarily outline the full print area. In Page Break Preview, Excel displays page boundaries more explicitly, often with blue lines and page numbers. The selected print area is the part designated for printing, while the page-break lines show how that area, or the sheet, is split into pages. The surrounding area may appear shaded or gray in this view.

Neither kind of guide is a cell border. They are display aids and do not appear on paper or in a PDF as lines. If a line does show up in a printed copy, it is likely an actual cell border, a shape, or a gridline setting rather than a page-break guide.

Print area, page breaks, and page layout

A print area is a range of worksheet cells that Excel is instructed to print. Setting one is useful when a worksheet contains notes, calculations, or unused columns that should remain on screen but not appear on the printout. Page breaks, by contrast, control where Excel starts a new printed page. A print area can span several pages, and its page breaks determine how those pages are divided.

For example, suppose a monthly report uses A1:H42, with internal calculations in columns J:N. Setting A1:H42 as the print area excludes the calculations, but it does not guarantee the report fits on one page. Excel may still print the selected range across multiple pages, depending on paper size, margins, orientation, scaling, and the content’s dimensions.

Use Page Layout > Print Area > Set Print Area to designate the current selection. To remove that restriction, choose Page Layout > Print Area > Clear Print Area. A print area is saved with the workbook, so it can affect what another person sees when they print the sheet. Page breaks and print areas are related settings, but changing one does not always change the other.

How to set or change a print area

To set the area for a worksheet in Excel for Microsoft 365 on Windows:

  1. Select the cells you want included. To print the report example above, select A1:H42.
  2. Open the Page Layout tab on the ribbon.
  3. Choose Print Area, then Set Print Area.
  4. Open File > Print and review the preview before printing. Check that the correct columns and rows appear and that page breaks fall in sensible places.

If the existing print area is wrong, select the intended range and set it again. Excel replaces the prior print area for that sheet with the new selection. If you want the whole sheet considered for printing, use Clear Print Area instead; then use Print Preview to confirm which populated cells Excel includes.

To print two separate, nonadjacent blocks, select the first range and then, while holding Ctrl, select the second range before setting the print area. Excel can store multiple print areas, but it generally prints each separate area as its own page or group of pages. If the blocks need to appear together in a single report layout, it is often clearer to copy them to a dedicated print sheet.

Excel for Mac has similar print-area controls on the Page Layout tab, though ribbon placement and dialog details may vary by release. Excel for the web has fewer page-layout and page-break controls than the desktop app. If you need precise print-area or manual-break adjustments, open the workbook in the desktop version and confirm the result in its print preview.

How to hide page-break lines

To hide page-break indicators in the Windows desktop app, use the worksheet-specific display setting:

  1. Choose File > Options.
  2. Select Advanced.
  3. Scroll to Display options for this worksheet. If needed, select the worksheet from the dropdown list.
  4. Clear Show page breaks, then select OK.

This changes how the selected worksheet looks on screen; it does not remove the print area, delete page breaks, or change what is printed. Because the setting is for a particular worksheet, check the dropdown if the lines remain visible on another sheet. You can turn the indicators back on by selecting Show page breaks again.

A quick alternative is to change the view. Select View > Normal if the sheet is currently in Page Break Preview or Page Layout view. This often removes the prominent page-boundary display, although Excel may still show dashed automatic breaks in Normal view. For those, use the Show page breaks option above.

On Excel for Mac, look under Excel > Preferences or Excel > Settings, depending on the release, and find the view or display settings for the worksheet. The precise labels and locations can differ. If you cannot find an equivalent checkbox, switching to Normal view is a useful first step; use Excel for Windows or consult the Mac version’s current help for worksheet-specific page-break display controls.

Adjusting where printed pages break

Hiding a line changes only its visibility. To change the actual page division, use Page Break Preview or the Breaks command on the Page Layout tab. In Page Break Preview, drag a page-break line to a new position to alter the printed page boundary. The result depends on the print area and scaling settings, so inspect the preview afterward.

To insert a manual break, select the row below where a horizontal break should go, or the column to the right of where a vertical break should go. Then choose Page Layout > Breaks > Insert Page Break. A manual break can be helpful when, for example, each department’s section should start on a new page even if Excel’s automatic pagination would split it differently.

To remove manual breaks or return to automatic pagination, choose Page Layout > Breaks > Reset All Page Breaks. This resets breaks on the active worksheet; it does not clear the print area. Automatic breaks can still appear afterward because Excel continues to calculate page divisions from the paper and layout settings.

Before moving breaks, consider whether scaling is a better fix. On Page Layout, the Scale to Fit controls let you adjust width and height for printing. Setting a report to fit one page wide can keep its columns together while allowing it to span multiple pages vertically. Forcing both width and height to one page may make text too small to read, so use Print Preview to judge legibility.

Why lines or printouts look unexpected

If lines remain after you hide page breaks, identify what they are before changing settings. A solid line that stays visible in Normal view may be a cell border. Select the cells around it and check Home > Borders; removing a border changes the worksheet’s formatting and can affect printed output. Gridlines are another separate feature: use Page Layout > Sheet Options > Gridlines and check whether View or Print is selected. Turning off printed gridlines does not hide page-break guides.

If the printout includes columns you did not expect, check Page Layout > Print Area > Clear Print Area and set the intended range again. Also review Print Preview for the active sheet, workbook, or selection option. These choices determine what Excel sends to the printer and can explain why a correct print area seems to be ignored.

If a report is split awkwardly, inspect paper size, orientation, margins, scaling, and manual breaks. A worksheet that fits on one page on one printer may paginate differently with a different paper size or printer driver. Check the printer selected in the Print screen and review the preview after changing layout settings. If content is cut off, widening the print area will not necessarily solve it; scaling or changing orientation may be more appropriate.

Finally, remember that print settings apply to worksheets and workbooks in different ways. A page-break display option is tied to a worksheet, while print areas and manual breaks are also worksheet-level settings. When a workbook contains several report tabs, check each sheet separately rather than assuming one change applies everywhere.

Other ways to control what gets printed

A print area is not the only way to control a printout. If you need a one-time print of a small selection, select the cells and choose File > Print, then select Print Selection in the settings. That avoids changing the worksheet’s saved print area. If you repeatedly print the same range, a saved print area is more convenient.

For a long table, repeating header rows on each page can make the printout easier to read. On the Page Layout tab, choose Print Titles, then use Rows to repeat at top to specify the header row. This setting does not create or hide page-break lines; it affects the printed pages. For complex reports with several distinct sections, a separate summary or print sheet may provide more predictable pagination than trying to arrange distant ranges on one worksheet.

Before printing or saving as PDF, review the full preview, not just the worksheet view. Confirm the page count, readable text size, repeated headings, and whether any empty pages appear. The preview represents the print layout more reliably than the dashed guides on the grid, which are only a simplified indication of page boundaries.

Frequently Asked Questions

Do Excel print area lines print on paper?
No. Page-break guides are screen indicators, not printable marks. If a line appears on paper or in a PDF, check for cell borders, shapes, or the Print setting for gridlines.

Why did dashed lines appear after I printed?
Excel may display automatic page breaks after you open the Print screen or use Page Break Preview. These indicate where the sheet is currently divided for printing. Hide them with File > Options > Advanced > Show page breaks, or switch to Normal view.

How do I remove a print area without deleting data?
Choose Page Layout > Print Area > Clear Print Area. This removes the saved printing restriction for the active worksheet; it does not delete cells or their contents.

What is the difference between a dashed and a solid page-break line?
Dashed lines generally mark automatic breaks calculated by Excel. Solid lines generally mark manual breaks that someone inserted. The lines may look different in Page Break Preview, but neither type is a cell border.

Why does Excel print beyond my selected print area?
Check that the print area is set on the worksheet you are printing, and confirm the Print screen is set to print the active sheet rather than a selection or the whole workbook. Clear and reset the print area if necessary, then check the preview.

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.