How to See Named Ranges in Excel and Check Their Cells

To see a named range in Excel, open Formulas > Name Manager to view its name and the cells or formula it refers to. To jump straight to a named range, click the Name Box to the left of the formula bar, choose its name, and press Enter. You need a workbook that contains defined names; Excel for Microsoft 365 on Windows is used for the steps below.

What You’ll Need

Excel for Microsoft 365 on Windows, or an Excel version with the Name Manager.
A workbook containing named ranges. If you are not sure whether it has any, check Name Manager; it will show the names that Excel recognizes in the workbook.
Permission to edit the workbook if you plan to change a name. You can inspect names without changing them, but a read-only file or protected workbook may prevent edits.

Step-by-Step

Open the workbook and save a working copy if needed. Open the workbook that contains the range. If you only need to inspect it, there is no need to change anything. If you expect to edit names or references, save a copy first so you can return to the original if a change causes an issue.
Open Name Manager to see the full list. On Windows, select Formulas > Name Manager on the ribbon. You can also press Ctrl+F3. The Name Manager window lists defined names and, where available, their scope and the cells or expression each name refers to. This is the clearest place to inspect names throughout a workbook, rather than looking only at the currently selected cells.
Find the name you want to inspect. Read down the Name column. If the workbook has many names, click a column heading to sort the list, or use the available filters to narrow what is displayed. Select a name to see its details, including Refers To. For example, a name such as SalesData might refer to a worksheet range such as =Sheet1!$B$2:$B$50. The reference tells you which cells the name represents.
Check the scope before using the name. Look at the Scope column. A name with workbook scope can generally be used from any worksheet. A name with a worksheet as its scope belongs to that sheet. Excel can contain a workbook-level name and a sheet-level name with the same spelling, so do not assume that matching labels always point to the same cells. If there are two versions, note the scope and the sheet where you plan to use the name.
Go to the named range from the Name Box. Close Name Manager, then click the small box to the left of the formula bar. This is the Name Box; it usually displays the active cell address, such as A1. Open its drop-down list, choose the named range, and press Enter. Excel selects the cells referred to by that name, and the worksheet scrolls to show them. If the name is not visible in the list, type it into the box and press Enter. This is a quick way to see where a name is located.
Confirm the selection and its address. Look at the highlighted cells on the worksheet. The Name Box may display the range name when a named range is selected, or it may show a cell or range address depending on the selection and the name. To confirm the exact reference, return to Formulas > Name Manager and check the selected name’s Refers To entry. The worksheet highlight is useful for orientation; the reference in Name Manager is the more reliable record of what the name points to.
Use Go To if you know the name already. Press F5 or Ctrl+G in Windows to open the Go To dialog. Select a name from the list or type the name in the Reference box, then choose OK. Excel selects the referenced cells. This works well when you want to navigate rather than review all names. On a Mac, use the menu’s Go To command if your keyboard shortcut differs; ribbon labels and shortcuts can vary by keyboard settings.
Inspect a name without changing it. In Name Manager, select the name and read its reference. Do not click Edit unless you intend to make a change. If you do need to edit it, review both the name and the Refers To entry before confirming. A small change to a reference can make formulas use a different set of cells, so verify the selected range on the sheet afterward.

In Excel for Mac, open the Formulas tab and choose Name Manager if it is available in your version. You can also use the Name Box to navigate to a name. In Excel for the web, the layout and name-management options may differ, and some desktop Name Manager actions may not be available. If you cannot view or manage the full list in the browser, choose Open in Desktop App and use the Windows or Mac steps above.

Common Mistakes

Confusing a named range with a cell address. A1 or B2:B20 is an address. A name such as TaxRate or SalesData is a label assigned to a cell or range. The Name Box can show either, so check Name Manager when you need to verify whether a label is a defined name.
Assuming the selected name is a simple block of cells. A name can refer to several areas, a constant, or a formula rather than one rectangular selection. If selecting it does not highlight one continuous block, inspect Refers To instead of concluding that the name is missing.
Overlooking scope. A sheet-level name may be available only in the context of its worksheet. If a name seems to behave differently on another tab, compare the scope entries in Name Manager and look for another name with the same spelling.
Editing when you only meant to inspect. In Name Manager, selecting a name is different from editing it. Avoid changing the Refers To field or pressing Delete just to see where the name goes. Use the Name Box or Go To to navigate without altering the definition.
Reading a broken reference as a valid range. If Refers To contains #REF!, the name points to a deleted or invalid reference. Selecting the name may fail or produce an error. Treat this as a broken definition that needs correction, not as a normal range address.

Tips

Use Name Manager for an inventory. The Name Box is fastest for jumping to one name; Name Manager is better for comparing many names, their scopes, and their references in one place.
Check the sheet name in the reference. A reference such as =Budget!$C$4:$C$18 points to the Budget sheet. If the tab is hidden, the name can still refer to it; the Name Manager reference helps you identify where the cells are.
Use the Name Box drop-down for quick navigation. Click its arrow to see available names, then choose one. When you have a long list, typing the name in the box can be quicker than scrolling. Press Escape if you start typing but decide not to navigate.
Remember that names can be more than ranges. Some names represent a single cell, a fixed value, or a formula. Read the Refers To entry before expecting Excel to highlight a block of cells.
Take care with workbook changes. Renaming or deleting a name can affect formulas, charts, or data validation that depend on it. If your goal is only to locate the cells, use Go To or the Name Box and leave the definition unchanged.

Troubleshooting

The Name Box list is empty or does not show the name. Open Name Manager to check whether the name exists in the workbook. Confirm that you opened the correct file and that the name is not scoped to a different worksheet. You can also type the name into the Name Box and press Enter. If Excel reports that it cannot find the reference, inspect the spelling and scope in Name Manager.

The name appears in Name Manager, but selecting it does not show the cells you expected. Select the entry and read the entire Refers To value. It may point to a different sheet, a single cell, multiple areas, or a formula. If the reference includes #REF!, some cells may have been deleted. If the name is sheet-scoped, try viewing it from the worksheet shown in the Scope column.

You cannot find Name Manager on the ribbon. Make sure you are looking at the Formulas tab, not Home or Data. In Windows desktop Excel, Ctrl+F3 is another way to open it. If you are using Excel for the web or a simplified ribbon, switch to the desktop app or expand the ribbon. On Mac, check the Formulas tab for Name Manager; available commands can vary by release.

The range is selected, but the Name Box shows an address instead of the name. That does not necessarily mean the name is invalid. The box can show the active cell or the selected address depending on how the selection was made. Use Name Manager to confirm the definition, or open Go To and check the name listed there.

You see two names that look identical. Compare the Scope column. One can be workbook-scoped while the other belongs to a particular worksheet. Use the name in the correct sheet context, and inspect its Refers To entry before relying on it. Do not delete one merely because the labels match; formulas may depend on either definition.

Frequently Asked Questions

How do I see all named ranges in an Excel workbook?
Open Formulas > Name Manager, or press Ctrl+F3 in Windows desktop Excel. The list includes defined names and lets you review their scopes and references.

How do I see which cells a named range refers to?
Select the name in Name Manager and read its Refers To entry. You can also choose the name from the Name Box or Go To dialog to select the referenced cells on the worksheet.

Can I see a named range without opening Name Manager?
Yes. Open the Name Box drop-down to choose a name, or press F5 or Ctrl+G on Windows and use Go To. These methods navigate to the range; Name Manager is better for checking its exact definition.

Why does a named range have a sheet name in its scope?
That is a worksheet-level name. It is associated with one sheet rather than being available everywhere in the workbook. Check the Refers To entry to see which cells it identifies.

Can a name refer to something other than a cell range?
Yes. A defined name may refer to a formula, a constant, or more than one area. Read Refers To before assuming the name will select a single rectangular group of cells.

Can I view named ranges in Excel for the web?
Some name features are available in the browser, but the interface and editing options can differ from desktop Excel. If you cannot find the full list or inspect a definition, open the workbook in the desktop app and use Name Manager.

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.