“No print area set” in Excel usually means the worksheet has no saved range restricting what can print; it is not an error. Excel can still print the active sheet, using the print option and page settings you choose. To define a fixed range in Excel for Microsoft 365 on Windows, select the cells and choose Page Layout > Print Area > Set Print Area.
What a print area does
A print area is a range of cells that Excel treats as the intended output for a worksheet. It can keep notes, calculations, or an unused portion of a sheet out of printed pages. Once set, the area is saved with the workbook and normally remains in effect when you print that sheet again.
A print area is not the same as the worksheet’s used range. The used range is the portion Excel considers to have been used, which can extend beyond visible data if cells were formatted or edited and later cleared. A print area is an explicit instruction about what to print; it can be smaller or larger than the area containing the data you care about.
The setting applies to an individual worksheet, not automatically to every sheet in the workbook. If one sheet has a print area and another does not, each sheet can behave differently when you print the whole workbook. Excel stores the print-area setting as part of the workbook, so opening the file on another computer can preserve it.
What Excel prints when no area is set
With no saved print area, Excel does not have a fixed range to use as a boundary. In the usual case, printing the active sheet includes its printable content, laid out across as many pages as needed. The actual result also depends on your selection in the Print screen, scaling, paper size, orientation, margins, hidden rows or columns, and page breaks.
For example, suppose a monthly report occupies A1:F35, while a calculation in column J and some formatted cells lower down are also present. If no print area is set, the output may extend beyond the report, potentially adding extra columns or pages. If the print area is set to A1:F35, Excel has a clear range boundary for that sheet. You may still need to adjust scaling or page breaks to make those cells fit neatly.
“No print area set” does not necessarily mean Excel will print every cell in the grid. Worksheets have over a million rows and more than 16,000 columns, and blank grid cells are not normally treated as a request to print the entire sheet. The practical concern is that stray content or formatting can make Excel’s printable extent larger than you expect.
How to set a print area
On Excel for Microsoft 365 for Windows, select the contiguous range you want to print, then choose Page Layout > Print Area > Set Print Area. For the example report, select A1:F35 first. The selected range becomes the print area for the active worksheet.
You can also define more than one range by holding Ctrl while selecting separate cell ranges, then choosing Set Print Area. Excel treats the separate selections as distinct print areas; they may be printed as separate blocks rather than being combined into one continuous table. This is useful for unrelated sections, but it can make pagination less intuitive. If you need a single, orderly report, arranging the data in one rectangular range is often easier.
After setting the range, check the result before sending it to a printer:
- Choose File > Print, or press Ctrl+P on Windows, to open print preview.
- Check that the correct sheet and printer are selected and that the preview shows the intended cells.
- Review the page count, orientation, paper size, margins, and scaling options.
- Return to the worksheet and adjust the range or layout if the preview cuts off or adds unwanted pages.
On Excel for Mac, the Print Area commands are available from the Page Layout tab in supported desktop versions. The print shortcut is Command+P rather than Ctrl+P. Excel for the web has fewer page-layout controls; if you cannot find the command to set or clear a print area, open the workbook in the desktop app.
How to clear or change a print area
To remove the saved boundary in Excel for Windows, activate the relevant worksheet and choose Page Layout > Print Area > Clear Print Area. This does not delete worksheet data. It only removes the print-area instruction, so Excel returns to printing based on the available sheet content and your print settings.
To replace an existing area, select the new range and choose Set Print Area. Excel updates the area for that sheet. If a range seems to remain after you have changed it, first confirm that you are on the correct worksheet: a print area on one sheet does not automatically change the print area on another. Also check the print preview after changing it, because scaling and page breaks can still make the result look unexpected.
For a one-time print of a different range, you do not always need to change the saved print area. Select the cells, open File > Print, and choose Print Selection in the settings. This is useful for a quick excerpt, but it is different from setting a print area that will guide future prints of the worksheet.
Print area, print selection, and page layout compared
These controls solve different problems, so choosing the right one can prevent a common source of confusion:
- Print area: A saved range for a worksheet. Use it when the same part of the sheet should be the normal output each time.
- Print Selection: A choice for a particular print job. Use it when you need a temporary excerpt and do not want to replace the sheet’s saved setup.
- Print Active Sheets: Prints the selected worksheet or worksheets. If several sheet tabs are grouped, more than one may be included.
- Print Entire Workbook: Prints every worksheet in the workbook, respecting each sheet’s own print settings where applicable.
- Scaling and page breaks: Control how content is divided or shrunk across pages; they do not define which cells belong to a print area.
For instance, a print area can correctly include A1:F35 and still span two pages if the columns are too wide for the selected paper. In that case, adjust orientation, margins, scaling, or page breaks rather than assuming the print area was ignored. Conversely, fitting a worksheet to one page may make text too small to read even though the range is correct.
Preview, page breaks, and repeat headings
Print Preview is the most direct way to see what the current settings will produce. Choose File > Print and inspect each page. Look for clipped columns, a nearly empty extra page, unreadably small text, or repeated blank space. Preview reflects the current printer and paper settings, so the layout can change if you select a different printer or paper size.
For more control over page boundaries, choose View > Page Break Preview. Blue lines show where Excel divides the sheet into pages, and you can adjust page breaks by dragging them. Return to Normal view when you are done. Page breaks affect pagination, but they do not create or remove the saved print area.
If a long report spans multiple pages, you may want its column headings repeated at the top of each page. Choose Page Layout > Print Titles and set rows to repeat at top, such as row 1. This is separate from the print area: the print area determines the range, while Print Titles helps readers understand continued pages.
Common problems and practical fixes
- Extra blank pages: Check for stray values or formatting far below or to the right of the report, then review Page Break Preview and the print area. Clearing formatting from unused cells can help when it has extended the apparent used range; save the workbook and reopen it to confirm the change.
- Only part of the report prints: Confirm the selected worksheet, saved print area, and Print screen setting. If you chose Print Selection, Excel prints the current selection rather than necessarily printing the full report.
- The report is split across pages: Inspect orientation, paper size, margins, scaling, and page breaks. A correct print area does not guarantee a one-page result.
- A print area seems to vanish: Confirm that the workbook was saved after the change and that you are checking the same sheet. Print areas are worksheet-specific.
- Other worksheets print too: Check whether multiple sheet tabs are selected or whether the Print screen is set to Print Entire Workbook instead of Print Active Sheets.
When clearing old formatting, take care not to remove useful styles or data validation from cells that are part of the workbook’s workflow. If the file is important, save a separate copy before making broad cleanup changes. The goal is to remove accidental extent without damaging the worksheet’s intended design.
When to set a print area—and when not to
Set a print area when a sheet contains a stable report, form, invoice, or dashboard and only a defined block should normally appear on paper. It is especially helpful when supporting calculations sit beside the report or when people who use the workbook may not know which cells to select.
Leave the print area unset when the worksheet’s printable content changes regularly and you want Excel to accommodate that changing extent. A transaction log that gains rows each week, for example, may need its print setup reviewed as it grows. A fixed print area can exclude new rows added outside its boundary, so update it when the report expands.
For recurring reports, consider turning the data into an Excel table and designing a separate, clearly bounded report sheet if the printed layout needs to remain consistent. A table can make data easier to manage, but it does not automatically solve every print-layout issue. Preview remains important whenever the number of rows or columns changes.
Frequently Asked Questions
Is “No print area set” an Excel error?
No. It generally indicates that the worksheet has no explicitly saved print area. Excel can still print the active sheet or a selected range; check File > Print to see which content and settings will be used.
Will Excel print the whole worksheet if no print area is set?
Not the entire blank cell grid. Excel prints the content relevant to the selected print option and worksheet layout. Stray data or formatting can extend the output, so inspect Print Preview if extra pages appear.
How do I print only selected cells without saving a print area?
Select the cells, choose File > Print, and select Print Selection in the print settings. That is a job-specific choice; it does not replace the worksheet’s saved print area.
Does a print area apply to every sheet in a workbook?
No. A print area belongs to an individual worksheet. Set or clear it separately on each sheet that needs a different printed range. When printing the entire workbook, review the preview because sheets can have different layouts.
Why does a set print area still print on multiple pages?
A print area defines which cells are included, not how large they appear on paper. Page size, orientation, margins, scaling, and manual page breaks determine whether that range fits on one page or several.
Related
- Excel Flash Fill: How to Use It and Choose Options
- Excel Scatter Plot: How to Create, Format, and Read It
- Excel: How to Split Text Into Two Columns Without Errors
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- FindTime Not Working in Outlook? Fix Scheduling PollIf FindTime is not working in Outlook, look for Scheduling Poll: Microsoft replaced the FindTime add-in with this…
- Hyperlink Not Working in Outlook 365? Fixes to TryIf a hyperlink is not working in Outlook 365, first test it with Ctrl+click in classic Outlook, then…
- Excel #VALUE! Error: Why It Happens and How to Fix ItYou keep getting a #VALUE! error in Excel because a formula is receiving a value or argument it…
- Fix Date Format in Google Sheets: Dates ExplainedTo fix a date’s appearance in Google Sheets, select the affected cells and choose Format > Number >…
- Excel Cell Won’t Change Color? Find the FixIf an Excel cell won’t change color, check whether Conditional Formatting is controlling its fill; a rule can…
- Excel Not Increasing Numbers When Dragging? Fix ItIf Excel repeats a number instead of counting up when you drag the fill handle, select the starting…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.