Excel Find Defined Names: Name Manager, Scope, and Uses

How-to basics · Updated November 19, 2026

To find defined names in Excel for Microsoft 365 on Windows, open Formulas > Name Manager, or press Ctrl+F3. Name Manager lists names in the workbook and shows what each one refers to; to jump to a named cell or range, select or type its name in the Name Box to the left of the formula bar.

What defined names are

A defined name is a label for a cell, range, formula, or constant. Instead of referring to a range such as $B$2:$B$20 in a formula, you might give it the name Sales. Then a formula can use that label, for example =SUM(Sales). Names can make formulas easier to read and help people understand the purpose of a range.

Excel also uses names for items such as print areas and some formula features, and tables have their own names. These related items do not all behave identically. A table name is used with structured references, while a defined name can refer to a range or formula. If you are looking for a specific item, check its type and scope rather than assuming every name in a workbook is an ordinary cell range.

Find a name with Name Manager

Name Manager is the most direct place to review defined names, their destinations, and their scope. In Excel for Microsoft 365 on Windows, use Formulas > Defined Names > Name Manager. Ctrl+F3 is the keyboard shortcut. The dialog includes columns such as Name, Value, Refers To, Scope, and Comment, though the visible columns may depend on the Excel version and dialog layout.

  1. Open the workbook and choose Formulas > Name Manager, or press Ctrl+F3.
  2. Look down the Name column. Select a name to inspect its Refers To entry and other details.
  3. If the list is long, use the Filter menu to narrow the list by available categories, such as names with errors or names scoped to a particular sheet.
  4. Choose Close when you have finished reviewing the list. To change or remove a name, use Edit or Delete only after checking what depends on it.

Name Manager is useful even when you already know the name: it confirms whether the name exists, whether it refers to the expected cells, and whether it belongs to the workbook or a particular worksheet. It can also expose references that are easy to miss when looking only at the grid.

Jump to a named range

If your goal is to locate the cells a name represents, use the Name Box, the small box at the left end of the formula bar that normally displays the active cell address, such as A1. Click its drop-down arrow to see available names, or click in the box, type a known name, and press Enter. Excel selects the referenced cell or range when the name resolves to a location in the workbook.

You can also press Ctrl+G to open Go To, type a defined name, and select OK. This is handy when you want to navigate without opening Name Manager. If a name refers to a formula that returns a value rather than a cell reference, it may not take you to a selectable range. In that situation, inspect the name in Name Manager instead.

For a multi-cell name, Excel selects the entire range. The active cell is one cell within that selection, so the formula bar may show the content of the active cell rather than a special display for the name. Check the Name Box or the selection outline to confirm the range.

Understand scope when names appear missing

Every defined name has a scope. A workbook-scoped name is available throughout the workbook. A worksheet-scoped name is associated with one sheet and is generally used in that sheet’s context. Excel permits a worksheet-scoped name and a workbook-scoped name to share the same spelling; when formulas are evaluated on the worksheet, the local name can take precedence.

This is a common reason a name seems to be missing or points to unexpected cells. For example, a workbook might contain a workbook-scoped name called TaxRate and a separate TaxRate scoped to the Budget sheet. Name Manager can show both entries and their scopes. When checking a formula on Budget, do not assume that the workbook-level TaxRate is the one Excel is using.

  • Check the Scope column in Name Manager rather than relying only on the name text.
  • Check the sheet that contains the formula, especially if another sheet has a local name with the same spelling.
  • When creating a name, choose the intended scope carefully; changing scope later may require deleting and recreating the name.

Find formulas that use a defined name

Name Manager tells you what a name refers to, but it does not provide a complete list of every formula that uses that name. To look for usages in worksheet formulas, press Ctrl+F, open Options if needed, set Within to Workbook, and set Look in to Formulas. Search for the name and review the matches. This searches formula text in cells; it is different from searching the definitions listed in Name Manager.

Use care when interpreting matches. Searching for TaxRate may also find a longer name such as OldTaxRate, and text in formulas can appear for reasons other than a reference to the exact defined name. Excel name matching is not case-sensitive. Review each formula, and consider the sheet and surrounding formula before deciding that a match is a true dependency. Find All can help show multiple matching cells, but it is not a dependency-reporting tool.

If you only need to confirm the destination of a name, inspect Refers To in Name Manager. If you need to understand what would be affected by changing or deleting it, search formulas and check relevant charts, validation rules, conditional formatting, and other workbook features as appropriate. A name may be used outside ordinary cell formulas.

Why a name may not show up

Several different issues can make a name difficult to locate. First, verify that you have the correct workbook open and that the name is not scoped to another sheet. Then check whether a filter is active in Name Manager; a filter can hide entries that do not match its selected category. Clear or change the filter and review the Scope column.

Names can also refer to an error, an external workbook, or a formula that no longer points to valid cells. Name Manager may show an error value or a Refers To expression containing #REF!. That means the name definition is present but its reference is broken; it does not mean the name is absent. Edit the definition only after identifying the intended replacement range and checking formulas that rely on it.

Some workbooks contain hidden defined names, often created by software, add-ins, or workbook features. These may not appear in the normal Name Manager list. If you suspect a hidden name, do not conclude that an ordinary visible-name search has found every internal name. Avoid changing hidden or unfamiliar entries without understanding their purpose; they may support workbook behavior.

Rename, edit, or delete a found name

In Name Manager, select a name and choose Edit to change its name, its Refers To definition, or its comment. Use Delete to remove a selected name. Before making either change, inspect the current definition and consider where the name is used. Renaming or deleting a name can cause formulas and other workbook features that depend on it to stop working or display errors.

A safer sequence for a workbook you did not create is to save a separate copy, record the existing Refers To value, and search for likely formula usages before editing. After the change, check key worksheets and recalculate or reopen the workbook if needed. Name Manager edits affect the workbook itself; they are not merely changes to how a name appears in the dialog.

Windows, Mac, and Excel for the web

The instructions above are for Excel for Microsoft 365 on Windows. In Excel for Mac, look for Name Manager on the Formulas tab; keyboard shortcuts can differ by keyboard and Mac settings, so the ribbon command is the dependable route. The Name Box and Go To are also available for navigating to a name, although exact menus and shortcut keys may vary by release.

Excel for the web has a different interface and may not expose every name-management command or capability available in the desktop app. If you cannot find or edit a name there, open the workbook in the desktop version of Excel and use Formulas > Name Manager. The web app can still be useful for working with names already present in a workbook, but available tools can change as Microsoft updates the service.

Frequently Asked Questions

What is the shortcut to open Name Manager in Excel?
In Excel for Microsoft 365 on Windows, press Ctrl+F3. You can also choose Formulas > Defined Names > Name Manager. On a Mac, use the Formulas tab if the shortcut differs on your keyboard.

How do I find the cells a defined name refers to?
Type the name in the Name Box and press Enter, or press Ctrl+G, enter the name, and choose OK. To verify the exact reference, open Name Manager and inspect Refers To.

Why can two names have the same spelling?
Excel allows a worksheet-scoped name and a workbook-scoped name to share a spelling. Check the Scope column in Name Manager and the sheet containing the formula to identify which definition applies.

Can I use Ctrl+F to search defined names?
Ctrl+F searches worksheet content, not the list of name definitions in Name Manager. Use Name Manager to find definitions. To search for formulas that use a name, set Find’s Look in option to Formulas and search the workbook.

Why does a defined name show #REF!?
The name exists, but its Refers To definition contains an invalid reference, often because cells or a sheet it depended on were deleted. Inspect the definition and restore or replace the reference only after confirming the intended destination.

Does Excel have a search box in Name Manager?
Name Manager provides a list and filters, but it is not a general text-search window. For a long list, use its available filters and review the Name column; you can also sort by clicking a column heading where the dialog supports it.

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.