How to Delete a Named Cell Range in Excel Correctly

In Excel for Microsoft 365 on Windows, open Formulas > Name Manager, select the defined name, choose Delete, and confirm. This removes the name—not the cells, values, or formulas it refers to.

What a named range is—and what deleting it means

A named range is a label that refers to one cell, a group of cells, or sometimes a formula or constant. For example, a workbook might use the name SalesData for cells B2:B100. Formulas can then refer to SalesData instead of using the address B2:B100, which may make a workbook easier to read and maintain.

Excel’s Name Manager lists these labels as defined names. People often call them named ranges even when a name refers to a formula rather than a literal block of cells. Removing a defined name removes that label and its association with the reference shown in the Refers to column. It does not clear or delete the referenced cells, shift rows, or remove the data itself.

This distinction matters when cleaning up a workbook. If a name called TaxRate refers to cell D2, deleting TaxRate leaves the value in D2 in place. Formulas that rely on the name, however, may no longer work. Check how the name is used before removing it.

Delete a name with Name Manager

Use Name Manager when you want to inspect the name, its scope, and its reference before deleting it. The Windows shortcut Ctrl+F3 opens Name Manager; the ribbon route is useful if you prefer to see the command in context.

Open the workbook and select the Formulas tab.
In the Defined Names group, select Name Manager. Alternatively, press Ctrl+F3 on Windows.
In the list, find the name you intend to remove. Check the Name, Scope, and Refers to columns so you select the right entry.
Select the row, choose Delete, and review Excel’s confirmation prompt.
Confirm the deletion, then choose Close to return to the worksheet.

For example, if you see SalesData with Refers to set to =Sheet1!$B$2:$B$100, deleting that entry removes the SalesData label. The values in B2:B100 remain where they are. If several entries have similar names, compare their scope and Refers to details rather than relying on the name alone.

You can also use the Name Box to jump to a named range: it is the box to the left of the formula bar, normally showing the active cell address. However, the Name Box is for navigating and selecting, not deleting names. Use Name Manager for removal.

Check the name’s scope before you delete it

A defined name can have workbook scope or worksheet scope. A workbook-scoped name is available throughout the workbook. A worksheet-scoped name is associated with one particular sheet, and the same text can sometimes be used for a different name on another sheet or at workbook level.

The Scope column in Name Manager identifies the scope. A worksheet-level entry might show a sheet name, while a workbook-level entry shows Workbook. If two rows appear to have the same name, they may not be duplicates: they can refer to different cells or apply in different contexts. Select the exact row you mean to delete.

Scope can affect which name a formula uses when names overlap. Deleting one entry may leave another entry with the same visible name, but formulas could still behave differently depending on the sheet and scope. Review the Refers to value for each matching entry before making a change. Name Manager lets you remove a name; it does not convert a worksheet-scoped name into a workbook-scoped one.

What happens to formulas and other workbook features

Deleting a name does not automatically rewrite every formula that used it. A formula that depends on the deleted name can show the #NAME? error because Excel can no longer resolve that label. For instance, if a formula used a workbook name called UnitPrice, removing UnitPrice can break that formula even though the cells that previously supplied the price are still present.

Defined names can also be used outside ordinary worksheet formulas. A name might be referenced in a chart series, a data-validation list, conditional formatting, or another workbook feature. Removing it can leave that feature with a broken or incomplete reference. If you are unsure whether a name is in use, treat it as a dependency and investigate before deleting it.

The Refers to column is a helpful clue about what the name points to, but it is not a complete list of every place that uses the name. Search the workbook for the name and inspect relevant formulas or settings. Search results can include ordinary text that happens to contain the same word, so verify each result rather than assuming every match is a dependency.

What to check before removing a name

Before deleting a name from an important workbook, identify its purpose and the likely impact. This is particularly worthwhile in shared templates, financial models, dashboards, and workbooks with data-entry rules.

Read Refers to: Confirm whether the name points to the expected cells, a formula, or a constant. A reference such as a sheet name and cell address can help you locate the underlying data.
Check the scope: Make sure you are removing the workbook-level or sheet-level entry you intended, especially when names are repeated.
Look for uses: Search formulas and inspect charts, validation rules, and formatting rules if the name might be used there.
Keep a recovery option: Save a separate copy of an important workbook before changing names. This is safer than relying on Undo, particularly if you make other edits afterward.
Consider collaborators: If other people use the workbook, check whether they depend on the name in their workflow or in linked documentation.

For a simple unused name that clearly refers to an obsolete range, deletion is usually straightforward. For a name used across a model, first decide whether the formulas should be updated to use direct cell references or a replacement name. Deleting the name without that follow-up can turn a tidy-up into a repair task.

Remove several names and handle unusual entries

Name Manager is designed for reviewing and managing defined names. To remove more than one, select the entries you want to delete in the list and choose Delete; if you are uncertain about multi-selection in your Excel build, remove names individually and confirm each selection. Avoid selecting the entire list just to remove one obsolete entry. Recheck the names and their references before confirming a group deletion.

Some workbooks contain names created by Excel or by other features, including names related to print areas. Do not assume every unfamiliar entry is disposable. A print-area name, for example, can control which cells are printed for a sheet. Removing a feature-related name may change workbook behavior even if no worksheet formula visibly refers to it.

There can also be hidden defined names that do not appear in the ordinary Name Manager list. If a workbook behaves as though an unavailable name still exists, or if an imported file contains unusual names, do not start deleting items blindly. Make a copy and use a trusted workbook-inspection method or ask the workbook’s creator to identify the entries. A routine cleanup usually does not require editing hidden names.

Windows, Mac, and Excel for the web

These steps are written for Excel for Microsoft 365 on Windows. On Windows, use Formulas > Name Manager or press Ctrl+F3. The Name Manager dialog provides the name list and the Delete command.

In Excel for Mac, use the Formulas tab and choose Name Manager; the ribbon is the clearest route if a Windows keyboard shortcut does not match your Mac keyboard or Excel setup. The dialog’s purpose is the same: select the defined name, delete it, and confirm. The exact placement of ribbon controls can vary with the app layout.

Excel for the web has a more limited set of workbook-management features than the desktop application, and available name-management controls can vary. If you cannot find a way to remove the required defined name in the browser, open the workbook in the desktop Excel app and use Name Manager. Be careful not to confuse deleting a defined name with deleting a sheet, table, or range of cells; those are separate operations.

Common problems and useful distinctions

The name is not in Name Manager. Check for a spelling difference, a worksheet-level entry, or a hidden name. Also confirm that you have opened the correct workbook. The Name Box may show a name for navigation, but it is not a complete substitute for reviewing the Name Manager list.

Excel says the name is invalid or a formula breaks afterward. The name may be used by formulas or other features. Restore the name from a saved copy if possible, or create an appropriate replacement and update the affected references. Do not invent a replacement reference: confirm which cells or calculation the workbook is meant to use.

You want to delete the cells, not the label. Name Manager is the wrong tool for that job. To remove worksheet contents, select the cells and use the appropriate Clear command; to remove cells and shift surrounding cells, use the worksheet’s delete-cell controls. Those actions affect the sheet and are distinct from removing a defined name.

You mean an Excel table name. A table name is not the same thing as a defined name for a range. To change a table’s name, select a cell in the table and use the Table Design tab’s Table Name box. Deleting a defined name in Name Manager does not delete the table or change its table name.

Frequently Asked Questions

Does deleting a named range delete the cells or their data?
No. It removes the defined name and its reference, but leaves the cells and their contents in place. To remove data, use worksheet editing commands instead.

Why do formulas show #NAME? after I delete a name?
Those formulas likely referred to the deleted name. Excel can no longer resolve that label, so the formula may return #NAME?. Restore the name or update the formula to use the correct replacement reference.

Can I delete a name using the Name Box?
No. The Name Box lets you select or navigate to a named range, but use Formulas > Name Manager to inspect and delete a defined name.

Can I delete a name from only one worksheet?
Yes, if it is a worksheet-scoped name. In Name Manager, check the Scope column and select the entry associated with the intended sheet. Names with the same text can exist at different scopes.

Is deleting a named range the same as deleting an Excel table?
No. A defined name is a label associated with a reference or formula; an Excel table is a structured data object. Removing a defined name does not remove or rename the table.

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.