How to Name a Selected Range in Excel and Use It Easily

How-to basics · Updated November 18, 2026

To name a selected range in Excel, select the cells, click the Name Box to the left of the formula bar, type a valid name, and press Enter. The name then refers to those cells, making the range easier to identify, select, and use in formulas. The steps below are for Excel for Microsoft 365 on Windows; naming a range works similarly in Excel for Mac and Excel for the web, although some menus and name-management options vary.

What You’ll Need

  • An Excel workbook with the cells you want to name.
  • A clear name that follows Excel’s naming rules. For example, use QuarterSales rather than Quarter Sales.
  • Permission to edit the workbook. If the sheet is protected, you may need to unprotect it before changing its defined names or selections.

Step-by-Step

  1. Select the range. Click the first cell and drag to the last cell, or click the first cell, hold Shift, and click the last one. You can also select a range by clicking the Name Box, typing a cell reference such as B2:B5, and pressing Enter. Check the highlighted cells before naming: a heading included by mistake becomes part of the named range too.
  2. Find the Name Box. In Excel for Windows, it is the small box at the left end of the formula bar, above the worksheet grid. It usually displays the active cell address, such as B2, even when several cells are selected. Do not confuse it with the formula bar, which displays the active cell’s contents or formula.
  3. Enter a valid name. Click inside the Name Box, select or delete the displayed cell reference, and type the name you want. Names cannot contain spaces, so use an underscore or join the words, as in Monthly_Total or MonthlyTotal. Avoid names that look like cell addresses, such as Q1 or AB12.
  4. Confirm the name. Press Enter, not Tab. Excel saves the name when you press Enter. If you click another part of the sheet or press Esc before confirming, the entry may not be applied. The selected cells should remain highlighted after the name is accepted.
  5. Verify what the name refers to. Click the Name Box arrow to open its list of names, then choose your new name. Excel should select the range you intended. You can also click the Name Box, type the name, and press Enter to return to that range from elsewhere in the workbook.
  6. Use the Define Name option when you need more control. Select the cells, then choose Formulas > Define Name. In the New Name dialog, enter the name, check that Refers to shows the correct cell reference, and choose the scope. Click OK. This route is useful when you want to set a worksheet-specific scope or inspect the reference before saving.
  7. Choose a scope deliberately. A workbook-scoped name is available from any sheet in the workbook. A sheet-scoped name is available only on the sheet named in the Scope field. In Define Name, choose Workbook for use throughout the file, or select a worksheet for a name limited to that sheet. The Name Box is the quickest method for ordinary workbook-scoped names; use Define Name when scope matters.
  8. Try the name in a formula if that is your goal. For example, assume cells B2:B5 contain 120, 150, 90, and 140, and you named B2:B5 QuarterSales. Enter this formula in an empty cell:
    =SUM(QuarterSales)
    The result is 500. Excel treats the name as a reference to the cells, so you can use it in supported formulas instead of repeatedly entering the cell addresses.

In Excel for Mac, the Name Box is also beside the formula bar, and you can type a name there and press Return. The Define Name command is on the Formulas tab, though the dialog layout can differ slightly. In Excel for the web, you can generally create or select a name through the Name Box; advanced name-management controls may be more limited than in the desktop app. If a menu option is missing in the web version, open the workbook in desktop Excel to manage scope or edit more detailed name settings.

Common Mistakes

Including the heading by accident: If you select a column that includes a label such as “Sales,” the name refers to that heading as well as the data. Select only the cells you want formulas to use. If the header is useful as a label, keep it outside the range unless you specifically want it included.

Using spaces or an invalid first character: Excel names cannot contain spaces, and a name must begin with a letter, an underscore, or a backslash. Numbers can appear after the first character. Use West_Region rather than West Region. Periods and underscores are allowed in names, but avoid punctuation that Excel does not accept.

Choosing a name that resembles a cell reference: A name such as A10 conflicts with Excel’s cell-reference style and cannot be used as a defined name. Choose something descriptive that cannot be mistaken for an address, such as AreaA10Data. Also avoid very short names such as R or C, which can be confusing in reference styles.

Assuming every name is available everywhere: Two names can have the same text if they have different worksheet scopes, but this can make formulas hard to interpret. A worksheet-scoped name can take precedence on its own sheet over a workbook-scoped name with the same spelling. Prefer unique names unless you have a specific reason to use separate scopes.

Typing a name without committing it: The Name Box is an input field, so text appearing in it does not prove that Excel saved the name. Press Enter, then test the name by selecting it from the Name Box list. If the name is not listed, repeat the entry and confirm it.

Tips

Choose names that describe the data and its purpose, not just its position. AnnualRevenue is more useful than Range1, especially if rows or columns may be inserted later. A consistent naming style also helps: for example, use Input_ for user-entered ranges and Calc_ for calculation ranges. Keep names reasonably short so formulas remain readable.

Use the Name Box as a navigation tool, not only as a way to create names. Click its drop-down arrow to see available names, select one, and Excel jumps to the referenced cells. This can be handy in a large worksheet where scrolling to the range would take time. You can also type an existing name directly into the box to select it.

To review or change names, open Formulas > Name Manager. The Name Manager lists names, their scope, and what each one refers to. Select a name to edit or delete it. Be cautious when editing a name used by formulas: changing its reference changes what those formulas calculate, and deleting it can cause formulas that rely on it to return a name error.

Consider whether your data will grow. A name created for a fixed range such as B2:B20 generally refers to those cells, even if you later add data below them. If new rows must be included automatically, consider converting the data to an Excel table with Insert > Table and using the table’s structured references. That approach is often easier to maintain for expanding lists than repeatedly adjusting a fixed named range.

Before sharing a workbook, check that the names make sense to someone else who opens it. Remove obsolete names and use clear wording. If a name is only meaningful on one sheet, a worksheet scope can help keep it local; if formulas on different sheets need it, use workbook scope.

Troubleshooting

The name is rejected: Check for spaces, a leading number, or a spelling that looks like a cell reference. Remove unsupported punctuation and try a descriptive name that starts with a letter or underscore. If Excel says the name already exists, open Name Manager to see whether it is already defined, perhaps with a different scope.

The name appears in the Name Box but selects the wrong cells: Open Formulas > Name Manager, select the name, and inspect the Refers to field. Correct the reference if it points to the wrong sheet or range. Check whether you created a sheet-scoped name with the same spelling as a workbook-scoped name; selecting or using it from that sheet may resolve to the local name.

A formula using the name returns an error: Confirm the name is spelled exactly as defined and that the defined reference still points to valid cells. A deleted or renamed defined name can make formulas show #NAME?. If the formula uses a name scoped to another worksheet, use a workbook-scoped name or adjust the scope and formula setup so the reference is available where needed.

You cannot edit or select the cells: Check whether the worksheet is protected or the workbook is in a restricted editing state. If you are permitted to edit it, use Review > Unprotect Sheet and enter a password if prompted. If you do not know the password, ask the workbook owner rather than trying to bypass protection.

You cannot find a command in Excel for the web: The browser version may not offer the same Name Manager controls as desktop Excel. Use the Name Box for basic selection or creation if available, or choose Open in Desktop App and use Formulas > Name Manager or Formulas > Define Name for fuller editing options.

Frequently Asked Questions

Can I name a single cell as well as a range?
Yes. Select one cell and use the Name Box or Define Name. A single-cell name can make a value easier to recognize in a formula, such as a tax-rate input or report date.

Can I rename a range after creating it?
Yes. Open Formulas > Name Manager, select the name, choose Edit, enter the replacement name, and confirm. Excel updates formulas that refer to the defined name in many normal rename cases, but review important formulas afterward.

Can two ranges have the same name?
Not within the same scope. Excel can have a workbook-scoped name and a worksheet-scoped name with identical text, but that setup can cause ambiguity. Unique names are usually easier to maintain.

Does a named range expand when I add rows?
Not necessarily. A fixed name usually refers to the cell addresses originally assigned to it. Check its reference in Name Manager after adding data. For lists that grow, an Excel table with structured references may be more convenient.

How do I remove a range name?
Choose Formulas > Name Manager, select the name, and click Delete. Deleting the name does not delete the cells, but formulas that depend on the name may stop working, so check workbook usage first.

Can I use a named range in a formula on another sheet?
Yes, if it has workbook scope. A worksheet-scoped name is limited to its sheet, so use a workbook-scoped name when the same range needs to be referenced throughout the workbook.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.