How to Delete a Defined Name in Excel (And When It Matters)

Defined names in Excel are incredibly useful — until they aren't. A spreadsheet that's been through multiple hands, formula rewrites, or data restructures often ends up with a graveyard of named ranges that no longer reference anything useful. Knowing how to find and delete them keeps your workbooks clean, your formulas reliable, and your error rate low.

What Is a Defined Name in Excel?

A defined name is a label assigned to a cell, range, formula, or constant in Excel. Instead of writing =SUM(B2:B50), you might write =SUM(MonthlySales) — where MonthlySales is a defined name pointing to that range.

Names can be created intentionally through the Name Box (the field to the left of the formula bar), via Formulas > Define Name, or automatically when you import data or use certain Excel features like tables and pivot tables.

Over time, a workbook can accumulate dozens of names — some still active, some pointing to deleted ranges, and some duplicated across sheets.

Why Delete a Defined Name?

There are a few common reasons to clean up defined names:

• Broken references — If the cells a name pointed to have been deleted, Excel may show #REF! errors or flag the name as referring to an invalid range.
• Workbook bloat — Large numbers of unused names can slow down calculation and increase file size in complex workbooks.
• Naming conflicts — Duplicate or similarly named ranges cause confusion and formula errors, especially in shared files.
• Inherited spreadsheets — Files passed between teams often contain names that made sense to the original author but are now meaningless or misleading.

How to Delete a Defined Name Using the Name Manager 🗂️

The Name Manager is the primary tool for viewing, editing, and deleting defined names. Here's how to access and use it:

1. Open your workbook in Excel.
2. Click the Formulas tab on the ribbon.
3. Click Name Manager (keyboard shortcut: Ctrl + F3).
4. A dialog box opens listing every defined name in the workbook, along with the value it currently references, its scope (workbook-wide or sheet-specific), and any comment.
5. Select the name you want to delete by clicking it.
6. Click the Delete button at the top of the dialog.
7. Confirm the deletion when prompted.
8. Click Close when finished.

To delete multiple names at once, hold Ctrl and click each name you want to remove before hitting Delete.

How to Filter Names Before Deleting

The Name Manager has a Filter dropdown (top right of the dialog) that helps you sort through names more efficiently. Filter options include:

Filtering for errors first is a practical starting point — these are almost always safe to delete and are the most likely source of formula problems.

Scoped Names: Workbook vs. Sheet Level

One important variable is whether a defined name is workbook-scoped or sheet-scoped.

• A workbook-scoped name is accessible from any sheet in the file and appears without a sheet prefix.
• A sheet-scoped name only applies to a specific worksheet and is listed with a prefix like Sheet1!SalesData.

This matters because two different sheets can have identically named but independently scoped names — deleting one doesn't delete the other. If you're troubleshooting formula errors after deletion and the problem persists, a duplicate sheet-scoped name may still be active.

What Happens When You Delete a Name That's Still in Use

This is where caution is necessary. If a defined name is actively referenced in a formula — say, =VLOOKUP(A1, CustomerList, 2, FALSE) — and you delete the name CustomerList, that formula will immediately return a #NAME? error.

Excel does not automatically convert the name back to its original cell reference. The formula simply loses its reference and breaks.

Before deleting any name, it's worth checking whether it's referenced in formulas. You can do this by:

• Using Ctrl + H (Find & Replace) to search for the name across all sheets.
• Clicking on the name in the Name Manager and reviewing the Refers To field to see what it currently points to.
• Using Formulas > Trace Dependents on cells within the named range.

Hidden and Auto-Generated Names

Some names aren't visible through normal use. Excel creates hidden names for features like Print Areas (stored as Print_Area), Print Titles, and certain legacy functions. These show up in the Name Manager with an underscore prefix or sheet scope notation.

Auto-generated table names (like Table1, Table2) also appear here. Deleting a table's structured reference name while the table still exists can disrupt any formulas that reference that table's columns. 🔍

How Skill Level and Workbook Complexity Change the Risk

For a personal workbook with a handful of names and no shared formulas, deleting unused names is low-risk and takes under a minute. For a workbook used across a team — with interconnected formulas, pivot tables pulling from named ranges, and macros referencing names via VBA — the same action can cascade into significant breakage.

The version of Excel also plays a role. Excel for Microsoft 365 and Excel 2019/2021 handle the Name Manager the same way, but Excel Online (the browser version) has a more limited Name Manager interface — you can view and delete names, but some filter options and bulk-selection features may not behave identically.

Whether a name is safe to delete depends entirely on how deeply it's woven into the workbook's structure, who else uses the file, and whether any downstream automation — macros, Power Query, or external connections — depends on it.