Where to Find Define Name in Excel and Manage Names

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, find Define Name on the Formulas tab, in the Defined Names group. Select a cell or range first, then choose Formulas > Defined Names > Define Name to give it a recognizable name; use Name Manager in the same group to review or change names already in the workbook.

What Define Name Does

Define Name creates a label for a cell, a range of cells, a constant, or a formula. Instead of referring to a range by its column and row coordinates, such as B2:B4, you can refer to it by a name such as Sales. A defined name is stored in the workbook and can make formulas easier to read and maintain.

For example, a total that uses a named range can be more self-explanatory than one that contains only cell addresses. With values 120, 150, and 90 in B2:B4 on Sheet1, and the workbook name Sales referring to B2:B4, the formula below returns 360.

With the values in Sheet1!B2:B4 and the name Sales referring to those three cells, enter this formula in any suitable result cell:

=SUM(Sales)

The name does not change the data or move the cells. It is a useful label for a reference that you may need in formulas, charts, validation rules, or other workbook features. Names can also refer to a single cell, which is helpful for frequently used inputs such as a tax rate or report date.

How to Define a Name on Windows

Use the ribbon when you want to create a name and choose its scope and reference deliberately. These steps apply to Excel for Microsoft 365 on Windows:

  1. Select the cell or range you want to name. To name a multi-cell range, drag across it or select it using the Name Box.
  2. Open the Formulas tab on the ribbon.
  3. In the Defined Names group, select Define Name. Excel opens the New Name dialog box.
  4. Enter a name in the Name field. Choose the intended Scope, such as Workbook or a particular worksheet.
  5. Check the Refers to field to confirm that it points to the right cell or range, then select OK.

When a range is selected before opening the dialog, Excel usually fills in its reference automatically. Always verify the sheet name and cell addresses, especially if the workbook has multiple worksheets or the selection was made by clicking a chart or another object. A name can also refer to a constant or a formula rather than a cell range; in that case, enter the appropriate value or expression in Refers to.

Other Ways to Create a Name

Define Name is not the only route. For a quick, straightforward range name, select the cells, click the Name Box to the left of the formula bar, type a valid name, and press Enter. The Name Box normally displays the active cell address, such as B2. Typing a name there creates a workbook-scoped name for the selected cell or range. This is fast, but the method does not offer the same clear opportunity to set worksheet scope or inspect other name settings as the New Name dialog does.

If a range already has labels in its top row or left column, Excel can generate names from those labels. Select the labeled data, then choose Formulas > Defined Names > Create from Selection. In the dialog, specify whether the labels are in the top row, left column, bottom row, or right column. Excel uses the selected labels to make names for the corresponding ranges. Check the resulting names afterward: spaces and some punctuation in labels may be adjusted to make valid names, and duplicate labels may require attention.

These methods serve different needs. Use Define Name when you want to choose scope and check the reference; use the Name Box for a quick single name; use Create from Selection when a well-labeled table or block of data contains several ranges you want to name at once.

Find, Edit, and Delete Names

Choose Formulas > Defined Names > Name Manager to see the names in a workbook. The Name Manager lists each name, its value or reference, its scope, and any comment. Select a name to inspect it. Use Edit to change its name, reference, or comment, and Delete to remove a name you no longer need. Take care before deleting: formulas that use that name may stop working or display a reference error.

You can also use the Name Box’s drop-down list to navigate to a defined name. Choose an entry to select the cell or range it refers to. This is handy in a large worksheet, but it is not a substitute for Name Manager when you need to inspect scope, edit a definition, or find a name that refers to a constant rather than a visible range.

On Windows, Ctrl+F3 opens Name Manager. The ribbon route remains useful if you do not remember the shortcut or are using a different keyboard. In Excel for Mac, look for Define Name and Name Manager on the Formulas tab; ribbon layout and keyboard shortcuts can differ by Mac version and keyboard settings. In Excel for the web, named ranges are available through the Formulas tab and Name Manager in supported accounts, though the available commands and dialog layout may differ from desktop Excel.

Rules for Naming Ranges

Excel names have rules that prevent confusion with cell references and formula syntax. A name can contain letters, numbers, periods, and underscores, but it cannot contain spaces. It must begin with a letter, an underscore, or a backslash, and it cannot be written in a way Excel interprets as a cell reference. For example, A1 is not a suitable name because it is already a cell address. Names can be up to 255 characters long.

  • Use a clear, compact label such as MonthlySales or Tax_Rate rather than a vague name such as Data.
  • Use underscores or capitalization to make multiword names readable, since spaces are not allowed.
  • Remember that names are not case-sensitive: Sales and sales are treated as the same name.
  • Avoid names that resemble cell addresses or names already used in the workbook.
  • Do not use R or C by themselves as names; Excel reserves them in certain reference contexts.

A name should describe what its cells mean, not just where they happen to be. For instance, a name like FirstQuarterSales communicates more than a label like B2_B13. That makes formulas easier to review when the worksheet changes, and helps another person understand the workbook without having to trace every cell address.

Workbook Scope and Worksheet Scope

The Scope setting controls where a name can be used. A workbook-scoped name is available throughout the workbook and is usually the simplest choice for a range that represents a shared input or dataset. A worksheet-scoped name is associated with one specific sheet, which can be useful when each sheet has its own independent range with the same label.

Scope matters if two names share the same spelling. A worksheet-scoped name can coexist with a workbook-scoped name of the same name, but formulas on that sheet can resolve the local name in preference to the workbook-level name. That can make a formula’s meaning less obvious. If you do not have a specific reason to use sheet scope, choose Workbook and avoid creating duplicate names. Name Manager displays scope so you can distinguish similarly named entries.

Changing a name’s scope after creation is not generally a simple edit in Name Manager. If you need the same name with a different scope, you may need to create a new name with the intended scope, update formulas that depend on the old one, and then remove the old name. Check formulas carefully before deleting or replacing a name.

Common Problems and Fixes

If Define Name is not visible, first confirm that the Formulas tab is selected. The command is in the Defined Names group, which may appear compressed if the Excel window is narrow. Widen the window or expand the ribbon to reveal commands. If you are using Excel for the web, Mac, or a customized ribbon, the display may be different; look for the same command on the Formulas tab or use Name Manager.

If Excel rejects a name, check for spaces, a leading number, a cell-reference-like label, or a name that already exists at the same scope. Replace spaces with underscores, start with a letter, and choose a distinctive label. If a name appears in Name Manager but a formula using it returns an error, inspect Refers to for an incorrect sheet, a deleted range, or a broken reference such as #REF!.

A common misconception is that naming a range makes it expand automatically when new rows are added. A name that refers to a fixed range such as B2:B13 continues to refer to that range; it does not necessarily include data entered in B14 later. For data that grows over time, consider converting the range to an Excel table using Insert > Table. Tables expand as rows are added and provide structured references. Alternatively, review and update the named range when the data layout changes.

Another point of confusion is that a defined name is not always a range. It may refer to a single cell, a calculated expression, or a constant. If selecting the name in Name Manager does not highlight a normal block of cells, inspect its reference or value there instead of assuming the name is missing.

When Named Ranges Are Useful

Named ranges are especially useful when formulas contain important assumptions or recurring data. Names like InterestRate, StartDate, or ProductList can make a workbook easier to understand than formulas filled with unexplained addresses. They can also simplify data validation sources and make chart series easier to identify. A name is most helpful when it is used consistently and reflects a stable purpose.

For a small workbook, cell references may be perfectly clear and require less setup. For a growing dataset, an Excel table may be a better alternative because its structured references identify columns by their headers and can adapt as the table grows. Named ranges and tables are not mutually exclusive: a name can refer to a table column or another meaningful range. Choose the option that makes the workbook easiest to maintain, rather than adding names to every cell by default.

Frequently Asked Questions

Where is Define Name in Excel?
On Windows desktop Excel, choose Formulas > Defined Names > Define Name. Select the target cell or range first so Excel can suggest its reference.

What is the shortcut for Name Manager?
In Excel for Windows, press Ctrl+F3 to open Name Manager. The corresponding shortcut may differ on Mac, so use Formulas > Name Manager if the keyboard shortcut is not apparent.

How do I create a named range without Define Name?
Select the cells, click the Name Box to the left of the formula bar, type a valid name, and press Enter. This quick method creates a workbook-level name; use the Define Name dialog when you need to set scope or review more options.

Can a defined name contain spaces?
No. Use letters, numbers, periods, or underscores in a valid name, and replace spaces with an underscore or remove them. For example, use Annual_Sales instead of Annual Sales.

Why does my named range not include new rows?
A name referring to a fixed cell range does not automatically grow in every setup. Check its reference in Name Manager, update it if needed, or use an Excel table for data that expands as new records are added.

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.