How to Find Range Names in Excel: A Practical Guide

To find range names in Excel, open Formulas > Name Manager to review the workbook’s defined names, or use the Name Box to jump straight to a named cell or range. These tools help you identify what a name refers to, check whether it applies to the whole workbook or one worksheet, and locate the cells it represents. The steps below are for Excel for Microsoft 365 on Windows; save a copy first if you plan to edit or delete names.

What You’ll Need

An Excel workbook open in the desktop app. If you are using Excel for the web and cannot find a name-management command, open the workbook in the desktop app.
Permission to view or edit the workbook. A protected sheet or workbook may prevent you from changing a name, although you can usually inspect names.
For the quickest route, know at least part of the name or the worksheet where you expect it to be used. This is helpful, but not required.

Step-by-Step

Open Name Manager. Select the Formulas tab, then choose Name Manager in the Defined Names group. In Windows desktop Excel, you can also press Ctrl+F3. Name Manager is the best place to review the complete list of ordinary defined names, their references, and their scope. On a Mac, use Formulas > Name Manager; the Windows shortcut may not apply because keyboard shortcuts vary with Mac settings and keyboard model.
Review the columns in the list. Name Manager shows information such as Name, Value, Refers To, Scope, and Comment. The name is the label used in a formula or in the Name Box. Refers To shows the address, formula, or value connected to it. Scope tells you whether the name is available throughout the workbook or only on a particular worksheet. Make the Name Manager window wider if a long reference is cut off.
Find a particular name. Look down the Name column for the expected label. If the workbook has many entries, use the available filter menu to narrow the list, for example to workbook-scoped names, worksheet-scoped names, defined names, or table names. The exact filters shown depend on the names in the workbook. You can also select a column heading to help inspect the list, if that control is available in your Excel build. Do not assume a name is missing just because it is not in the first part of the list.
Check what the name refers to. Select the name and inspect its Refers To entry. A reference such as =Sheet1!$A$2:$A$20 points to a cell range. A reference beginning with a formula, or a constant such as a number or text value, may be a defined name but not a navigable range. If Refers To contains #REF!, the name has a broken reference. Avoid editing it until you understand which formulas, charts, or other workbook features depend on it.
Check the name’s scope. A workbook-scoped name is generally available throughout the file. A worksheet-scoped name is limited to its sheet and can share its label with a name on another sheet. In Name Manager, read the Scope column rather than relying only on the name text. If two entries look alike, note both their worksheet and their Refers To values; they may be separate names with different meanings.
Jump to a named range with the Name Box. Close Name Manager, then find the Name Box at the left end of the formula bar, above the worksheet grid. Click its drop-down arrow and choose a listed name. Excel selects the cells that name refers to, if it represents a cell or range reference. For a short name you already know, click in the Name Box, type the name, and press Enter. The active cell or selected range should move to the name’s location.
Confirm the selection. Check the highlighted cells and the address shown in the Name Box. For a multi-cell range, Excel outlines or selects the full range; the formula bar may show the active cell’s contents, not the full range definition. To verify the exact reference, reopen Name Manager and inspect Refers To. If the selection lands on another worksheet, the name is valid but points to a different sheet than the one you were viewing.
Use the name in a formula if that is your goal. A range name can replace a cell address in formulas when the name is in scope for that formula. For example, a name such as SalesData may represent a range used in a calculation. This is different from finding where a name is defined: use Name Manager for the definition, and use the Name Box to navigate to a referenced range. If a formula gives an error, check the name’s scope and Refers To entry before changing the formula.

Common Mistakes

Looking only in the Name Box. The Name Box is convenient for navigating, but it is not the most reliable way to audit every kind of defined name. It cannot take you to a constant or a formula-only name, and its drop-down is not a substitute for checking scope and references in Name Manager.
Confusing a table name with a named range. Excel tables have names too, and table names can appear among workbook names. A table name identifies a structured table and is used with structured references; it is not necessarily a conventional cell-range name. Check the Name Manager filters and the Refers To information to tell what you are looking at.
Ignoring worksheet scope. Two names with the same visible label may belong to different sheets. A formula on one sheet may resolve a sheet-level name differently from a workbook-level name. Confirm the Scope column before concluding that a name is duplicated or points to the wrong range.
Assuming every name points to cells. Defined names may represent a constant, a formula, or another expression. A name that does not select a visible range is not automatically broken. Read Refers To to understand its purpose.
Deleting or changing a name before checking its uses. Formulas, charts, validation lists, and other workbook features may rely on a name. A change can affect more than the selected cells. Inspect the reference and save a copy before making changes you are unsure about.

Tips

Use the two tools together. Find and inspect a name in Name Manager, then use the Name Box to jump to it if it refers to cells. This is more dependable than trying to infer the reference from a formula alone.
Look for names with errors. Name Manager’s filter options can help isolate names with errors. A name containing #REF! may have been left behind after its source cells or sheet were deleted. Check whether it is still used before repairing or removing it.
Keep a record before cleanup. If you are auditing a complex workbook, note the name, scope, and Refers To value before editing anything. This makes it easier to reverse a mistaken change and to explain why a name exists.
Search formulas when you need to find usage. Name Manager tells you what a name refers to, but it does not by itself show every formula that uses that name. You can use Home > Find & Select > Find, open the search options, and set Look in to Formulas to search worksheet formulas for a name. This finds matching formula text, not every possible use in charts, validation rules, or other workbook features.
Use descriptive labels. When adding or maintaining names, choose labels that indicate their purpose, such as a department or reporting period. Avoid names that are hard to distinguish from cell references, and review the scope so future users know where the name applies.

Troubleshooting

Name Manager is empty or does not show the name you expect. Check the filter menu and clear any filter that limits the list to a scope or name type. Verify that you have opened the right workbook and that the expected item is not a table name or a name scoped to another worksheet. Names can also be hidden by workbook design or created by features and add-ins; ordinary Name Manager views may not expose every internal or hidden name.

The Name Box does not jump to the expected cells. Confirm that you typed the name exactly and pressed Enter. Reopen Name Manager to check its scope and Refers To entry. If the name is worksheet-scoped, select the relevant worksheet and inspect that sheet’s entry. If Refers To contains a constant or formula rather than a cell address, there may be no range for Excel to select.

The name takes you to the wrong sheet or cells. Return to Name Manager and inspect the complete reference, including the sheet name and dollar signs. A reference such as =Sheet2!$A$2:$A$20 intentionally points to Sheet2, even when you start from another sheet. If two similarly named entries exist, compare their scopes before deciding which one to use.

The name shows #REF! or a formula error. This usually means its reference no longer resolves, often because cells or a worksheet were deleted or moved. Check whether related formulas still use the name and whether the intended source range is known. If you can confirm the correct replacement, select the name in Name Manager, choose Edit, and update Refers To. If you cannot confirm it, leave it unchanged and ask the workbook owner rather than guessing.

You cannot edit or delete a name. The workbook or worksheet may be protected, or the name may be managed by a table, add-in, or other feature. Check the protection status and the name’s type. Do not remove a table name as though it were an unused range name; changing it can affect structured references.

Frequently Asked Questions

How do I see all range names in an Excel workbook?

Open Formulas > Name Manager. Review the list and clear or adjust filters if names appear to be missing. The Name Box is useful for jumping to ranges, but Name Manager provides more detail about names and their scope.

What is the fastest way to go to a named range?

Click the Name Box, type the name, and press Enter, or select it from the Name Box drop-down. This works when the name resolves to a cell or range reference. Use Name Manager if you are unsure of the spelling or reference.

Can a range name apply to only one worksheet?

Yes. Names can have workbook scope or worksheet scope. Check the Scope column in Name Manager. A worksheet-scoped name is intended for use on its associated sheet, and another sheet may have a separate name with the same label.

Why is a name missing from the Name Box list?

It may not refer to a selectable range, may be scoped to a different worksheet, or may be a table name or hidden/internal name. Check Name Manager and its filters first. Some names created by Excel features or add-ins may not appear like ordinary range names.

Can I find every formula that uses a range name?

You can search worksheet formulas for the name with Find and the Look in: Formulas setting. That search can help locate formula text, but it may not find uses in charts, data validation, or other features. Name Manager shows the definition, not a complete dependency report.

Is Ctrl+F3 the same on Mac?

Ctrl+F3 opens Name Manager in Excel for Windows. On a Mac, use Formulas > Name Manager; shortcut behavior can depend on the keyboard and macOS settings, so the ribbon path is the dependable option.

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.