Excel Print a Certain Area: Set a Print Area

How-to basics · Updated November 21, 2026

To print only part of a worksheet in Excel for Microsoft 365 on Windows, select the cells you want, then choose Page Layout > Print Area > Set Print Area. Open File > Print to check the preview and print; Excel will keep that print area with the workbook until you clear or change it.

What an Excel print area does

A print area is a range of worksheet cells that Excel treats as the part to print. It is useful when a sheet contains working notes, source data, calculations, or other information that should stay in the workbook but not appear on paper. For example, a sales worksheet might contain a large transaction table and a small summary. Setting the summary cells as the print area lets you print that report without deleting or hiding the transaction data.

The print area affects printing, not the worksheet itself. It does not remove cells, change formulas, or prevent you from viewing or editing the rest of the sheet. It is also separate from the active cell and from a selection made just before printing. Once saved, the print area is a worksheet setting, so opening the workbook later does not automatically restore printing of the entire sheet.

Each worksheet can have its own print area. This makes the feature convenient for workbooks that contain several reports on separate tabs, but it also explains why printing another sheet may produce a different result. Check the active worksheet and its print settings before sending a workbook to a printer.

Set a print area in Excel

  1. Open the worksheet and select the cells to include. Drag across a continuous range, or click a cell and use Ctrl+A carefully: depending on the active cell and surrounding data, it may select the current data region rather than the whole worksheet.
  2. On the ribbon, choose Page Layout > Print Area > Set Print Area.
  3. Choose File > Print to review the print preview. If it looks right, select the printer and print.

For example, if a report occupies cells A1 through G28, select A1:G28 before setting the print area. Excel then uses that range for printing, while cells outside it remain unchanged and available for editing. The preview is important: it shows whether the selected content fits on one page or spills onto additional pages based on the sheet’s paper size, orientation, margins, and scaling.

On Excel for Mac, select the range and use the Page Layout tab’s Print Area control to set it; ribbon labels and layout can differ slightly by release. The print dialog is available with Command+P on Mac. On Windows, Ctrl+P opens the print screen. These shortcuts open the preview and settings; they do not by themselves define a print area.

Print a selected range without saving a print area

If you only need to print a range once, you can print the current selection rather than changing the worksheet’s saved print-area setting. Select the cells, choose File > Print, and under Settings choose Print Selection if that option is available in the print screen. Check the preview before printing.

This approach is handy for a one-off handout or a quick extract from a larger sheet. It avoids leaving a persistent print area that could surprise someone the next time they print the worksheet. By contrast, setting a print area is better for a recurring report because the same range remains the default print content for that worksheet.

Do not assume that simply highlighting cells and pressing Ctrl+P always means only those cells will print. The print screen’s selected setting may still be Print Active Sheets or another option. Confirm that it says Print Selection and inspect the preview. If the selection option is missing or the preview is unexpected, use the worksheet’s print-area command or check which cells are selected.

Print more than one separate range

You can include nonadjacent ranges in a print area, such as a title block and a small chart data table that are far apart. On Windows, hold Ctrl while selecting the separate ranges; on Mac, hold Command. Then choose Page Layout > Print Area > Set Print Area.

Excel treats separate print-area regions as separate areas for printing, so they may appear on separate pages rather than being laid out together as one continuous block. Review the preview to see the actual page arrangement. If the goal is to place the content together in a particular order, it may be simpler to copy or reference the desired information into a compact report section and set that contiguous section as the print area.

To extend an existing print area, select the additional cells and choose Page Layout > Print Area > Add to Print Area. This adds the selection rather than replacing the current area. If you choose Set Print Area for a new selection, Excel replaces the existing print area with the new selection. This distinction matters when a worksheet already has carefully arranged print regions.

Make the printed pages fit and read well

A correctly selected range can still produce an awkward printout if it is too wide, too tall, or formatted for a different paper size. Use the preview to diagnose the layout before changing the print area itself. Under the Page Layout tab, review options such as orientation, paper size, margins, and scaling.

  • Change orientation: Choose Page Layout > Orientation and select Portrait or Landscape. Landscape often helps with a wide table, but it uses less vertical space.
  • Adjust scaling: In Page Layout > Scale to Fit, set the width or height to fit the report across a chosen number of pages. Fitting a very wide table onto one page can make text too small to read.
  • Review margins and paper: Choose suitable margins and a paper size that matches the printer. A worksheet designed for one paper size may wrap or scale differently on another.
  • Control page breaks: Use View > Page Break Preview to see how the printout is divided. Adjust page breaks when rows or columns split in inconvenient places, then return to the normal worksheet view when finished.

For instance, a table with eight columns may fit on a landscape page at a readable scale, while forcing a much wider table onto one page could shrink its labels until they are difficult to read. It can be better to let the table span two pages across, repeat its header row, or make a separate summary for printing than to prioritize a one-page result at any cost.

If a report spans multiple pages vertically, repeating column headings can help readers follow the data. Use Page Layout > Print Titles to specify rows to repeat at the top or columns to repeat at the left. This setting is different from the print area: it controls repeated headings on pages, not which cells are included.

Change or clear a print area

To replace the current area, select the new range and choose Page Layout > Print Area > Set Print Area. To add another region without discarding the existing one, use Add to Print Area. If the worksheet should print normally again, choose Page Layout > Print Area > Clear Print Area.

Clearing the print area does not delete data or formatting. It removes the saved limit on what the worksheet prints, so Excel can print the used content according to the other print settings. If the preview still shows only a few cells after clearing, check whether the print screen is set to Print Selection, whether only one sheet is selected, or whether a page-break or scaling setting is affecting the result.

After changing the range, save the workbook if you want the new print-area setting to travel with the file. When sharing a report, it is considerate to check the saved print preview as well as the visible worksheet: recipients may otherwise print a different range than expected.

Common print-area problems

  • The printout is blank or missing rows: Confirm that the intended cells are inside the print area and that rows or columns have not been hidden. Check the preview and clear or reset the area if necessary.
  • Excel prints too many pages: Look for an unexpectedly large print area, a selection that includes distant cells, or scaling and page-break settings that divide the content. Reset the area to the actual report range.
  • Only the highlighted cells print: The print screen may be set to Print Selection. Choose the intended option, such as printing the active sheet, or set a persistent print area.
  • The report is tiny: Excel may be scaling the entire range to fit a single page. Change the fit settings or allow more pages so the text remains readable.
  • A print area seems to return: The workbook may have been saved with an earlier print area, or you may be working on a different worksheet. Check the active tab, clear the area on the relevant sheet, and save the workbook.

Another frequent misunderstanding is that hiding rows or columns is the same as defining a print area. Hiding cells changes what is displayed and can affect what prints, but it is not a clear, durable way to specify a report range. Use a print area when the intention is specifically to control the worksheet’s printed content.

Print area versus page layout and print selection

These controls solve different problems. A print area defines which worksheet cells are eligible to print by default. Print Selection prints the currently selected cells for that print job. Scaling changes how the printable content fits on pages. Page breaks determine where that content is divided. Adjusting one does not necessarily correct a problem caused by another.

Choose a saved print area when the same portion of a sheet is printed repeatedly. Choose Print Selection for a temporary extract. Use orientation, margins, scaling, and page breaks when the correct content is included but the page layout is poor. For regular reports, keep the data intact, create a clearly formatted report section, and set that section as the print area. This makes the printed output more predictable without changing the underlying records.

Frequently Asked Questions

How do I print only certain cells in Excel?
Select the cells, choose Page Layout > Print Area > Set Print Area, then check File > Print. For a one-time job, choose Print Selection in the print settings instead.

How do I remove a print area in Excel?
On the worksheet with the saved area, choose Page Layout > Print Area > Clear Print Area. The cells remain in the sheet; Excel simply removes the saved printing limit.

Can I set two print areas on one worksheet?
Yes. Select separate ranges while holding Ctrl on Windows or Command on Mac, then set the print area. Separate regions can print on separate pages, so confirm their layout in the preview.

Why is Excel printing blank pages?
Check for a print area that includes empty cells, hidden rows or columns, unexpected page breaks, or an unsuitable scaling setting. The print preview usually shows where the extra pages are coming from.

Does a print area change what is saved in the worksheet?
No. It changes the worksheet’s print setting, not its cell values or formulas. The saved setting can affect later print jobs, so clear it if future users should print the whole sheet.

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.