Excel Named Range Manager: How to View and Edit Names

How-to basics · Updated November 19, 2026

In Excel for Microsoft 365 on Windows, open Formulas > Defined Names > Name Manager to view, create, edit, delete, or filter named ranges. You can also press Ctrl+F3 to open it; the manager shows what each name refers to and whether it applies to the whole workbook or a particular worksheet.

What the Excel Name Manager does

A named range is a meaningful label assigned to a cell, a group of cells, or another value or calculation. Instead of remembering that tax rates are in D2 or sales figures are in B2:B13, you can give those references names such as TaxRate and MonthlySales. The Name Manager is the central place to inspect and maintain these defined names.

Names can refer to a fixed cell or range, a constant such as a tax rate, or a formula. They can make formulas easier to read and help users navigate large workbooks, but they do not change the underlying data. A name is workbook structure, not a new copy of the cells it identifies.

The manager is especially useful when you inherit a workbook, troubleshoot a formula, or need to find names that are no longer used. A workbook can accumulate names over time as people copy sheets, change layouts, or import data. Some are helpful; others may point to old locations or display a broken reference.

How to open and read Name Manager

In desktop Excel for Microsoft 365 on Windows, select Formulas > Defined Names > Name Manager, or press Ctrl+F3. The dialog lists names and provides actions such as New, Edit, and Delete. A filter option can help narrow the list, depending on the names and Excel build.

Look at the columns before changing anything. Name is the label used in formulas; Value shows the current evaluated value where Excel can display one; Refers To shows the range or expression behind the name; and Scope indicates whether it belongs to the workbook or an individual sheet. A comment may also be present to explain a name’s purpose.

On a Mac, use the Formulas tab and its Name Manager command; ribbon placement and wording can vary slightly by Excel version. Excel for the web has a different interface and may not expose every desktop management feature. If you need to audit or repair many names, open the workbook in desktop Excel.

Create or edit a named range

To define a name in the manager, open Name Manager and choose New. Enter a clear name, choose the intended scope, and set Refers To to the correct cell reference or expression. Select OK, then check the new entry in the list. To change an existing entry, select it and choose Edit; changing the name or its reference does not move the cells themselves.

For a simple example, suppose a worksheet has monthly sales in cells B2 through B13. Select the correct scope and create the name MonthlySales, with the reference pointing to that range. In a cell where names are available, the formula =SUM(MonthlySales) adds the values in the named cells. If the values are 120, 150, and 130 in a three-cell example range, the sum is 400; the name only substitutes for the range address.

Names must follow Excel’s naming rules. They cannot contain spaces, and they cannot be written like a cell address such as A1. A name generally begins with a letter, an underscore, or a backslash; it can include numbers, periods, and underscores after the first character. Choose names that describe their contents, such as StartDate or ProductCodes, rather than vague labels like Data1.

You can also create a quick workbook-level name by selecting cells and typing a name in the Name Box to the left of the formula bar, then pressing Enter. Use Name Manager when you need to set or verify scope, add a comment, enter a more complex reference, or review existing names.

Workbook scope and worksheet scope

A workbook-scoped name is available throughout the workbook. A worksheet-scoped name is available only on its designated sheet, which can be useful when several sheets use the same short label for different purposes. For example, each regional worksheet might have a local name Target referring to that sheet’s own target cell.

When a worksheet-level name and a workbook-level name share a label, the local name takes precedence in formulas entered on that sheet. This can be useful, but it can also make a formula difficult to interpret if a reader assumes the workbook-wide definition is being used. Check the Scope column whenever the same name appears more than once.

Scope is chosen when a name is created and cannot simply be changed in the Edit dialog. To convert a sheet-scoped name to workbook scope, or the reverse, create a replacement name with the desired scope, update formulas that depend on the old name, and then remove the obsolete definition after checking its use. Do not delete first if you are unsure which formulas rely on it.

How names behave in formulas

Excel substitutes a name’s definition when it calculates a formula. This can make a formula such as =SUM(MonthlySales) easier to understand than a formula containing a long sequence of cell coordinates. Names can also be used in data validation, charts, and other workbook features, although availability and editing steps depend on the feature.

A name may contain an absolute or relative reference. Absolute references stay fixed when a formula is copied; relative references can shift based on where a formula is entered or copied. This is one reason to inspect Refers To rather than assuming a name always points to the same cells. For a reusable range intended to stay fixed, confirm that the reference uses dollar signs where appropriate.

Names do not automatically expand just because you type new data below a fixed range. If MonthlySales refers to B2:B13, adding a value in B14 does not necessarily include it. For data that grows, consider converting the source into an Excel table and using its structured references, or deliberately update the name’s reference. Tables are often a better fit for growing lists because their references expand as rows are added.

Static and dynamic named ranges

A static name points to a fixed address. It is simple to understand and is often best for a small, stable input area, such as a tax-rate cell or a fixed set of assumptions. The trade-off is that you must revise it when the intended range changes.

A dynamic name uses a formula as its definition so its referenced area can adjust as data changes. Dynamic definitions can be useful for lists that grow, but they require careful design: blank rows, headers, inserted columns, and unexpected data can affect the resulting range. A dynamic definition can also be harder for another person to maintain than a clearly formatted Excel table.

Before choosing a dynamic range, ask whether the source is really variable and whether a table would solve the problem more simply. If you use a formula-based name, test it after adding and removing rows and inspect its result in Name Manager. Keep the definition understandable and document unusual logic with a comment.

Common problems and how to fix them

  • A name shows #REF! in Refers To. The cells or sheet it referenced may have been deleted or moved in a way Excel could not preserve. Edit the definition to point to the intended location, or remove it if it is obsolete and no longer needed.
  • A formula returns #NAME?. Check spelling, scope, and whether the name still exists. A worksheet-scoped name may not resolve as expected from a different sheet, and deleting a name used by a formula can leave that formula unable to identify it.
  • The wrong cells are included. Compare the visible range with the Refers To entry. Check for an omitted final row, an unintended absolute or relative reference, or a sheet name that points to a different worksheet.
  • Two names look identical. Check scope. A local name and a workbook-level name can share the same text but refer to different cells, so formulas may resolve differently depending on the sheet.
  • A new row is not included. The name may be a fixed range. Expand the reference or use a table when the data is expected to grow regularly.

Use Find and Replace cautiously when changing a name used in many formulas. A text replacement can affect labels or unrelated formulas as well as the intended references. For a workbook you did not create, make a copy before deleting or redefining names, then recalculate and check important outputs.

Review names safely and keep a workbook maintainable

Before removing a name, inspect its definition and consider where it might be used: formulas, charts, data validation lists, conditional formatting, or macros. Name Manager does not by itself provide a complete dependency report showing every use. Search the workbook for the name as one check, but recognize that formulas and workbook features may not all be found by a simple text search.

Prefer descriptive, consistent names and add comments when the purpose is not obvious. Avoid keeping multiple obsolete definitions just because they are harmless today; they can confuse later editors. Conversely, do not delete unfamiliar names during a quick cleanup without checking them. They may support a report or a hidden workflow.

When investigating a problem, record the name, scope, and current reference before editing. Make one change at a time, verify formulas and outputs, and save a copy before a large cleanup. This is particularly important in shared or business-critical workbooks, where a name may be part of a process that is not visible on the sheet.

Frequently Asked Questions

Where is Name Manager in Excel?
In Excel for Microsoft 365 on Windows, select Formulas > Defined Names > Name Manager. You can also press Ctrl+F3. On Mac, use the Name Manager command on the Formulas tab.

What is the shortcut to open Name Manager?
The Windows shortcut is Ctrl+F3. Ribbon commands are the more dependable route if the shortcut is intercepted by your keyboard or differs in your setup. Mac users can open it from the Formulas tab.

Can I change a named range’s scope?
Not directly in the Edit dialog. Create a new name with the desired scope, update formulas and other uses, then delete the old definition only after checking it is no longer needed.

Why does my named range not expand when I add data?
A name that refers to a fixed range continues to refer to that address. Update its definition or use an Excel table if the data is expected to grow as new rows are added.

Is a named range the same as an Excel table?
No. A named range labels a reference or expression, while a table is a structured data feature with headers and table-specific references. Tables generally handle added rows more naturally; names are useful for individual cells, fixed ranges, or formulas.

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.