How to Use Name Manager in Excel (Step-by-Step Guide)

If you have worked with large Excel spreadsheets, you would agree with me that sometimes, it could get confusing when you stare at formulas like =SUM(D2:D200)*0.075 months after writing it. 

Name Manager is a built-in Excel tool that allows you to assign readable names to cell ranges, constants, and formulas. Instead of using cell references like C2:C200, your formulas read like plain English, like Total_Sales. 

In this article, I will cover everything you need to know about Name Manager in Excel, ranging from what Name Manager is and why it matters, to how to create and edit named ranges, how scope works, and common errors you will run into. Whether you are new to Excel or have been building Excel models for years, there is something here for you.

What Is a Name Manager in Excel?

Name Manager is a built-in Excel tool that lets you view, create, edit, and delete named ranges and named formulas from one place. Think of it as the Contact app on your smartphone, where instead of memorizing phone numbers (the cell address, e.g., C2, D20), you just search for the name under which you saved those numbers.

Named ranges work the same way: instead of referencing B1:B20, you can call that range Total_Sales and any formula in that worksheet can use Total_Sales instead of a cell address.

You will find it in the Formula ribbon, click Name Manager in the Defined Names Group.

Why Use Name Manager in Excel?

The main reason for Name Manager is readability. Compare these two examples,

= SUM(C2:C120) * D1

SUM(Sales_Revenue) * Tax_Collected

Both return the same result. However, the second formula tells you what it does without any additional thinking. This is important when you have to share the workbook with a colleague or return to it months later.

It’s fairly self-explanatory, but here are the benefits more formally:

• Cleaner formulas: Descriptive labels replace cell addresses with descriptive labels that are easy to understand. A formula like = VLOOKUP(A2, Product_Catalog, 3, FALSE) is easier to understand than = VLOOKUP(A2, Sheet2!$A$1:$F$500, 3, FALSE).

• Easier navigation: You can easily pick any named range directly from the name box and use it in any calculations. In large workbooks, this saves you time.

• Simpler maintenance: If your data range expands from row 150 to row 300, you just have to update the named range once in Name Manager, and every formula that references it updates automatically. No need to do a find-and-replace, no manual edits across 40 formulas.

• Fewer errors: Hard-coded cell references break when rows or columns shift. Named ranges reduce that risk considerably.

How to Open Name Manager in Excel

There are two ways to open the Name Manager:

• Ribbon Path: Go to the Formulas tab → Defined Names group → Name Manager.
• Keyboard Shortcut: Press Ctrl + F3 on your keyboard. This is important to save time.

How to Create a Named Range in Excel Name Manager

Here are the steps to create a named range in Excel:

Step 1: Open Name Manager

To open the name manager, press Ctrl + F3 or go to the Formulas tab → Name Manager.

Step 2: Click New

In the Name Manager dialog, click the New button. A smaller New Name dialog box appears.

Step 3: Enter a Name

In the Name field, type a name that is easy to understand. For example: Total_Sales

It’s a good time to mention there are some naming rules to follow:

• No spaces allowed (use underscores instead: Total_Sales not Total Sales).

• The name must begin with a letter, underscore (_), or backslash (\).

• The name cannot look like a cell reference (e.g., A1).

• Names are not case-sensitive (salesdata and SalesData are treated as the same name at the same scope).

• The maximum length is 255 characters.

Step 4: Set the Scope

Choose whether the name is available across the entire Workbook or limited to a specific Worksheet. More on this below.

Step 5: Add a Comment (Optional)

A short note explaining what the range represents saves future confusion, especially in shared workbooks.

Step 6: Define the Cell Reference

In the Refers To field, enter the cell reference or formula. You can type it manually or click the small arrow icon to select cells directly on the sheet.

For a range of cells:

=Sheet1!$A$2:$A$8

For a single constant value (e.g., a fixed discount rate):

=0.075

For a formula:

=SUM(Sheet1!$A$2:$A$8)

Step 7: Click OK

Click OK to save the name. It now appears in the Name Manager list and can be used in any formula within its scope.

For example, before naming:

=IF(D2 > 50000, D2 * 0.15, D2 * 0.10)

After naming D2 as Annual_Income and defining High_Tax_Rate = 0.15 and Low_Tax_Rate = 0.10:

=IF(Annual_Income > 50000, Annual_Income * High_Tax_Rate, Annual_Income * Low_Tax_Rate)

The logic is immediately clear, even to someone reading the formula for the first time.

How to Edit a Name in Excel Name Manager

Your data might change, the range of calculations might expand, or the business logic might shift, which is fine because with Excel Name Manager, you can make edits. Here are the steps to edit a Name in the Excel Name Manager:

• Open Name Manager (Ctrl + F3)
• Select the name you want to change from the list
• Click Edit
• Modify the Name, Comment, or Refers To field as needed
• Click OK, then Close

This editing is very useful when:

• Your source data moved: If the sheet was reorganised and the data now starts at row 5 instead of row 2, update the reference from $A$2:$A$100 to $A$5:$A$103.

• Your workbook expanded: A range that once covered 100 rows might now need to cover 500. Edit the Refers To field, and every formula that uses that name updates at once.

• Your formula logic changed: If a named formula like =Revenue - COGS now needs to account for returns, you can update the formula directly in the Name Manager without touching each cell.

One important thing you should note is that you cannot change a name's scope after creation. Scope is locked once a name is saved. To change it, delete the name and recreate it with the correct scope.

How to Delete Named Ranges in Excel

If a name is no longer needed, here is how to delete it:

• Open the Name Manager (Ctrl + F3)
• Select the name to remove (hold Ctrl to select multiple names)
• Click Delete
• Confirm when prompted

I would recommend that you carefully review your formulas well before hitting delete, because if a formula uses the name you deleted, Excel will return the #NAME? error and break your calculations across the entire workbook.

Workbook Scope vs. Worksheet Scope in Name Manager

Scope determines where a named range can be used. It is one of the most misunderstood parts of Name Manager.

• Workbook Scope: A workbook-scoped name is available on every sheet in the file. You can reference it from Sheet1, Sheet3, or any new sheet you add later. This is the default and the most common choice.
• Worksheet Scope: A worksheet-scoped name only works on the sheet it was defined for. If you try to use it on a different sheet, Excel cannot find it.

Scope also allows duplicates when used deliberately. Two named ranges can share the same name if they have different scopes. You could define Q1_Budget on Sheet1 and a separate Q1_Budget on Sheet2, where each is pointing to different cells. 

Within each sheet, the local name takes priority over any workbook-level name with the same label.

This design is useful when you build template-style workbooks where each sheet represents a different region, product, or time period.

Best Practices for Using Name Manager in Excel

There are a few things you must do to maintain an orderly Name Manager, and they are:

• Use a clear naming convention: CamelCase (SalesRevenue), snake_case (sales_revenue), or prefixes by type (rng_Sales, const_TaxRate, calc_NetProfit) works. Inconsistency is the problem.

• Keep names descriptive but concise: Q3_2024_North_Region_Gross_Revenue_Before_Adjustments is technically valid but practically useless. Make use of names that are easily understandable at a glance like Q3_North_Revenue.

• Avoid creating unnecessary names: Not every cell or range needs a name. Reserve named ranges for values that appear in multiple formulas, cells that change frequently, or references that would be confusing without context.

• Review names in large workbooks periodically: Workbooks accumulate stale names over time, ranges that point to deleted sheets, constants that no longer reflect reality, or duplicates from copy-paste operations. Open Name Manager every few months and clean out anything that no longer serves a purpose.

• Document important named formulas: Use the Comment field in Name Manager for any name whose purpose is not immediately obvious from its label. A note like "Used in monthly P&L summary, do not delete" takes ten seconds to write and saves real confusion later.

Excel Name Manager vs. Define Name

These sit side by side in the Formulas tab and could cause confusion, so here is the difference between them:

Conclusion

Name Manager is an Excel feature that may seem to be minor but proves to be very important. As mentioned earlier, named ranges make formulas readable, reduce errors, and make large workbooks far easier to maintain and share.

If you’re just starting out, start small: name your most-referenced ranges and constants, and build the habit from there. For more experienced users, Name Manager becomes a workbook hygiene tool that is worth reviewing regularly to keep things clean as models grow more complex.

If you want to take your Excel skills even further, check out our excellent resources:

• Data Analysis with Spreadsheets
• Excel Fundamentals
• Cleaning Data in Excel