To name a print range in Excel, select the cells, create a workbook-level name with Formulas > Define Name, then select that name and choose Page Layout > Print Area > Set Print Area. Naming a range makes it easier to find again; setting it as the print area is the separate step that tells Excel what to print. These instructions are for Excel for Microsoft 365 on Windows.
What You’ll Need
- An Excel workbook open in the desktop version of Excel. Excel for the web does not provide the same controls for defining a worksheet print area, so use the desktop app to set it.
- A worksheet with the cells you want to print, and a short, unique name in mind, such as PrintRange or InvoicePage.
- Optional: a printer or PDF destination if you want to check the final output. You can preview the pages without printing on paper.
Step-by-Step
- Select the cells that should be named. Open the correct worksheet and select the full rectangular block you want to print. For example, click the first cell, hold Shift, and click the last cell, or drag across the range. Include headings and totals if they need to appear on the printed page. Check the selection before continuing: blank rows or columns inside the rectangle will be part of the named range too. If your print layout needs separate, nonadjacent blocks, see the note in Tips rather than assuming one rectangular selection will handle them the way you expect.
- Open the name definition dialog. On the ribbon, choose Formulas > Define Name. Excel opens the New Name dialog. You can also use the Name Box, the small box to the left of the formula bar, for a quick name, but the dialog is useful because it lets you choose the name’s scope and confirm the cell reference.
- Enter a clear name. In the Name field, type a descriptive label such as PrintRange, MonthlyReport, or InvoicePage. Names cannot contain spaces, so use an underscore or capitalize the start of each word if that makes the label easier to read. A name must begin with a letter, an underscore, or a backslash; after that, it can include letters, numbers, periods, and underscores. Do not use a name that Excel could interpret as a cell reference. Avoid names such as A1 or R1C1, and do not use Print_Area for your ordinary named range because Excel uses that special name for a worksheet’s print area.
- Set the scope and confirm the reference. In Scope, choose Workbook if you want to use the name from any worksheet. Choose the current sheet only if the name should be available on that sheet alone and you understand that another sheet can have a separate name with the same spelling. In Refers to, check that Excel shows the intended cells on the correct sheet, such as =$A$1:$F$32. If it does not, click in the box and correct the reference, or cancel and select the right cells again. Click OK to create the name.
- Select the named range. Click the Name Box, type the name you just created, and press Enter. Excel should select the corresponding cells. This is a useful check before setting the print area: if the wrong cells highlight, return to Formulas > Name Manager and edit the name before proceeding. You can also select a workbook-level name from the Name Box list, then press Enter.
- Set those cells as the print area. With the named cells selected, choose Page Layout > Print Area > Set Print Area. Excel records the selected cells as the worksheet’s print area. The name you created is a convenient way to select the cells; it does not automatically make every named range printable, so do not skip this command.
- Preview and adjust the printout. Choose File > Print to open Print Preview. Confirm the preview shows the intended cells, page count, and page breaks. If content is too small or spills onto extra pages, return to the sheet and adjust settings such as orientation, margins, paper size, or scaling. Those settings change how the print area fits; they do not change the name or the cells it refers to. If the preview is correct, print it or choose a PDF destination.
The steps are similar in Excel for Mac: define the name using the Formulas tab, select it from the Name Box, and use Page Layout > Print Area > Set Print Area. Ribbon placement can vary slightly by Excel build. If you are in Excel for the web, open the workbook in the desktop app for the full print-area workflow.
Common Mistakes
Creating a name but never setting a print area. A defined name is a label for cells; it does not instruct Excel to print those cells. After selecting the name, use Page Layout > Print Area > Set Print Area, then check File > Print.
Including the wrong cells. A selection that misses the title row or totals can produce a technically correct but incomplete printout. Conversely, including a distant cell can make Excel treat the whole space between it and the main block as part of the print area. Verify the selected outline and the Refers to entry before you confirm.
Choosing the wrong scope. A worksheet-level name is only available on the sheet where it was created. If you expect to use the name from different sheets, set its scope to Workbook. If a name already exists with sheet scope, the Name Box may behave differently from what you expect; inspect the Scope column in Formulas > Name Manager.
Expecting the print area to follow later changes to the name. When you select a named range and set the print area, Excel saves a print-area reference for that worksheet. It may not remain linked to the ordinary name you created. If you change the named range to cover different cells, set the print area again and preview it. Also, adding rows below a range does not guarantee that the existing print area expands.
Using spaces or reserved-looking labels. Excel names do not accept spaces, and names that resemble cell addresses can be rejected or confused with references. Use a readable form such as Sales_Print or SalesPrint. Keep the worksheet’s special Print_Area name separate from your own reusable label.
Tips
- Use a name that explains the purpose. A label such as Q4Summary is easier to recognize later than Range2. If the workbook has several sheets, use workbook scope only where it is useful; a sheet-specific name can be sensible when each worksheet has its own distinct print block.
- Review names in Name Manager. Choose Formulas > Name Manager to see the name, scope, and Refers to reference. Use Edit to correct a reference or name, and Delete only when you are sure the name is no longer used. Deleting a defined name does not remove the cells, but formulas or other workbook features that rely on it may stop working.
- Use the print-area menu deliberately. Set Print Area is useful when you want to replace the current print area with the newly selected cells. If you intend to keep an existing area and include another block, use Page Layout > Print Area > Add to Print Area. Multiple print areas can produce separate printed areas or pages, so check the preview rather than assuming Excel will join them into one continuous block.
- Separate naming from page layout. A good range name helps you select the cells again, but it does not set page orientation, margins, scaling, or repeated heading rows. Configure those separately on the Page Layout tab. For instance, a wide report may need Landscape orientation, while a long list may need print titles so column headings repeat on later pages.
- Keep a simple record of the intended range. For a report that changes each month, note which rows and columns belong in the printout. After adding data, select the updated range, edit the ordinary name if needed in Name Manager, set the print area again, and check the page count. This avoids relying on an older print boundary without noticing.
Troubleshooting
The name is not accepted. Remove spaces and punctuation that is not allowed, begin with a letter or underscore, and check that the label is not a cell reference. Try a distinctive name such as ClientSummary_Print. If Excel says the name already exists, open Formulas > Name Manager and check whether it is workbook-scoped or sheet-scoped before reusing or changing it.
Typing the name in the Name Box selects the wrong cells. Open Formulas > Name Manager and inspect Refers to and Scope. Edit the reference if it points to the wrong sheet or cells. A sheet-level name with the same spelling as a workbook-level name can make the result confusing, so use a unique name or remove an obsolete duplicate only after checking what depends on it.
The preview is blank, incomplete, or includes extra pages. First return to the worksheet and confirm the selected cells and the active sheet. Use Page Layout > Print Area > Clear Print Area to remove an incorrect boundary, reselect the correct named range, and choose Set Print Area again. Then open File > Print. If all cells appear but the page count is excessive, inspect page breaks, orientation, margins, paper size, and scaling; the issue may be layout rather than the defined name.
New rows are missing from the printout. The saved print area may still end at the old last row. Select the expanded range and apply Set Print Area again. If the named range also needs to cover the new rows, update its Refers to entry in Name Manager. Recheck both the name and the print preview, because updating one does not necessarily update the other.
You cannot find Print Area in Excel for the web. Open the workbook in the desktop version of Excel. The web app’s print options are not a full substitute for creating and managing a worksheet print area with the Page Layout ribbon controls.
Frequently Asked Questions
Does naming a range automatically set it as the print area?
No. A normal defined name only labels a cell reference. Select that name and then choose Page Layout > Print Area > Set Print Area to tell Excel what to print.
Can I use spaces in a print-range name?
No. Excel defined names cannot contain spaces. Use a label such as Annual_Report or AnnualReport instead. Avoid names that look like cell addresses.
Can the print range name be used on every worksheet?
Yes, if its scope is Workbook. A name created with a particular worksheet as its scope is available only on that sheet. Scope affects the name’s availability, not which cells Excel prints by itself.
Will my print area grow when I add rows?
Not necessarily. An existing print area usually retains its saved cell boundaries. Extend the named range if needed, set the print area again, and inspect Print Preview after adding data.
How do I change or remove a print area?
To replace it, select the new cells and choose Page Layout > Print Area > Set Print Area. To remove it, choose Page Layout > Print Area > Clear Print Area. This does not delete your ordinary named range; manage that separately in Formulas > Name Manager.
Can I print the same named range from several worksheets?
You can create a workbook-level name for a range on one sheet, but a single cell reference does not automatically mean the matching range on every sheet. Set and check the print area on each worksheet that needs a printout. For different sheet layouts, use clear sheet-specific names or separate names that point to each sheet.
Related
- Data Validation in Excel: Rules, Lists, and Setup Tips
- Excel Extract Text From the End of a String in 365
- Excel Power Query: Extract Text from a String
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 Add a Running Header in Microsoft Word 2019To add a running header in Word 2019, choose Insert > Header, select a layout or Edit Header,…
- Hide Columns in Excel on SharePoint Without Deleting ThemTo hide columns in an Excel workbook stored on SharePoint, open the workbook in Excel for the web…
- 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 File Corrupted: Safe Online Repair Options and LimitsYes, you can try to fix a corrupted Excel file online by uploading it to a spreadsheet-repair service,…
- Excel Find and Replace: Search for a Question MarkTo find a literal question mark in Excel, open Find or Replace and enter ~? in the Find…
- Google Sheets GOOGLEFINANCE Formulas: Examples and TipsIn Google Sheets, use =GOOGLEFINANCE("NASDAQ:GOOG","price") to fetch the latest available price for Alphabet’s stock, or replace the ticker…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.