In Excel for Microsoft 365 on Windows, select the cells you want to print, then choose Page Layout > Print Area > Set Print Area. Check the result with File > Print; the saved print area limits printing to that range until you change or clear it.
Set a print area step by step
A print area tells Excel which cells on a worksheet belong in the printed output. It is useful when a sheet contains working notes, reference tables, or calculations that should remain in the workbook but not appear on paper. Set it on the worksheet you intend to print; the setting belongs to that sheet rather than applying to the entire workbook.
- Open the worksheet and select the cell range you want printed. For example, select A1:F28 to include a report title, five columns of data, and its totals.
- Open the Page Layout tab on the ribbon.
- Choose Print Area > Set Print Area.
- Choose File > Print, or press Ctrl+P, to review the preview before printing.
Excel marks the selected range as the print area. The cells outside it remain visible and editable in the worksheet; they are not deleted or hidden. Save the workbook to retain the setting for later use. If you select cells on another worksheet and set a print area there, that sheet has its own setting.
Change, add to, or clear the print area
To replace an existing print area, select the new range and choose Page Layout > Print Area > Set Print Area again. This replaces the previous area on the active worksheet. If you want to keep the current print area and include another range, select the additional cells and choose Page Layout > Print Area > Add to Print Area. Excel treats separated ranges as separate print areas, which may print on separate pages.
To remove the restriction, choose Page Layout > Print Area > Clear Print Area. Clearing the print area does not clear cell contents, formatting, or page breaks; it simply removes the range boundary that controls what Excel prints. If the menu options are unavailable, first check that you are in a worksheet rather than a chart sheet and that the workbook is not preventing edits.
Choose the right range, including separate blocks
Include only the material that belongs together in the printed document. A useful range often includes column headings and totals, not just the rows of data. For instance, a monthly expense report might use A1:E32 so the title, date labels, category names, amounts, and final total appear together. Leaving out a heading can make a printed page difficult to interpret, even if the numbers are correct.
To select more than one non-adjacent range in Windows, select the first range, then hold Ctrl while selecting the additional ranges. On Mac, use Command while selecting additional ranges. Set the print area after making the selection. Be aware that separated blocks can be paginated independently, so a small second block may appear on its own page. If the pieces need to read as one continuous report, it is usually clearer to place them together in one rectangular range or adjust the sheet layout.
Fit the print area to paper without shrinking it too far
Setting a print area decides which cells print; it does not guarantee that the selected cells fit on a single page. If the preview shows extra pages, adjust the layout separately. In Page Layout, try Orientation > Landscape for a wide table, or select a suitable paper size and margins. A wider page can make column labels easier to read without reducing the text size as much.
Excel also provides scaling controls in the Scale to Fit group on the Page Layout tab. Setting Width to 1 page and leaving Height automatic can fit all columns across one page while allowing rows to continue onto additional pages. Setting both width and height to one page forces the entire print area onto a single sheet of paper. That can make a large report extremely small, so inspect the preview and consider whether a readable multi-page printout is better.
Margins and paper size matter too. A range that seems to fit may spill onto another page because the printer has non-printable margins or because the selected paper size differs from the paper loaded in the printer. Change one setting at a time and review the preview again. Avoid assuming that shrinking everything to one page is always the best result: legibility is more important than using the fewest sheets.
Understand page breaks and repeating headings
Page breaks control where printed pages divide; they are related to, but not the same as, a print area. To inspect pagination, choose View > Page Break Preview. The view shows the page boundaries for the worksheet, including how the current layout divides the printable content. You can adjust page breaks in this view when the division cuts through a table awkwardly. To return to the usual worksheet view, choose View > Normal.
For a long table, repeating its heading row on each page can help readers follow the columns. Choose Page Layout > Print Titles, then use the Rows to repeat at top field in the Page Setup dialog to specify the heading row. This is different from including the row in the print area: the print area defines the cells to print, while print titles repeat selected headings on subsequent pages. Use both features when a report spans multiple pages.
Preview and print the intended worksheet
Before printing, use File > Print to inspect the preview and the print settings. Confirm the printer, paper size, orientation, scaling, and page count. The settings menu may offer choices such as printing the active sheet, the entire workbook, or a selection. If you want the saved print area to govern the output, normally print the active sheet rather than choosing a different scope such as the entire workbook.
A quick pre-print check can prevent wasted paper:
- Verify that the first and last intended rows and columns are visible in the preview.
- Check that no blank or unintended pages appear between report sections.
- Make sure text and totals are readable at the chosen scale.
- Confirm that the correct worksheet and printer are selected.
For a one-time print of a different range, you can select that range and choose the print-selection option in the print settings, where available, rather than changing the worksheet’s saved print area. This is handy when the normal report range should stay unchanged for future prints.
Common problems and how to fix them
- Excel prints extra cells. The selected print area may be larger than intended, or you may be printing the entire workbook. Set the intended range again and confirm the print scope in File > Print.
- The printout is split across too many pages. Check orientation, margins, paper size, and the Scale to Fit settings. Use Page Break Preview to see where Excel divides the pages.
- The print is tiny. Excel may be fitting both width and height to one page. Let the height span multiple pages, use landscape orientation, or reduce the number of columns included.
- A previous report still prints. A print area may remain saved from an earlier task. Choose Page Layout > Print Area > Clear Print Area, then set the new range if needed.
- A blank page appears. Look for an unexpectedly included range, a manual page break, or layout settings that push content onto another page. Review the preview and Page Break Preview before printing again.
- Headings show only on the first page. Set the heading rows using Page Layout > Print Titles; adding the headings to the print area alone does not repeat them automatically.
One frequent misconception is that defining a print area hides the rest of a worksheet. It does not. The range only controls printed output; other cells remain part of the sheet and can still be viewed, edited, or included later by changing the print settings.
Windows, Mac, and Excel for the web
The instructions above use Excel for Microsoft 365 on Windows. In Excel for Microsoft 365 on Mac, the Page Layout ribbon includes the print-area controls; use Page Layout > Print Area to set, add, or clear a range. The selection modifier differs: use Command rather than Ctrl when selecting separate ranges. For print preview, use File > Print; the Mac shortcut is Command+P, compared with Ctrl+P on Windows.
Excel for the web has a more limited printing workflow and may not provide the same full set of saved print-area controls as the desktop app. If you need to create or manage a persistent print area and tune page setup, open the workbook in the desktop version of Excel. For a one-time print from the web app, select the desired cells and check the available selection and print options in its print workflow; the exact options can depend on the interface available to your account.
Frequently Asked Questions
Does a print area save with the Excel file?
Yes. A print area is a worksheet setting and is retained when you save the workbook. Clear it or set a different range if you no longer want it to control printing.
Can I set more than one print area on a worksheet?
Yes. Select an additional range and choose Page Layout > Print Area > Add to Print Area. Separate areas may print as separate pages, so review the preview to confirm their order and layout.
How do I print the whole worksheet again?
Choose Page Layout > Print Area > Clear Print Area, then use File > Print and select the intended print scope. Clearing the area does not remove worksheet data.
Why does my print area still use several pages?
A print area defines the content, not the number of pages. Paper size, orientation, margins, and scaling determine how that content is paginated. Adjust those settings and inspect the print preview.
Can I print a range once without changing the saved print area?
Yes. Select the cells, open File > Print, and use the print-selection option if it appears in your version. This is useful for a temporary extract when you want to preserve the normal report setup.
Is print area the same as Print Titles?
No. The print area determines which cells are included. Print Titles repeats specified rows or columns on pages, which is especially helpful for multi-page tables.
Related
- AutoCAD Excel Data Links: Insert and Update Tables
- Excel Autofill and Flash Fill: How Each Feature Works
- ArcGIS for Excel Heat Maps: Setup, Uses, and Limits
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 Lock Specific Cells in Google Sheets for EditingTo lock specific cells in Google Sheets, select the cells, open Data > Protect sheets and ranges, add…
- Excel Freeze Pane Line: How to Remove ItTo get rid of a freeze pane line in Excel, select the affected worksheet, then choose View >…
- Excel Data Validation: Make Lists DynamicYes. In Excel for Microsoft 365, a data-validation drop-down can update when its source list grows, changes, or…
- Create a Name Signature in Outlook for Every EmailTo create a name signature in Outlook, open the signature settings for the Outlook version you use, add…
- How to Insert a First-Line Indent in Microsoft WordTo insert a first-line indent in Word, click in a paragraph or select several paragraphs, then open Home…
- How to Delete a Page in Microsoft Word: Blank or FilledTo delete a page in Microsoft Word, click anywhere on the page, press Ctrl+G on Windows (Option+Command+G on…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.