Excel Print Area: Where to Find, Set, and Clear It

In Excel for Microsoft 365 on Windows, find Print Area on the Page Layout tab: choose Page Layout > Print Area > Set Print Area. First select the cells you want to print; Excel will then restrict printing of that worksheet to that selection until you clear or change the print area.

Where the Print Area command is

Open the worksheet you want to print and look across the ribbon for the Page Layout tab. In the Page Setup group, open the Print Area menu. The menu includes commands to set a print area, add a selection to an existing area, or clear the area. If the ribbon is collapsed or the Excel window is narrow, the group or its labels may be compressed; maximize the window or expand the ribbon to find the command.

The command belongs to the active worksheet, not to the whole workbook. If a workbook has several sheets, each sheet can have its own print area. Check the sheet tab before setting one, especially if you are preparing a workbook with separate reports or forms.

How to set a print area

Use these steps to print only a particular block of cells:

On the worksheet, select the cells to include. For example, select A1:F28 if the report occupies columns A through F and rows 1 through 28.
Choose Page Layout > Print Area > Set Print Area.
Open File > Print to review the result in Print Preview before sending it to a printer or PDF.

You can select a range by dragging across the cells, or click the Name Box to the left of the formula bar, type a range such as A1:F28, and press Enter. The Name Box is useful when the range is large or extends beyond the visible screen. Setting a print area does not erase or hide the other worksheet cells; it only changes which cells Excel includes when printing that sheet.

To include separated blocks, hold Ctrl while selecting the additional ranges on Windows, then choose Page Layout > Print Area > Set Print Area. Excel treats separate print areas as separate print regions, and they may print on different pages. If you want a continuous report, it is often easier to select one rectangular range and leave blank cells within it than to create several disconnected areas.

What a print area does

A print area defines the worksheet cells Excel considers when printing. It is not the same as hiding rows or columns, filtering a table, or protecting cells. The data outside the defined area remains visible and editable on screen, and formulas outside the area continue to calculate normally. The boundary is a print instruction, not a change to the underlying data.

Excel stores the print area with the worksheet in the workbook. It remains in effect when you save and reopen the file, and it can affect what another person sees when they print that sheet. Since it applies to a worksheet rather than a particular print job, review it if you inherit a workbook or if a print preview unexpectedly omits data.

A defined print area is also different from choosing a temporary print selection in the print screen. The print area persists as a worksheet setting; a print-selection choice applies to the current print operation. If you regularly print the same report range, a print area is convenient. For a one-off print of a few cells, selecting the range and choosing the relevant print option may be quicker.

Adding, changing, or clearing the area

To replace the current area, select the new range and choose Page Layout > Print Area > Set Print Area. The new selection becomes the print area for that sheet. If you want to include an additional block without replacing the existing one, select the new cells and choose Page Layout > Print Area > Add to Print Area. Excel can maintain multiple areas, although the resulting page order and layout may not resemble one continuous table.

To remove the setting, choose Page Layout > Print Area > Clear Print Area. Clearing it does not delete worksheet content. Afterward, Excel can print the used portion of the sheet or whatever range you specify in the print options. If you are unsure whether an old area is causing a problem, clear it and check Print Preview; you can set the desired range again at any time.

There is no need to clear a print area just to change margins, orientation, or scaling. Those settings control how the chosen content fits on paper, while the print area controls which cells are chosen. Adjust the relevant setting according to the problem rather than resetting all print configuration.

Check the result in Print Preview

After setting an area, choose File > Print. The preview shows the pages Excel intends to print and helps you catch cut-off columns, unexpected blank pages, or content that has been scaled too small. Use the page navigation controls to inspect every page, not just the first one. A selection that fits on one screen can still span several printed pages.

If a report is too wide, try Page Layout > Orientation > Landscape. You can also adjust margins with Page Layout > Margins, or use the scaling controls in the Page Setup group, such as fitting the sheet to a specified number of pages. Scaling to one page wide can be useful for a wide table, but forcing both width and height to one page may make text difficult to read. Preview the result and choose readable output over an arbitrary page count.

For longer lists, repeated heading rows can make printed pages easier to understand. Set them through Page Layout > Print Titles, then specify rows to repeat at the top of each printed page. This setting complements the print area: the area determines what is included, while print titles repeat chosen labels across pages.

Common print-area problems

If only part of the expected report appears, check that the correct worksheet is active and inspect the range you selected before setting the area. Then look at Print Preview for page breaks and scaling. A row or column may be hidden, or the selected range may stop above or beside the missing cells. Clearing the print area and setting it again can remove an outdated boundary.

If Excel prints blank pages, the defined area may include empty rows or columns, or existing page breaks and scaling may be creating extra pages. Review the print preview page by page. You can also choose View > Page Break Preview to see how the worksheet is divided into printed pages. Return to Normal view when you are finished; changing views does not itself change cell data.

If new rows are added below a fixed print area, they may not be included automatically. Update the print area to cover the added rows, or clear it if you want Excel to determine the printable range. This is a frequent issue with reports that grow over time. For a workbook used as a recurring template, make a habit of checking the bottom edge of the print area after updating the data.

Finally, remember that print settings can interact. A correct print area can still produce poor output if the paper size, printer margins, orientation, or scaling is unsuitable. Check the selected printer and paper settings in the print screen as well as the worksheet’s Page Layout options.

Windows, Mac, and Excel for the web

In Excel for Microsoft 365 on Windows, use the Page Layout ribbon path given above. In Excel for Mac, the print-area controls are also on the Page Layout tab, under Print Area; the ribbon’s appearance can vary slightly with the window size and Excel version. The common print shortcut differs: use Ctrl+P on Windows and Command+P on Mac to open printing options.

Excel for the web has a more limited page-layout workflow than the desktop app, and its available print controls can change as Microsoft updates the service. If you cannot find a command to define or manage a persistent print area in the browser, open the workbook in the desktop Excel app and set it there. As a temporary workaround, use the browser’s available print options to print a selected range where offered, then inspect the preview. When another person needs a saved, repeatable print area, desktop Excel is the safer choice.

Frequently Asked Questions

Where is Print Area in Excel?

On Windows, open the worksheet and choose Page Layout > Print Area on the ribbon. Select the cells first, then choose Set Print Area.

How do I remove a print area in Excel?

Choose Page Layout > Print Area > Clear Print Area. This removes the printing boundary but does not delete any cells or worksheet content.

Why is Excel not printing all my data?

A saved print area may exclude the missing cells. Check the active worksheet and Print Preview, then expand or clear the area. Also look for hidden rows or columns, page breaks, and scaling settings.

Can I set more than one print area?

Yes. Select another range and choose Page Layout > Print Area > Add to Print Area. Separate regions may print as separate areas or pages, so verify their order and layout in Print Preview.

Does setting a print area hide cells on the worksheet?

No. It only limits what Excel prints from that worksheet. Cells outside the print area remain visible, editable, and available to formulas.

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.