To set a print area 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; Excel will print the selected range instead of the whole worksheet.
What a print area does
A print area is a range of cells Excel treats as the printable content for a particular worksheet. It is useful when a sheet contains notes, calculations, lookup tables, or other material that should stay in the workbook but should not appear on the printed pages. For example, a sales worksheet might include a customer-facing summary in A1:F25 and internal calculations in H1:K40. Setting A1:F25 as the print area keeps the calculations out of the printout without deleting or hiding them.
The setting belongs to an individual worksheet, not the entire workbook. You can set one range on a summary sheet and a different range on a detail sheet. A print area also does not change what is visible on screen, remove data, or prevent someone from editing cells. It only guides printing and print preview. Excel stores the print-area definition with the workbook, so it can remain in place when you save and reopen the file.
Keep print area separate from page layout settings in your mind. The print area answers “which cells?” Orientation, paper size, margins, scaling, and page breaks answer “how will those cells fit on paper?” A correctly selected range can still span several pages if it is too large for the chosen paper and scaling.
Set a print area step by step
- Open the worksheet you want to print. If the workbook has several sheets, click the correct sheet tab first.
- Select the range of cells. Drag across the cells, or click the first cell and Shift-click the last cell. You can also enter a range such as
A1:F25in the Name Box to the left of the formula bar and press Enter. - Open the Page Layout tab on the ribbon.
- Choose Print Area > Set Print Area.
- Choose File > Print to inspect the preview before printing or saving a PDF.
For a concrete example, suppose a monthly report occupies B2:G28. Select B2:G28 and set it as the print area. In the preview, the page should contain that report and not unrelated cells elsewhere on the sheet. If Excel shows more pages than expected, do not assume the range selection failed: the selected report may simply be wider or taller than one printed page. Page layout and scaling controls can address that separately.
On Excel for Mac, the same general approach applies: select the cells, use the Page Layout tab, and choose the print-area command. Ribbon placement can vary slightly with the Excel version and window width. Excel for the web does not provide the same persistent desktop print-area workflow; use its print options for a one-time selection where available, or open the workbook in the desktop app to save a print area with the sheet.
Print separate blocks or add to an existing area
Sometimes the material you need is in two blocks that are not next to each other. For example, a report may use A1:D12 for its summary and A20:D30 for supporting details, with notes in between that should not print. Select the first block, then hold Ctrl while selecting the second block on Windows. On a Mac, use Command while selecting the additional cells. Then choose Page Layout > Print Area > Set Print Area.
Excel treats noncontiguous print areas as separate printable areas. They may print on separate pages, even if each block could otherwise fit into the unused space on a page. Preview the result carefully; if you need the blocks together in a specific layout, it may be clearer to copy them to a dedicated print sheet or arrange them as one continuous range.
If a print area is already set and you want to keep it while including more cells, select the additional cells and choose Page Layout > Print Area > Add to Print Area. This is different from choosing Set Print Area again, which defines the area from the current selection rather than deliberately adding to the existing one. After adding cells, revisit Print Preview because the additional area may produce another page or change the page sequence.
Check page layout and print preview
A print area does not guarantee a one-page printout. Excel divides the area according to the paper size, margins, orientation, scaling, and page breaks. Use File > Print to see the page count and preview. Select the printer or PDF destination you intend to use if the preview looks different from the final output; available paper sizes and printer margins can affect the layout.
Useful settings include:
- Orientation: Choose portrait for a tall report or landscape for a wide table. Find this under Page Layout > Orientation.
- Paper size: Choose the size supported by the intended printer, such as Letter or A4, under Page Layout > Size.
- Margins: Use Page Layout > Margins to adjust the space around the printed content. Very narrow margins may not be printable on every printer.
- Scaling: Use the Scale to Fit controls on the Page Layout tab to fit a wide report to one page wide, or choose scaling options in the Print screen. Fitting both width and height to one page can make text too small to read.
For a wide table, fitting it to one page wide while allowing its height to span multiple pages is often more readable than squeezing the entire report onto one sheet. In the print settings, options such as Fit All Columns on One Page can help, but the exact wording depends on the displayed scaling menu. Always judge the text size in the preview and, for an important report, print or export a test copy.
To see where Excel divides pages on the worksheet, choose View > Page Break Preview. This view displays page boundaries and lets you inspect how the print area is split. Page breaks can be adjusted, but moving them does not redefine which cells belong to the print area. Return to View > Normal when you are done reviewing the sheet.
Change or clear a print area
To replace the current print area with a different range, select the new cells and choose Page Layout > Print Area > Set Print Area. If the existing area is no longer needed, choose Page Layout > Print Area > Clear Print Area. Clearing it removes the saved restriction for that worksheet; it does not clear cell contents, formatting, or page layout settings. With no print area defined, Excel generally treats the worksheet’s used content as printable, subject to the print settings.
If you only need to print a different selection once and do not want to alter the saved setup, you can select the cells and use the print screen’s selection option if it is offered by your Excel version. Otherwise, set the area temporarily and clear or restore it afterward. Before changing a shared workbook, check whether other people rely on its existing print setup, since changing the area affects later printouts from that sheet.
Each worksheet can have its own area, so clearing one sheet’s print area does not clear the others. To inspect or manage the workbook’s defined names, open Formulas > Name Manager. Excel represents a worksheet print area through a defined name, typically associated with that sheet. For ordinary changes, however, the Print Area menu is the simplest and least error-prone way to update it.
Common print-area problems and fixes
- The whole sheet still appears in preview: Confirm that you set the area on the intended worksheet, then check Page Layout > Print Area or clear and set the range again. Also verify that you are previewing the same sheet rather than the entire workbook.
- Blank pages appear: Check whether the print area includes empty rows or columns, whether a noncontiguous area creates another page, and whether manual page breaks or scaling are affecting the output. Page Break Preview can help locate the extra page.
- The report is too small: Look for a setting that fits both the width and height to one page. Switch to fitting one page wide, or allow more pages, so the printed text remains legible.
- Some columns or rows are missing: Confirm that the selected range includes them. Also check whether those rows or columns are hidden; a print area does not automatically make hidden content visible.
- Headers repeat but are outside the range: Print titles are a separate setting from the print area. Use Page Layout > Print Titles to specify rows or columns to repeat on each printed page.
- The saved layout changes on another computer: Check the paper size, printer selection, and margins there. Different printer drivers can alter page breaks even when the print area is unchanged.
A frequent misconception is that setting a print area hides or protects the rest of the worksheet. It does neither. If you need to keep information out of a shared copy, create an appropriate copy or remove the information; a print area is not a privacy or security feature.
Save, print, and share the workbook
Save the workbook after setting the print area if you want the definition to travel with it. The print area is stored per sheet in the workbook, while choices such as the selected printer can depend on the computer and print environment. Use File > Save or the usual save shortcut, then reopen or preview the file if the print layout is important.
To create a PDF, use File > Print and select a PDF printer or the PDF option available in your Excel environment. Review the page preview first, especially when the report uses multiple print areas or unusual scaling. A PDF captures the pages as laid out at export time, so it is a practical way to share a fixed print-ready version; the Excel workbook remains the editable source.
When you share the workbook, tell recipients which worksheet to print if it contains several tabs. If someone prints the entire workbook, Excel may include content from other sheets, each with its own print settings. For a polished recurring report, consider using a clearly named report sheet, setting its print area and page layout, and leaving source data on separate sheets.
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 confirm which pages Excel will produce.
How do I print only selected cells without changing the saved print area?
Select the cells and look for a selection-only option in the Print screen. Its availability and wording can vary by Excel version. If you use Set Print Area instead, remember to clear or restore the area afterward if you do not want the change to remain.
Can I set more than one print area on a worksheet?
Yes. Select separate blocks using Ctrl-click on Windows or Command-click on Mac, then set the print area. Excel can print the separate blocks as separate areas, so check the preview for page order and page count.
Why does my print area print on several pages?
The selected cells may be larger than the paper can hold at the chosen orientation, margins, and scaling. Use Print Preview, change orientation or margins, or fit the content to one page wide. Avoid forcing both dimensions onto one page if the text becomes too small.
How do I remove a print area?
On the relevant worksheet, choose Page Layout > Print Area > Clear Print Area. This removes the print restriction but leaves the worksheet data and other page setup choices intact.
Does a print area apply to every sheet in the workbook?
No. It is set separately for each worksheet. Set, change, or clear the area on each sheet whose printed output you want to control.
Related
- Coursera Excel Data Analysis: Courses, Skills, and Value
- Cluster Analysis in Excel: Methods and Step-by-Step Guide
- Basic Excel for Data Analysis: A Practical Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel: How to Insert an Image in a Header on Every PageIn Excel for Microsoft 365 on Windows, open Page Layout > click the small launcher in the Page…
- How to Present PowerPoint and See Your Speaker NotesTo present a PowerPoint while keeping your notes visible, connect a second display, set Windows to extend the…
- Excel Dropdown Like Google Sheets? Create One EasilyYes. Excel can make a dropdown much like Google Sheets: select the cells, go to Data > Data…
- Excel Print Shortcut: How to Print a WorksheetIn Excel for Microsoft 365 on Windows, press Ctrl+P to open the Print screen, review the preview and…
- Excel Power Query Find and Replace: Steps and TipsTo find and replace data in Excel Power Query, open the query, select the column, then choose Transform…
- How to Add a Header in Excel for All PagesTo add a header to every printed page in an Excel worksheet, select the sheet, choose Insert >…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.