In Excel for Microsoft 365 on Windows, find the Print Area button on the Page Layout tab, in the Page Setup group. Select the cells you want to print, then choose Page Layout > Print Area > Set Print Area; use Clear Print Area in the same menu to remove it.
Where the Print Area button is in Excel
Open the worksheet you want to print and select the Page Layout tab on the ribbon. In the Page Setup group, open the Print Area drop-down. The menu normally contains Set Print Area and Clear Print Area. The first command turns the current selection into the worksheet’s designated print range; the second removes that designation.
The button may be harder to spot if the Excel window is narrow, the ribbon is simplified, or the group is collapsed. Maximize the window or expand the ribbon and look for Page Setup. You can also use Excel’s ribbon search box, often labeled Search or Tell me, and search for Set Print Area. Choose the matching command from the results.
On Excel for Mac, the corresponding controls are on the Page Layout tab in the Print Area menu, although ribbon layout can differ by version and window size. Excel for the web does not offer the same persistent Print Area command as desktop Excel. In the browser, select the cells you need and use the print options for the current print job, or open the workbook in the desktop app to save a print area in the workbook.
What a print area does
A print area tells Excel which part of a worksheet to include when that sheet is printed. It is useful when a worksheet contains both a polished report and supporting calculations, lookup tables, notes, or raw data that should remain in the file but not appear on paper. For example, if a monthly report occupies A1:F28 and a calculation table begins in H1, setting A1:F28 as the print area keeps the calculation table out of the report printout.
The setting applies to a worksheet, not to the entire workbook as one universal range. Different sheets can have different print areas, and a sheet can have no print area at all. Excel stores a defined print area with the workbook, so it generally remains in place when you save, close, and reopen the file. It does not delete, hide, or protect cells outside the selected range; those cells remain available for editing and calculation.
A print area also does not guarantee that the chosen cells will fit on one printed page. Page orientation, paper size, margins, scaling, and page breaks determine how the area is divided across pages. Think of the print area as the boundary of what is eligible to print, and the page setup options as controls for how that content is laid out.
How to set a print area step by step
Use this sequence when you want to print a specific, continuous block of cells:
- Open the correct worksheet and select the cell range. Drag across the cells, or click the first cell, hold Shift, and click the last cell.
- Choose Page Layout > Print Area > Set Print Area.
- Open File > Print to inspect the preview before printing. Check the page count and confirm that the intended rows and columns appear.
- If the preview is right, choose the printer and print settings, then print. If it is not, return to the worksheet and adjust the range or page setup.
For a practical example, suppose a sales summary occupies B2:G24, while notes and a chart source table appear farther down and to the right. Select B2:G24 before setting the area. Excel will use that rectangle as the print boundary, including blank cells inside it if any, but not cells beyond its edges. If a title sits in row 1, include row 1 in the selection when it should appear on the printout.
If you set the area without first selecting cells, Excel may use the current cell or selection in a way that does not match your intention. Check the range before choosing the command, and use Print Preview rather than assuming the worksheet’s on-screen appearance is an accurate page preview.
How to check and adjust the printed pages
Use File > Print to see how Excel divides the print area into pages. The preview is useful for spotting a last column that spills onto a nearly empty second page, a heading separated from its table, or text that becomes too small after scaling. You can move between preview pages and inspect the page count before sending the job to a printer.
If the content is too wide, try Landscape orientation or adjust the margins from the Page Layout tab. Under the Scale to Fit controls, you can change the width or height settings; setting width to one page is a common way to keep all columns together. Be cautious about forcing both width and height to one page: a long report can shrink until the text is difficult to read. Sometimes two readable pages are better than one cramped page.
For long tables, use Print Titles to repeat header rows or columns on each printed page. This is separate from the print area: the print area determines what can print, while print titles repeat designated labels across pages. Page breaks can also be adjusted from Page Layout > Breaks, or viewed on the sheet in Page Break Preview. Make changes one at a time and revisit File > Print, because scaling and page-break changes can alter the final pagination.
Printing separate blocks from one worksheet
You can define more than one print area on a worksheet when the content consists of separate blocks. For example, a dashboard might have a summary in A1:D12 and a small regional table in F1:I8, with irrelevant material between them. Select the first range, then hold Ctrl while selecting the second range on Windows; on Mac, use the selection modifier used by that version of Excel, commonly Command. Choose Set Print Area after making the nonadjacent selection.
Excel treats separate print areas as separate print sections and prints them on separate pages. It does not usually arrange two distant blocks side by side on one page just because they were selected together. Preview the result carefully: the order and page breaks may not match the visual arrangement you expected. If the blocks need to appear together as one designed page, it can be simpler to copy them to a dedicated report sheet and set one rectangular print area there.
When you set a new print area for a sheet that already has one, Excel replaces the existing print-area definition unless you deliberately add another range to the selection. If the result is unexpected, clear the area and define the complete intended selection again.
How to change or clear a print area
To replace the current area, select the new range and choose Page Layout > Print Area > Set Print Area. Excel updates the sheet’s print boundary to the new selection. This is often faster than clearing first, but clearing is helpful if the selection has become complicated or you are not sure which ranges are currently included.
To remove the print-area restriction, choose Page Layout > Print Area > Clear Print Area. Afterward, Excel can print the worksheet’s used content according to the print settings, rather than limiting output to the old designated range. A worksheet’s used content can include formatting or data far from the visible report, so clearing an area may produce more pages than expected. Always check the preview after clearing.
Clearing the area does not erase cells, formulas, formatting, or page setup settings such as orientation. It removes the print-area definition only. If the workbook has several sheets, make sure the intended sheet is active before using either command; a print area on one worksheet does not automatically clear areas on the others.
Common print-area problems and fixes
- Extra blank pages appear: Look for stray content or formatting far from the report, then check the preview and page breaks. A print area can prevent distant cells from printing, but clearing it may expose them again.
- The rightmost columns print on a separate page: Try Landscape orientation, narrower margins, or fit-to-page width. Avoid shrinking a long report in both directions unless the preview remains readable.
- Only part of the selected range prints: Confirm the active worksheet, reopen the Print Area menu, and inspect File > Print. Also check the print settings for options such as printing the selection or active sheet, which can affect the output.
- A newly added row is missing: A saved print area does not necessarily expand when you type beneath its boundary. Select the larger range and set it again, then verify the preview.
- The print area seems to return: The definition is saved with the workbook. If you reopen a saved copy, the old area may still be there; clear or replace it and save the workbook again.
One common misconception is that hiding rows or columns is the same as setting a print area. Hiding can change what is displayed or printed, but it does not establish a reliable boundary for the report. A print area is the clearer choice when you want a defined portion of a worksheet to be the print target.
Print area versus printing a selection
Print Area and Print Selection solve related but different needs. Set Print Area stores a boundary on the worksheet for later print jobs. The Print Selection option in the print workflow prints the cells selected for that job; it is useful for a one-time print and does not replace a saved print-area definition. In File > Print, examine the Settings options and select the appropriate scope, such as printing the active sheet or the selection, when those options are available.
Use a saved print area when the same report range will be printed repeatedly or when colleagues opening the workbook should see the intended output boundary. Use a one-time selection when you only need a quick extract and do not want to alter the worksheet’s saved print setup. In either case, preview the pages: selecting a range does not automatically make it fit neatly on paper.
Frequently Asked Questions
Where is the Print Area button in Excel?
In Excel for Microsoft 365 on Windows, go to Page Layout > Page Setup > Print Area. The drop-down includes Set Print Area and Clear Print Area. If the ribbon is compressed, expand the window or search for Set Print Area.
How do I set a print area in Excel?
Select the cells you want included, then choose Page Layout > Print Area > Set Print Area. Open File > Print afterward to check the page preview and make sure the range and page breaks look right.
How do I remove the print area in Excel?
Activate the worksheet and choose Page Layout > Print Area > Clear Print Area. The cells stay in the worksheet; Excel simply removes the saved boundary that limited printing.
Why is Excel printing blank pages or extra columns?
Check whether a print area is set, whether the relevant cells are inside it, and whether the print preview shows distant content or awkward page breaks. Also review print scope, orientation, scaling, and margins. A cleared area can allow more of the sheet’s used content to print.
Can I set a print area in Excel for the web?
Excel for the web does not provide the same saved print-area feature as the Windows desktop app. For a reusable print boundary, open the workbook in desktop Excel and set it on the Page Layout tab; for a one-time browser print, select the cells and review the available print settings.
Related
- Excel Power Query Date Format: Types, Changes, and Fixes
- Train Inventory Spreadsheet: What to Track and How
- Tool Inventory Spreadsheet: Setup, Tracking, and Tips
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Find and Replace: How It Works and When to Use ItYes. Excel for Microsoft 365 on Windows has a Find and Replace function: press Ctrl+H, or choose Home…
- Google Sheets Nested IF: Syntax and ExamplesIn Google Sheets, a nested IF formula places one IF function inside another so a cell can return…
- Conditional Formatting in Excel: Rules and ExamplesConditional formatting in Excel automatically changes how cells look when their values meet conditions you define. Select the…
- Excel Insert Blank Row Every Other Row: Methods That WorkTo insert a blank row between every pair of records in Excel, use a short VBA macro for…
- How to Keep Track of Expenses in ExcelTo keep track of expenses in Excel, create a table with one row per purchase, record the date,…
- Unmerge Shortcut in Excel: Windows Keys and Common FixesIn Excel for Microsoft 365 on Windows, select a merged cell and press Alt, H, M, U, one…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.