In Excel, a print area is the cell range or ranges you choose to print from a worksheet. In Microsoft Excel for Microsoft 365 on Windows, select the cells, then choose Page Layout > Print Area > Set Print Area; Excel prints that selection instead of the entire sheet.
What a print area does
A worksheet can contain far more information than belongs on a printed page: calculations, reference lists, notes, or data prepared for later use. Defining a print area tells Excel which part of that worksheet to include when printing. Cells outside the area remain in the workbook and are not deleted or hidden; they are simply left out of that sheet’s printout while the area is in effect.
The print area is saved with the workbook and applies to an individual worksheet, not automatically to every sheet in the file. For example, a sales sheet might print a summary table in A1:F24, while a separate inventory sheet has its own print area. You can define, change, or clear those areas independently.
Setting an area does not guarantee that the output will fit neatly on one page. Paper size, orientation, margins, scaling, and page breaks still affect how Excel divides the selected cells. Use Print Preview to check the result before sending it to a printer or saving it as a PDF.
How to set a print area
Use the following steps in Excel for Microsoft 365 on Windows:
- Open the worksheet you want to print.
- Select the cells to include. Drag across a range, or click the first cell and Shift-click the last cell to select a rectangular block.
- Open the Page Layout tab on the ribbon.
- Choose Print Area, then Set Print Area.
- Choose File > Print, or press Ctrl+P, and review the preview.
For a concrete example, suppose a worksheet has a report in A1:G30 and supporting calculations in columns J through L. Select A1:G30 and set it as the print area. The report will be included in the printout, while the calculation columns remain available on screen but outside the printed area.
Excel’s desktop ribbon on Mac has a similar Page Layout > Print Area > Set Print Area command, though the ribbon layout can vary slightly by release. The usual print shortcut on Mac is Command+P rather than Ctrl+P. Excel for the web has more limited page-layout controls; if you need to create or change a saved print area, open the workbook in the desktop app.
Using more than one range
A print area does not have to be one continuous rectangle. To select separate blocks in Excel for Windows, select the first range, then hold Ctrl while selecting additional ranges. On Mac, use Command while selecting additional ranges. With the ranges selected, choose Page Layout > Print Area > Set Print Area.
For instance, a worksheet might have a small title block in A1:D4 and a separate table in A8:D22. You can select both ranges and set them as the print area. Excel treats the separate blocks as separate print areas for printing; they may print on separate pages rather than being joined into one continuous table. Check Print Preview, because the page layout and scaling determine exactly how the output is arranged.
If an area is already set and you want to include another selection, choose Page Layout > Print Area > Add to Print Area. This adds the selected cells to the existing print area rather than replacing it. For a simpler, uninterrupted report, it is often easier to select one larger rectangle, even if that means some blank cells are included.
Fit the print area to the page
After choosing the cells, decide how they should be distributed across pages. On the Page Layout tab, the Scale to Fit controls let you set the printout’s width and height in pages. Setting Width to 1 page can keep all columns together while allowing the rows to continue onto additional pages. Setting both Width and Height to 1 page attempts to compress the entire area onto one page.
Scaling everything to one page can make text too small to read, especially for a wide or long report. Consider these adjustments before shrinking it:
- Use Landscape orientation for a report with many columns: Page Layout > Orientation > Landscape.
- Choose a suitable paper size under Page Layout > Size, if your printer supports it.
- Reduce excess margins with Page Layout > Margins.
- Remove unnecessary blank columns or rows from the selected area.
- Allow a long report to use multiple pages instead of forcing its height to one page.
For a table that spans multiple pages vertically, repeat its header row on each page if readers need column labels throughout. Choose Page Layout > Print Titles, then set the rows to repeat at the top in the Page Setup dialog box. Print titles are separate from the print area: they repeat designated headings but do not, by themselves, determine which cells are printed.
Change or clear a print area
To replace the existing area, select the new range and choose Page Layout > Print Area > Set Print Area. The new selection becomes the print area for the active worksheet. To remove the restriction and allow the worksheet’s used content to be considered for printing, choose Page Layout > Print Area > Clear Print Area.
Clearing the print area does not clear cell contents, formatting, or page setup. It only removes the saved range restriction. Likewise, setting a print area does not change what is visible in the worksheet or what formulas calculate.
A defined range is usually fixed rather than a dynamic instruction to include future data. If a report grows beyond the original boundary, check whether new rows or columns are included. Re-select and set the expanded range, or add the new selection to the existing area. When a formatted Excel table expands, do not assume its print area will always expand with it; review the saved area and preview the printout after adding data.
Print area, page breaks, and print selection
These settings address different parts of printing. A print area identifies which cells are eligible to print. Page breaks determine where Excel divides those cells between pages. Scaling controls how large the eligible content appears. Changing one does not necessarily fix problems caused by another.
For example, if a print area includes eight columns but the preview shows the last two on a second page, the area may be correct while the scaling or page layout is not. If the break occurs in an awkward place, use View > Page Break Preview to inspect and adjust page breaks. Return to Normal view when finished.
Printing a selection is a useful alternative for a one-time job. Select cells, open File > Print, and use the print settings to choose Print Selection if that option is available in the current desktop version. This does not serve the same purpose as a saved print area: a saved area is more convenient for repeated printing, while a one-off selection avoids changing the worksheet’s ongoing print setup. If the print dialog offers different wording or choices, confirm the output in its preview.
Common print-area problems
- The wrong cells print: Confirm that you are on the intended worksheet and that the range shown in Print Preview is correct. A print area belongs to a sheet, so another sheet may have a different one.
- Extra blank pages appear: The print area may include empty rows or columns, or page breaks and scaling may be pushing content onto another page. Check Page Break Preview and the print preview before changing the area.
- The report is too small: Excel may be fitting too many rows and columns onto one page. Change the Scale to Fit height setting, use landscape orientation, or let the report span multiple pages.
- New data is missing: The print area may not include rows or columns added after it was set. Expand the range or set a new one, then check the preview.
- Only part of a table prints: The selected range may stop before the final column or row. Select the complete table and set the area again.
- A previous setup seems to return: Check whether the workbook was saved after the change and whether you are editing the correct sheet. A print area is workbook data, so unsaved changes may not be present when the file is reopened elsewhere.
When diagnosing a problem, first inspect the range itself, then check orientation, margins, scaling, and page breaks. Changing several settings at once can make it harder to tell which one caused the improvement or the new issue.
Practical choices for repeat printing
A good print area includes the information a reader needs, not every cell that happens to contain data. Include useful headings and totals, but avoid distant notes or calculations unless they belong in the report. If the sheet is used regularly, save the workbook after setting the area and verify the print preview again whenever its layout changes.
For a recurring report that grows over time, make a quick check part of the printing routine: confirm the final row and column, review the page count, and make sure headings remain readable. If different audiences need different outputs, separate worksheets with their own print areas can be clearer than repeatedly changing one sheet’s setup.
Frequently Asked Questions
Does setting a print area delete or hide the other cells?
No. It only limits what prints from that worksheet. The other cells remain in the workbook and can still be viewed and edited.
How do I remove a print area in Excel?
On the worksheet with the area, choose Page Layout > Print Area > Clear Print Area. This removes the print restriction but does not erase the worksheet’s data.
Can I set different print areas on different sheets?
Yes. Each worksheet can have its own print area. Activate a sheet and set or clear its area separately; setting one does not automatically apply the same range to every sheet.
Why does my print area print on several pages?
A print area can span multiple pages when its rows or columns do not fit the chosen paper size and scaling. Review orientation, margins, Scale to Fit settings, and page breaks in Print Preview.
Does a print area automatically include new rows?
Not necessarily. A saved print area can exclude data added beyond its boundaries, so expand or reset the range when a report grows and check the preview.
Related
- Circular Cell Reference in Excel: Causes and Fixes
- Circular Reference Settings in Excel: How They Work
- Change the Print Area in Excel: Steps and Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Freezing Up and Not Responding? What to Do NowIf Excel is freezing or showing “Not Responding,” first wait briefly if it may be calculating or loading…
- How to Insert a Table of Contents in Microsoft WordTo insert an automatic table of contents in Microsoft Word for Microsoft 365 on Windows, apply built-in heading…
- How to Change Date Format in an Excel Column EasilyTo change the date format for an Excel column, select the column, press Ctrl+1 on Windows, choose Date…
- Google Sheets Freeze Bottom Row: What Works InsteadNo. Google Sheets can freeze rows at the top of a sheet, but it has no built-in command…
- Import CSV Into an Existing Excel Table: Steps & TipsYes. In Excel for Microsoft 365 on Windows, import the CSV to a staging worksheet with Data >…
- Outlook Share Calendar Button Does Nothing? Fixes That WorkIf Outlook’s Share Calendar button does nothing, first check whether a sharing window opened behind Outlook, then try…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.