Excel Named Ranges List: Find, View, and Manage Defined Names

To see an Excel named ranges list, open Formulas > Name Manager in Excel for Microsoft 365 on Windows, or press Ctrl+F3. The manager shows each visible defined name alongside its value, reference, scope, and comment; for a simple navigation list, use the Name Box dropdown to the left of the formula bar.

What an Excel named range is

A named range is a label assigned to a cell, a range of cells, a formula, or a constant. Instead of referring to a cell address such as B2:B50, a formula can use a meaningful name such as Sales. That can make formulas easier to read and maintain, especially in workbooks with several sheets or calculations.

“Named range” is common shorthand, but Excel’s broader term is a defined name. Not every defined name represents a range: a name can refer to a formula or a fixed value too. Excel Tables also have names, but a table name is a separate feature from an ordinary defined name. Table names are managed through the table’s design tools, not treated as ordinary named ranges in Name Manager.

For example, if Sales refers to Sheet1!$B$2:$B$50, a formula can use =SUM(Sales). The label describes the data, while the reference tells Excel what cells the label represents. If the underlying range changes, the name’s reference may need to change as well.

View the full list in Name Manager

Name Manager is the best built-in place to inspect defined names. In Excel for Microsoft 365 on Windows, select Formulas > Defined Names > Name Manager, or use Ctrl+F3. The dialog includes columns for Name, Value, Refers To, Scope, and Comment. The Value column shows what the name evaluates to; Refers To shows the underlying cell reference or expression.

Use the list to check whether a name points to the intended sheet and cells, whether a name is workbook-wide or limited to one worksheet, and whether a comment explains its purpose. Select a name to see its details, then choose Edit to change its definition or Delete to remove it. Use care with deletion: formulas that depend on a deleted name can return #NAME?.

Name Manager is an inventory and editing dialog, not a formatted report. It does not provide a one-click export of the complete list to a worksheet. If you only need to inspect a few entries, the dialog is usually enough. If you need a shareable or sortable register, use a controlled manual process or a macro, as described below.

Use the Name Box for quick navigation

The Name Box sits immediately to the left of the formula bar. Click its dropdown arrow to see names available for navigation, select one, and press Enter to move to the associated cell or range. You can also type a cell reference or a defined name directly into the box and press Enter.

This is convenient when someone gives you a name such as InputCells and you want to jump to it without searching the sheet. However, the Name Box is not a complete inventory: it does not show the Refers To expression, scope, or comment beside each entry. Depending on the active sheet and name, it may not expose every defined name you need to review. Use Name Manager when accuracy and details matter.

Understand workbook and worksheet scope

Every defined name has a scope. A workbook-scoped name is available throughout the workbook. A worksheet-scoped name is available only on its specified sheet. Name Manager’s Scope column identifies the distinction, showing either Workbook or a sheet name.

Excel can have a workbook-scoped name and a sheet-scoped name with the same spelling. On the sheet that owns the local name, the local definition takes precedence in many formula contexts. That can make a formula appear to use a different range from the one you expected. When investigating a name, check both its spelling and its scope rather than relying on the name alone.

Names may refer to ranges on another sheet, constants, or formulas. A name can also use relative references. Relative names are interpreted in relation to the active cell when used, so they can behave differently as formulas are copied or entered in different locations. For a conventional fixed range, absolute references such as =$B$2:$B$50 are easier to reason about. Do not change a relative reference to an absolute one automatically; first establish why the name was defined that way.

Create a worksheet inventory when needed

If you need a list that can be sorted, shared, or annotated, Name Manager does not offer a direct export command. One option is a VBA macro that writes defined names, their Refers To expressions, and visibility status to a worksheet. The following example creates or clears a sheet called Name List in the workbook that contains the macro. It includes hidden defined names as well as visible ones, which can be useful during an audit.

To use it, first save a copy of the workbook. In desktop Excel, open the Visual Basic Editor, insert a standard module in the target workbook, paste the code, and run ExportDefinedNames. Macros cannot be undone with Ctrl+Z, so review the destination sheet and keep the backup. The macro clears existing contents on a sheet already named Name List.

Sub ExportDefinedNames()
    ' Write this workbook's defined names to a worksheet.
    Dim sourceBook As Workbook
    Dim outputSheet As Worksheet
    Dim definedName As Name
    Dim nextRow As Long

    Set sourceBook = ThisWorkbook

    On Error Resume Next
    Set outputSheet = sourceBook.Worksheets("Name List")
    On Error GoTo 0

    If outputSheet Is Nothing Then
        Set outputSheet = sourceBook.Worksheets.Add( _
            After:=sourceBook.Worksheets(sourceBook.Worksheets.Count))
        outputSheet.Name = "Name List"
    Else
        outputSheet.Cells.Clear
    End If

    outputSheet.Cells(1, 1).Value = "Name"
    outputSheet.Cells(1, 2).Value = "Refers To"
    outputSheet.Cells(1, 3).Value = "Visible"
    nextRow = 2

    For Each definedName In sourceBook.Names
        outputSheet.Cells(nextRow, 1).Value = definedName.Name
        outputSheet.Cells(nextRow, 2).Value = definedName.RefersTo
        outputSheet.Cells(nextRow, 3).Value = definedName.Visible
        nextRow = nextRow + 1
    Next definedName

    outputSheet.Columns("A:C").AutoFit
End Sub

The output is a snapshot, not a live link to Name Manager. Run the macro again after names change to refresh it. A name’s full text may include a sheet qualifier when it is sheet-scoped. The code lists defined names, not every Excel object that has a name; for example, review Table names separately if your goal is a complete inventory of workbook objects.

Review, edit, or remove names safely

Before editing a name, check the Refers To field and the formulas that use it. A typo in a reference can redirect calculations, while deleting a name can break formulas or data-validation rules that rely on it. If a workbook is important, make a copy before making broad changes.

To create a range name: select the cells, click the Name Box, type a valid name, and press Enter. You can also use Formulas > Define Name to set the name, scope, reference, and comment in a dialog.
To change a definition: open Name Manager, select the entry, choose Edit, and update the name or Refers To field. Check the scope before saving.
To remove an obsolete entry: select it in Name Manager and choose Delete. Confirm that the name is not used in formulas, charts, validation lists, or other workbook features.
To identify a broken reference: inspect Refers To for #REF!. Excel may leave a defined name behind after the cells it referred to have been deleted.

Names have syntax rules: they cannot contain spaces, must begin with a letter, underscore, or backslash, and cannot be written like a cell reference such as A1. Use short, descriptive names and consistent conventions—for example, TaxRate or InputCells—so the list remains readable. Avoid changing capitalization or punctuation conventions casually in a shared workbook.

Common problems and what the list can reveal

A named range that appears to be missing often has a scope issue. Check the Scope column in Name Manager and look for a worksheet-specific entry with the same name. Another common cause is a hidden defined name: it may not appear in ordinary navigation, while Name Manager’s visible list may not show hidden entries. The macro above includes the Visible property to help identify them.

If a formula using a name returns #NAME?, verify the spelling and confirm that the name still exists in the relevant scope. If a calculation points to unexpected cells, inspect the full Refers To value and check for duplicate local and workbook names. If a name refers to #REF!, the original cells or sheet may have been removed or renamed in a way that broke the reference.

Some defined names are created by Excel for features such as print areas, and workbooks can contain names added by other tools or older versions of Excel. Not every entry is user-created or safe to delete. If a name is unfamiliar, record its reference and investigate its use before removing it; a long list by itself is not evidence that the entries are unnecessary.

Excel for Mac and Excel for the web

On Excel for Mac, use the Formulas tab and its name-management commands; the labels and ribbon layout can vary slightly by release. The Windows Ctrl+F3 shortcut is not a universal Mac shortcut, so use the ribbon if it does not work on your keyboard. The Name Box is also available for navigation.

Excel for the web supports many workbook formulas and defined names, but its name-management options can differ from the desktop dialog and may not expose every detail or workflow described here. If you need to audit scope, inspect hidden names, or run the VBA inventory macro, open the workbook in desktop Excel. VBA macros do not run in Excel for the web.

Frequently Asked Questions

How do I see all named ranges in Excel?
Open Formulas > Name Manager on Windows, or press Ctrl+F3. Review the Name, Refers To, and Scope columns. For a worksheet inventory, use a macro or record the entries you need in a separate list.

Can I get a named ranges list in a worksheet without VBA?
Excel does not provide a standard worksheet formula that returns every defined name in the workbook. You can copy details into a worksheet manually, or use VBA for a repeatable inventory. The Name Box dropdown is for navigation, not a complete export.

Why does the same name appear more than once?
Excel allows a workbook-scoped name and a worksheet-scoped name to share the same spelling. Check the Scope column to tell them apart and determine which definition applies in the sheet where the formula is entered.

How do I find a named range’s cell reference?
Select the name in Name Manager and read its Refers To field. The Name Box can take you to the range, but it does not show the full reference expression as clearly.

Are Excel Table names included in Name Manager?
Table names are not ordinary defined names. To review them, select a cell in each table and inspect the table name on the table-design ribbon. Include that separate check when documenting all named workbook objects.

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.