To set a custom print area in Excel for Microsoft 365 on Windows, select the cells you want, then choose Page Layout > Print Area > Set Print Area. Excel will print that range instead of the whole worksheet; you can change it later, add separate ranges, or clear it from the same menu.
What an Excel print area does
A print area is a saved range of worksheet cells designated for printing. It helps when a worksheet contains supporting calculations, notes, or reference data that should stay in the file but not appear on paper or in a PDF. For example, a sales worksheet might contain a detailed transaction table in columns A through H, while the report intended for distribution is only the summary in A1:D24. Setting A1:D24 as the print area keeps the transaction details out of the printed report without deleting or hiding them.
The setting belongs to an individual worksheet, not to the entire workbook. Each sheet can have its own print area, and a sheet without one normally prints its used content. The print area is saved with the workbook, so it remains in place when the file is saved and reopened. It affects printing and print preview, not the data people see while editing the worksheet.
A print area is also different from a page break. The area determines which cells are included; page breaks determine where included cells split across printed pages. A large print area can therefore span several pages, while a small one may fit on a single page.
Set a print area step by step
- Open the worksheet and select the cells you want to print. Drag across a continuous range, or click its first cell and use Shift while selecting its last cell.
- On the ribbon, choose Page Layout > Print Area > Set Print Area.
- Choose File > Print to inspect the result in Print Preview before sending it to a printer or creating a PDF.
For a concrete example, select A1:F32 if a report uses six columns and has 32 rows. Excel records that selection as the print area. The selection does not have to start at A1: a range such as C4:H28 is valid if the report begins farther into the sheet. Check the preview because the worksheet’s paper size, margins, orientation, and scaling settings affect how that range is divided across pages.
If the range is wrong, return to the sheet, select the intended cells, and choose Set Print Area again. Setting a new print area replaces the current area on that worksheet. If you want to keep the current area and include another range, use Add to Print Area instead.
Print multiple separate ranges
You can designate more than one range on a worksheet. Select the first range, then hold Ctrl while selecting another range on Windows. Choose Page Layout > Print Area > Set Print Area to define the selected areas together. To add a range after an area has already been set, select the additional cells and choose Page Layout > Print Area > Add to Print Area. On a Mac, use Command rather than Ctrl when making a nonadjacent selection.
Separate print areas are not automatically joined into one continuous table. Excel treats each area as a distinct print area, which can result in separate printed pages. This is useful for printing unrelated blocks, such as a chart and a small summary table, but it may create blank-looking space or page breaks that are not obvious from the worksheet view. Inspect every page in Print Preview, and consider placing related information in one contiguous range if you need it to read as a single report.
When adding ranges, remember that a later selection can expand the set of areas rather than replace it. If the preview includes an unwanted block, clear the print area and define the intended range again instead of trying to guess which selection remains saved.
Review page layout and print preview
After setting the area, choose File > Print. The preview shows what Excel is preparing to print, including page divisions and the selected printer’s paper settings. Use the page navigation controls to inspect every page, not just the first one. A range that looks tidy on the worksheet can split a heading from its table or put a final column on a separate page.
For a more visual view of page divisions while editing, choose View > Page Break Preview. This view makes page boundaries easier to see and allows manual page breaks to be adjusted. Return to Normal view when you are finished. A manual page break changes pagination; it does not remove cells from the print area.
Review these settings if the preview is not what you expect:
- Orientation: Page Layout > Orientation lets you choose Portrait or Landscape. Landscape may suit a wide table.
- Paper size: Page Layout > Size should match the paper or PDF page you intend to use.
- Margins: Page Layout > Margins controls the space around the printed content.
- Scaling: Page Layout includes Scale to Fit controls for fitting the worksheet to a chosen number of pages wide or tall.
Fit the area without making it unreadable
If a report spills onto extra pages, scaling can reduce its page count. In the Scale to Fit controls on the Page Layout tab, set Width or Height to a specific number of pages. For example, 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 print area onto one page.
Fitting everything to one page is not always the best choice. A wide or long worksheet may shrink until the text is difficult to read. Before using one-page scaling, consider Landscape orientation, narrower margins, or a more focused print area. If readers need to compare rows, it can be clearer to print across several pages at a readable scale than to force a very large range onto one sheet of paper.
For a multi-page table, repeating its heading row can help readers follow it. Choose Page Layout > Print Titles, then specify rows in Rows to repeat at top in the Page Setup dialog. Print Titles repeat selected row or column headings on pages; they do not define or enlarge the print area. Check the preview afterward to make sure the repeated headings and table fit as intended.
Change, add to, or clear the area
To replace a print area, select the new range and choose Page Layout > Print Area > Set Print Area. To extend the existing area with another range, select that range and choose Add to Print Area. To remove the saved print-area setting from the active sheet, choose Page Layout > Print Area > Clear Print Area. Excel then returns to printing the worksheet’s content according to its other page setup settings.
Clearing a print area does not delete cells, formatting, page breaks, or print titles. It only removes the range restriction. If you have grouped worksheet tabs, take care to check which sheets are selected before changing page setup; settings and actions applied to grouped sheets may affect more than the sheet you intended. Click an individual sheet tab before making a change when you want to work on only one sheet.
On Excel for Mac, the Page Layout tab has corresponding print-area controls, though the ribbon layout and selection modifier keys differ; use Command for nonadjacent selections. Excel for the web has a more limited set of page-layout controls than the desktop application. If you need to define or carefully manage custom print areas, open the workbook in the desktop version of Excel.
Common print-area problems
- The whole sheet prints: The desired range may not have been set, or the print area may have been cleared. Select the cells and use Set Print Area, then check File > Print.
- Some expected cells are missing: Check that they fall inside the selected range and that the range was set on the correct worksheet. Also review whether rows or columns are hidden and whether another print area was defined.
- The output has too many pages: Inspect orientation, paper size, margins, scaling, and page breaks. A print area can be correct while its layout still spans several pages.
- A blank page appears: Look for an extra print area, an unexpectedly large selected range, or page breaks that push content onto another page. Preview each page and clear and reset the area if necessary.
- Another sheet prints differently: Print areas are worksheet-specific. Set or clear the area on each sheet that needs its own output.
For a reliable check, save the workbook, open Print Preview, and compare the preview with the intended report: confirm the first and last rows and columns, the number of pages, and any repeated headings. If printing to PDF, use the same preview process; a PDF preserves the print layout rather than correcting an unsuitable one.
Print area versus print selection and print titles
These three options solve related but different problems. A print area is a persistent worksheet setting. It is useful for recurring reports because the range remains saved in the workbook. Print Selection is a one-time choice in the print settings for printing cells selected at that moment. It can be handy for a quick excerpt, but it does not replace the saved print area. Print Titles repeat chosen headings on multiple pages; they do not restrict which cells print.
For instance, if a manager regularly prints a report summary, set a print area once and verify its layout. If you only need to hand someone a few cells today, select them and choose Print Selection in the print settings. If a long table crosses several pages, set its print area and then configure Print Titles so its header row repeats. Choosing the right feature avoids changing the worksheet layout when only a one-time print is needed.
Frequently Asked Questions
Why is Excel printing the whole worksheet instead of my selected cells?
Check that you used Page Layout > Print Area > Set Print Area, rather than merely selecting the cells. Then open File > Print and confirm the print settings are not set to Print Entire Workbook or another unintended option.
Can I set more than one print area on a worksheet?
Yes. Select nonadjacent ranges and set them together, or select another range and use Add to Print Area. Because separate areas can print as separate blocks or pages, inspect the complete preview before printing.
How do I remove a custom print area?
On the worksheet with the setting, choose Page Layout > Print Area > Clear Print Area. The cells remain unchanged; Excel simply stops limiting output to that saved range.
Does a print area affect what other people see in the worksheet?
No. It controls print output, not the visible worksheet data during normal editing. The setting is saved with the workbook, so it can affect later printing by someone who opens the file.
Can I make the print area fit on one page?
Yes. Use the Scale to Fit controls on the Page Layout tab to set the width and height to one page. Check readability in Print Preview; reducing a large report too much can make its text hard to read.
Is a print area the same as a page break?
No. The print area specifies which cells are included, while page breaks control where those cells divide across pages. You may need to adjust both for a clean multi-page report.
Related
- Excel Data Validation for an Entire Column, Explained
- Excel Auto Group Rows: How to Group and Ungroup
- Excel Auto Group Rows by Cell Value: What You Can Do
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Insert Bullet Points in ExcelTo insert a bullet point in an Excel cell on Windows, select the cell, press Alt+0149 using the…
- Excel Find and Replace for Single QuotesTo find or replace a single quote in Excel for Microsoft 365 on Windows, press Ctrl+H, type the…
- Box Plot in Excel: Compare Multiple Data SetsYes. In Microsoft Excel for Microsoft 365 on Windows, put each data set in its own column, select…
- Creating a Schedule in Google Sheets: Steps and TipsTo create a schedule in Google Sheets, open a blank spreadsheet, add columns for dates, start and end…
- Excel: Pull Data From a Table Based on Multiple CriteriaTo pull a value from an Excel table using more than one condition, use XLOOKUP with a multiplied…
- Track Changes in Word: Turn It On, Review, and Accept EditsIn Microsoft Word for Microsoft 365 on Windows, open the Review tab and click Track Changes to record…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.