Excel Print Area Lines: How to View, Set, and Hide Them

Yes. In Excel for Microsoft 365 on Windows, the clearest way to see your print area is to select View > Page Break Preview; the worksheet shows printable pages and their boundaries. For a simple outline in the usual worksheet view, Excel may also show page-break lines after you use Print Preview, but those lines are not the same thing as cell gridlines.

What Excel means by print area lines

A print area is the cell range, or ranges, that Excel is set to print from a worksheet. Its limits can be easy to confuse with page breaks because both relate to printing and can appear as lines on the sheet. Page breaks divide printed content into pages; a print area determines which cells are included in the print job.

In Page Break Preview, Excel uses blue outlines to show page boundaries and displays page numbers over the printable pages. The area outside the print range may appear gray. This is usually the most useful view when you want to see what will print and where it will split across pages.

In Normal view, page-break indicators can appear as dashed or solid lines. Dashed lines generally mark automatic page breaks, while solid lines can mark manually inserted breaks. These indicators help explain pagination, but they do not necessarily draw one clear box around every cell in the print area.

How to view the print area in Page Break Preview

To inspect the print layout on Windows, first select the worksheet you want to check. Then choose View > Page Break Preview on the ribbon. Excel switches from the regular cell view to a layout view showing how the sheet is divided into printed pages.

Look for the blue page boundaries and page numbers.
Check whether the cells you expect to print are inside the outlined pages.
Look for gray areas or unexpected page divisions that may indicate a print-range or page-layout issue.
When you are done, choose View > Normal to return to the standard worksheet view.

If the sheet contains a defined print area, Page Break Preview is a better guide than simply looking for a dotted rectangle in Normal view. A large print area can span several pages, and the page breaks show how Excel will divide that range rather than presenting it as one page-sized box.

How to show page-break lines in Normal view

If you want page-break indicators while working in the standard grid, open File > Options > Advanced. Under Display options for this worksheet, select the worksheet from the list if needed, then enable Show page breaks. Choose OK to apply the setting. This option controls page-break indicators for the selected worksheet; it is not a separate switch for drawing a print-area border.

Excel may show these indicators after you have opened Print Preview or printed the worksheet. If they are not visible, check the worksheet-specific setting above or return to Page Break Preview. Keep in mind that a page-break line may run through a print area because it shows where one page ends and another begins.

To hide the indicators again, clear Show page breaks in the same Advanced options area, or switch to another view. Hiding the lines changes how the worksheet is displayed, not what range is configured to print.

Set or change the cells Excel prints

Seeing boundaries is only half the job; if the wrong cells are included, set the print area explicitly. Select the cells you want to print, then choose Page Layout > Print Area > Set Print Area. Excel records that selection as the worksheet’s print area. Use Page Break Preview or Print Preview afterward to confirm the result.

To replace the existing print area, select the new range and choose Set Print Area again. To remove the defined range and let Excel print the worksheet’s used content according to the current print settings, choose Page Layout > Print Area > Clear Print Area. Clearing the print area does not delete worksheet cells or erase formatting.

For example, if a worksheet has a report in A1:F35 and notes in H1:J12, setting A1:F35 as the print area keeps the notes out of the printout. If you later add a totals row in row 36, the old range may not include it; reset the print area to A1:F36. A visible page boundary does not automatically expand just because new data has been entered nearby.

Print multiple separate ranges

You can print more than one nonadjacent selection from the same worksheet. Hold Ctrl while selecting separate ranges, then choose Page Layout > Print Area > Set Print Area. Excel treats these as separate print areas, so they may be printed as distinct sections rather than being joined into one continuous rectangle. Check Print Preview to see the order and page layout.

If you want to add another range without replacing the existing print area, select the new cells and choose Page Layout > Print Area > Add to Print Area. This can be useful for a report with separated blocks, but it may produce extra pages or an order that is less convenient than a single consolidated range. For a tidy handout, consider arranging the content into one continuous range when practical.

Tell print-area lines apart from gridlines

Gridlines are the faint cell boundaries across the worksheet. They help you read rows and columns, but they do not identify the print area. Page breaks are pagination guides, while the print area is a saved selection of cells. These three things can overlap on screen, but they serve different purposes.

Gridlines: show cell divisions; control their printing from Page Layout > Sheet Options > Gridlines.
Page breaks: show where printed pages divide; inspect or adjust them in Page Break Preview.
Print area: defines which cells are included; manage it from Page Layout > Print Area.

A common misconception is that turning worksheet gridlines off removes the print-area boundary. It does not. Similarly, hiding page-break indicators does not clear the print area. If a printout has unwanted cells, change the print area or print settings rather than changing gridline display.

Why the lines or printout may look wrong

If a page appears to include too many or too few cells, check the defined print area first. Choose Page Layout > Print Area and use Clear Print Area if an old range is restricting the sheet. Then select the intended cells and set the area again. A print area is associated with its worksheet, so check the correct sheet when a workbook has several tabs.

Next, check page size, orientation, margins, and scaling. A range that fits on one page in landscape orientation may spill onto two pages in portrait orientation. In Page Layout, review the Page Setup controls, including Orientation, Size, and Margins. Scaling options such as fitting a sheet to one page can shrink text substantially, so use Print Preview to judge readability instead of relying only on the boundary lines.

Manual page breaks can also make the preview look unexpected. In Page Break Preview, you can drag a blue page-break line to change where pages divide. To reset manual breaks, use Page Layout > Breaks > Reset All Page Breaks. This resets page breaks, not the print area, so verify both settings when the printed result is still wrong.

Confirm the result in Print Preview

Before printing, open File > Print or press Ctrl+P on Windows. The preview lets you inspect the actual page output, including page count, clipping, blank pages, and scaling. If the preview is divided into unexpected pages, return to the worksheet and adjust the print area, page breaks, or page setup.

On Mac, Command+P opens the print dialog. Ribbon labels and dialog layouts can vary slightly by Excel release, but the worksheet view controls and Page Layout tools provide the corresponding print-area and page-break options. In Excel for the web, printing a selected range is available through the print workflow, but the full desktop controls for managing saved print areas may not be available. For repeatable print-area settings, open the workbook in desktop Excel.

Frequently Asked Questions

Why can’t I see the print area outline in Excel?
Use View > Page Break Preview to inspect page boundaries. In Normal view, Excel may show page-break indicators rather than a complete outline around the print area. Also confirm that a print area is actually set for the selected worksheet.

Are dotted lines in Excel the print area?
Usually, dotted lines in Normal view indicate automatic page breaks, not the edge of the selected print area. Page Break Preview is the clearer way to see the printable pages and their boundaries.

How do I remove a print area?
Choose Page Layout > Print Area > Clear Print Area. This removes the worksheet’s defined print range without deleting any cells.

How can I see what will print before printing?
Choose File > Print or press Ctrl+P on Windows. Review each page in the preview, then return to the worksheet if you need to change the range or layout.

Do Excel gridlines show the print area?
No. Gridlines mark cell boundaries. The print area determines which cells print, and page-break lines show where the printed pages divide.

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.