To designate 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 before printing. A print area tells Excel which part of a worksheet to include; it does not change or delete the data outside that range.
What You’ll Need
- An Excel workbook opened in the desktop version of Microsoft Excel. The steps below are for Microsoft 365 on Windows; the main ribbon commands are similar in Excel for Mac.
- A worksheet with the cells you intend to print. Decide whether you need one continuous block or separate ranges before setting the area.
- Optional: access to a printer, or simply use Print Preview to inspect the pages without printing.
Step-by-Step
- Open the worksheet and identify the intended output. Click the sheet tab that contains the content. Decide exactly which rows and columns belong on the printed page, including headings, totals, notes, and any labels readers need to understand the information. A print area applies to the active worksheet, so setting it while a different sheet is selected will affect the wrong sheet. If the worksheet contains several unrelated tables, decide whether to print one table at a time or include separate blocks.
- Select the cells you want Excel to print. Click the top-left cell of the range, then drag to its bottom-right cell. For a large range, click the first cell, hold Shift, and click the last cell. You can also type a range such as A1:G28 into the Name Box, located to the left of the formula bar, and press Enter. Confirm the highlighted selection includes the full width and height you want, but excludes unrelated data and empty columns.
- Set the print area from the ribbon. With the cells still selected, open the Page Layout tab. Select Print Area in the Page Setup group, then choose Set Print Area. Excel records the selection as the print area for that worksheet. The ribbon may look slightly different depending on window size; maximize Excel or look in the Page Setup group if the command is not immediately visible.
- Check that Excel saved the right range. Click a cell outside the selected area, then return to Page Layout > Print Area and confirm that the command to clear the area is available. You can also open File > Print and inspect the preview. The preview should show the intended content, not every used cell on the worksheet. If the range is wrong, return to the sheet, select the correct cells, and set the print area again.
- Review page layout and scaling. In the print preview, look for content that spills onto an extra page, gets cut off, or becomes too small to read. If the range is too wide, consider Page Layout > Orientation > Landscape. To scale content, use the Scale to Fit settings on the Page Layout tab, or choose a suitable scaling option in the print settings. Forcing a large table onto one page can make text unreadable, so check the preview after changing scaling.
- Adjust page breaks or margins if needed. Use Page Layout > Margins to choose a preset or open custom margins. To see and adjust how content is divided across pages, choose View > Page Break Preview. Drag a page-break line only when the resulting page widths and content remain readable. Return to View > Normal when finished; this changes the on-screen view, not the print area.
- Print or save the workbook. In the print screen, confirm the correct printer and that the setting is for printing the active sheet or sheets, rather than only the current selection. The print area should constrain the worksheet output. If the preview is right, choose Print. Save the workbook with Ctrl+S so the worksheet’s print-area setting is retained. On a Mac, use Command+S to save and Command+P to open printing.
On Excel for Mac, select the range and use the Page Layout tab’s Print Area menu to set or clear it; ribbon placement can vary by version. Excel for the web may not provide the same persistent print-area controls as the desktop app. If you cannot find Set Print Area, open the workbook in the desktop app, or use the web print options to print a selection if that option is available.
Common Mistakes
- Setting the area on the wrong sheet: Print areas belong to individual worksheets. Select the correct sheet tab before setting one, especially if the workbook has similarly named tabs.
- Selecting only the visible part of a table: A missed title row, total column, or final row will not be included. Check the highlighted range before using Set Print Area, then verify the print preview.
- Assuming the print area hides cells: It controls what prints; it does not hide, lock, or remove anything from the worksheet. The full data remains visible and editable in Excel.
- Expecting a new range to add to the old one: Choosing Set Print Area again replaces the existing print area on that sheet. To include another separate block without removing the current one, select the additional cells and choose Page Layout > Print Area > Add to Print Area.
- Using scaling to fix every layout issue: Shrinking a wide worksheet to one page may technically fit it, but can produce tiny text. Consider landscape orientation, narrower margins, or more than one page before reducing the scale too far.
- Confusing a print area with a print selection: A selection is a one-time print choice; a saved print area is a worksheet setting that is used for later printing. Check the print screen’s selected print option if the output does not match the saved area.
Tips
- Include a useful heading row. A printed table is easier to interpret when column names appear above the data. Include the heading in the print area; if a long table spans several pages, you can also repeat heading rows using Page Layout > Print Titles.
- Use more than one print area only when it helps. To print separate, nonadjacent blocks, select the first block, set the print area, then select the next block and use Add to Print Area. Excel treats separate print areas as separate print ranges, generally placing each on its own page. Preview the result because page order and layout may not be what you expect.
- Keep the selection compact. Avoid including entire blank columns or rows just to leave extra space. Empty cells inside a selected rectangle may still affect its shape and page layout, even though they contain no visible data.
- Use Print Preview as the final check. Worksheet view and print output are different. Preview reveals page breaks, scaling, margins, and printer-paper effects that may not be obvious on the grid.
- Remember that print setup is sheet-specific. If several worksheets need print areas, configure and preview each sheet. Do not assume that setting an area on one tab automatically applies to the other tabs.
Troubleshooting
- Excel prints the whole worksheet instead of the selected area: Confirm that you used Set Print Area rather than only selecting cells. Open File > Print and check the print setting. If it is set to print the entire workbook or only the current selection, choose the option that prints the active sheet, then inspect the preview again.
- The printout is missing rows or columns: Return to the worksheet and check the saved boundary. Set the print area again with the complete range, including any headings or totals. Also check for hidden rows or columns; hidden content may not appear in the output even when it lies within the print area.
- There are unexpected blank pages: The print area may include blank rows or columns, or page breaks and scaling may be extending the output. Re-select only the cells you need and set the area again. Then inspect View > Page Break Preview and the print preview. If content is just beyond a page edge, adjust orientation, margins, or scaling.
- The table is split awkwardly: Open Page Break Preview to see where the page divides. Change the orientation, margins, or page scaling, or adjust the page break where practical. For a wide table, landscape orientation may help; for a very tall table, multiple pages with repeated heading rows are usually easier to read than forcing everything onto one page.
- The Print Area command is unavailable or missing: Make sure a worksheet is active and that you are using the desktop Excel ribbon. If the workbook is in a restricted state or opened in a browser, try opening it in the desktop app. In Excel for the web, use the available print-selection controls if you need a one-time print and cannot set a persistent area.
- The setting seems to disappear: Print areas are saved with the workbook. Save the file after setting the area, and make sure you reopen the same saved workbook rather than a separate copy. If you need to remove and rebuild the setting, choose Page Layout > Print Area > Clear Print Area, select the intended cells, and set it again.
Frequently Asked Questions
Does a print area delete or hide the other cells?
No. It only limits what Excel includes when printing that worksheet. The remaining cells stay in the workbook and remain available for editing and viewing.
Can I set more than one print area on a worksheet?
Yes. Set the first range, select another range, and choose Page Layout > Print Area > Add to Print Area. Separate areas are handled as separate print ranges, so check the preview to see how they fall across pages.
How do I remove a print area?
Open the worksheet, then choose Page Layout > Print Area > Clear Print Area. This removes the saved print-area boundary for that sheet; it does not clear the worksheet’s cell contents.
Will the print area apply to every worksheet in the workbook?
No. Each worksheet has its own print settings. Set and check the area separately on every sheet you plan to print.
Can I print only the selected cells without saving a print area?
Yes. Select the cells, open File > Print, and choose the option to print the selection if it is available. That is useful for a one-time print; use Set Print Area when you want a persistent setting for the worksheet.
Why does my print area still produce several pages?
A print area defines which cells are eligible to print, not how many pages they occupy. Paper size, orientation, margins, scaling, and page breaks determine the page count. Review the preview and adjust those settings to get a readable layout.
Related
- Excel Insert Row Greyed Out? Causes and Fixes
- Excel Group Rows Shortcut: The Key and How It Works
- How to Compare Two Excel Sheets for Matches in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Can You Insert a Horizontal Line in Word?Yes. In Microsoft Word for Microsoft 365 on Windows, you can insert a horizontal line from Home >…
- Excel Bar Plot: How to Create and Format OneIn Excel for Microsoft 365 on Windows, select your category and value columns, then choose Insert > Insert…
- Microsoft Excel .xlsx Files: Workbooks and WorksheetsA Microsoft Excel .xlsx file is an Excel workbook: a file that can contain one or more worksheets,…
- Excel Random Numbers Between a Range and ValueIn Excel for Microsoft 365, use =RANDBETWEEN(1,100) to generate a random whole number from 1 through 100, including…
- New Outlook Out of Office Reply: Setup and SchedulingTo set an out of office reply in New Outlook for Windows, open Settings > Accounts > Automatic…
- Create a New Signature in Outlook 365, Step by StepTo create a new signature in Outlook 365, open the signature settings for your version of Outlook, choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.