how to find Names Manager in Excel

Phillip Richcreek 1,080 Reputation points
2026-03-20T18:53:12.58+00:00

The spreadsheet in question has NAMES defined . I need to add a Named cell.

Microsoft 365 and Office | Excel | Other | Windows
0 comments

1 answer

Sort by: Oldest
Most helpful Newest Oldest

  1. AI answer

    2026-03-20T18:53:23.27+00:00

    In Excel for Windows, Name Manager is on the Formulas tab.

    To open Name Manager and add a named cell:

    1. Go to the Formulas tab on the Ribbon.
    2. In the Defined Names group, click Name Manager.
      • This opens the Name Manager dialog where all existing names are listed.
    3. To add a new named cell or range, click New… (or Define Name from the Formulas tab):
      • In Name, type the name to use.
      • In Scope, choose Workbook or a specific worksheet.
      • In Refers to, select the cell (or range) on the sheet, or type the reference/formula.
    4. Click OK to save.

    After that, the new name can be used in formulas (for example, via Formulas > Defined Names > Use in Formula).

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.