An Excel print area is the cell range—or ranges—you choose to send to the printer or a PDF. In Excel for Microsoft 365 on Windows, select the cells, then choose Page Layout > Print Area > Set Print Area; use the same menu to add to or clear an existing area.
What a print area does
A worksheet can contain far more data than belongs in a printed report: notes, calculations, lookup tables, or unused columns may sit beside the information readers need. Setting a print area tells Excel which part of the active worksheet to include when you print. Cells outside it are left out of the printout, but they are not deleted, hidden, or protected. You can still view and edit them in the workbook.
The setting belongs to a worksheet, not to the whole workbook as one universal range. A workbook with several sheets can therefore have a different print area on each sheet. If no print area is defined, Excel normally considers the worksheet’s used cells when preparing it to print, which can produce pages you did not intend if formatting or stray content extends far from the main table.
A print area also does not decide how many pages the selected cells occupy. A wide or long range may span several pages. Page orientation, paper size, margins, scaling, and page breaks control how that range is laid out.
Set a print area in Excel
For a straightforward report, choose the exact cells you want included before setting the area. For example, if a monthly sales report occupies A1:F28, select that range rather than the entire worksheet.
- Select the worksheet tab you want to print.
- Drag across the required cells, or click the first cell and Shift-click the last cell in the range.
- Open the Page Layout tab on the ribbon.
- Choose Print Area, then Set Print Area.
- Open File > Print to inspect the preview before printing or saving a PDF.
Setting a new print area replaces the existing print area on that worksheet. If you select A1:F28 and choose Set Print Area, Excel will use that range rather than an older range that was set previously. Save the workbook to keep the setting for later sessions.
On Excel for Mac, use the Page Layout tab and the Print Area command as well. The common print-preview shortcut is Command+P on Mac; on Windows, use Ctrl+P. Ribbon details can vary slightly by Excel build, but the print-area command is in the Page Layout controls in the desktop app.
Add more cells or separate ranges
If an existing print area needs to include another block, select the additional cells and choose Page Layout > Print Area > Add to Print Area. This adds the new selection instead of replacing the current area. It is useful, for example, when a report has a summary at the top and a small notes table farther down the sheet.
Excel can include nonadjacent ranges in a print area. On Windows, hold Ctrl while selecting separate ranges; on Mac, use Command while selecting additional ranges. Then use Set Print Area for the selection, or add a further selection with Add to Print Area if an area is already defined. Check the preview carefully: separate areas may print on separate pages, rather than being brought together as one continuous table. Their position on the worksheet does not make them a single compact block.
To replace several separate blocks with one continuous range, select the full rectangle that contains them and choose Set Print Area. Keep in mind that this also includes the cells between the blocks, even if those cells look blank.
Check the area and adjust page layout
File > Print opens the print preview, which is the most direct way to see what Excel will send to the printer. Check every page, not only the first: a small overflow onto a second page can be easy to miss. The preview also helps reveal cut-off columns, unreadable scaling, blank pages, and unwanted extra ranges.
For a more visual view of page boundaries, choose View > Page Break Preview. This shows how the worksheet is divided into pages and lets you see where page breaks fall in relation to the print area. It is especially helpful when a selected range is too wide or long for one sheet of paper. Return to Normal view when you want to work with the worksheet in its usual layout.
If the preview looks wrong, adjust the print layout as well as the range:
- Choose Landscape instead of Portrait when a table has many columns.
- Check the paper size and margins in the Page Layout tab.
- In the Scale to Fit controls, set Width to 1 page if you need all columns to fit across one page. Leave Height set to Automatic when the report can continue onto additional pages.
- Use scaling cautiously: forcing both width and height to 1 page can shrink a large report until its text is difficult to read.
- Inspect page breaks if rows or columns split in awkward places. A print area does not remove or override all page-break decisions.
These settings affect presentation, not the worksheet’s underlying values. If the output is too small, it may be better to use landscape orientation, narrower margins, or more pages rather than compressing everything onto one sheet.
Repeat headings on every printed page
A print area defines which cells are eligible to print, but it does not repeat column headings automatically. When a table spans several pages, readers may see data on later pages without knowing what each column means. To repeat headers, use Page Layout > Print Titles. In the Page Setup dialog, set Rows to repeat at top to the heading row or rows, such as $1:$1, then confirm the setting.
You can also repeat left-side columns on each page by setting Columns to repeat at left. This is useful for long tables where the first column contains names or identifiers and the remaining columns continue across several printed pages. Print titles and print areas solve different problems: one limits the included cells, while the other repeats specified headings or labels on printed pages.
Clear or change a print area
To remove the saved area from the active worksheet, choose Page Layout > Print Area > Clear Print Area. Excel will no longer use that restricted range for the sheet, and printing will again be based on the worksheet’s printable content and other print settings. Clearing the area does not erase any cell contents.
If only the boundaries need changing, select the new range and choose Set Print Area. If the new cells are additional blocks that should print alongside the existing area, use Add to Print Area instead. When you are unsure which ranges are currently included, open File > Print and examine the preview before changing anything.
Remember that the command applies to the currently active worksheet. If the workbook has several sheets, click the relevant sheet tab first. Changing the print area on one tab does not automatically change the ranges on the others.
Common print-area problems
Excel prints only part of the table. The defined range may stop before the last row or column. Select the full intended range and set it again, then check the preview. If new rows are added to a report, do not assume the old print area has expanded; review it and update it when the report grows.
The printout includes an unexpected blank page. Check for a distant print-area block, page breaks, or formatting far from the visible table. In Page Break Preview, inspect the page divisions. Clear the print area and set it again if the saved range is no longer appropriate.
The content is tiny. The print area may be correct while scaling is set to fit too much content onto too few pages. Set the scaling width to one page but allow the height to use multiple pages, or choose a larger paper size if the printer supports it.
New data does not appear. A print area is a defined range, not a guarantee that the range will grow whenever data is added. Extend the area or set a new one after adding rows or columns, and confirm the result in preview.
The headings appear only on the first page. Set the appropriate rows or columns in Print Titles. Enlarging the print area will not repeat headings, because that is a separate page-setup feature.
Print area versus Print Selection
A saved print area is useful when you expect to print the same part of a worksheet repeatedly. It remains associated with the sheet after you save the workbook. Print Selection is more appropriate for a one-time print of a range: select the cells, open File > Print, and choose Print Selection in the print settings. This prints the current selection without replacing the worksheet’s saved print-area setting.
Neither option changes the data in the workbook. Hiding rows or columns is different again: it changes what is visible in the worksheet, whereas a print area explicitly defines what belongs in the printed output. For a reusable report, set and save the print area; for a quick extract that should not change the sheet’s normal print setup, use a selection.
In Excel for the web, printing and page-layout controls can differ from the desktop app. If you need to create or maintain a persistent print area and do not see the relevant controls, open the workbook in the desktop version of Excel, set the area there, and save the workbook.
Frequently Asked Questions
How do I set a print area in Excel?
Select the cells, then choose Page Layout > Print Area > Set Print Area. Use File > Print to check the pages before printing.
How do I print only selected cells without saving a print area?
Select the cells, open File > Print, and choose Print Selection in the settings. This is convenient for a one-time print and does not replace the worksheet’s saved print area.
Why is Excel printing blank pages?
Look for extra print-area blocks, unexpected page breaks, or worksheet content and formatting far beyond the report. Check View > Page Break Preview and the File > Print preview, then clear or reset the area if needed.
Does a print area update automatically when I add rows?
Do not rely on it to expand. Check the range after adding data and use Set Print Area to redefine it, or Add to Print Area to include additional cells without replacing the current area.
Can I have more than one print area on a worksheet?
Yes. Add separate ranges with Add to Print Area. Because separate blocks can print on separate pages, preview the result to confirm that the page order and layout suit the report.
Related
- Excel Heat Maps: How to Create, Format, and Read Them
- Excel Group Rows: How to Collapse and Expand Data
- Excel Named Range: What It Is and How to Use It
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Shortcut Keys Videos: What to Watch and LearnYes—Excel shortcut keys videos can show you how to use keyboard commands in real worksheets, and they are…
- Future Out of Office in Outlook: How to Schedule ItTo schedule a future out-of-office reply in Outlook, open Automatic Replies, turn on the option to send replies…
- Pay Off Debt Snowball Spreadsheet: Build One in ExcelYes—a debt snowball spreadsheet can help you list balances from smallest to largest, track payments, and see when…
- How to Add a Draft Watermark in Word on Every PageTo add a Draft watermark in Word for Microsoft 365 on Windows, open the document and choose Design…
- Find and Replace Enter in Excel: Remove Line BreaksTo find and replace an Enter line break inside Excel cells, press Ctrl+H, click the Find what box,…
- How to Insert a Horizontal Line Under a Heading in WordTo add a line beneath a heading in Microsoft Word, click in the heading paragraph, then choose Home…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.