How to Delete Named Ranges in Excel

A named range is a friendly label for a cell or range, like Revenue or TaxRate. When the underlying data moves or a name is no longer used, you will want to remove it. Deleting named ranges is simple once you know where they live, but doing it safely means checking what still depends on them first.

Delete a named range in the Name Manager

The Name Manager is the single place to remove any named range in the workbook.

1. Press Ctrl+F3 to open the Name Manager.
2. Click the name you want to remove so its row is highlighted.
3. Click Delete, then confirm when Excel asks.
4. Click Close when you are finished.

Remove several named ranges together

To clear more than one at a time, open the Name Manager, click the first name, then hold Ctrl and click each additional name you want gone. With them all selected, click Delete once to remove the whole batch. To select a continuous block, click the first name and Shift-click the last. This is faster than deleting one by one, but the dialog still has no search field to find names quickly.

Check for dependents before you delete

Deleting a named range that is still referenced will break things. Any formula that used the name returns a #NAME? error, and data validation lists, charts, and conditional formatting rules that relied on it stop working silently. Before deleting, press Ctrl+F and search the workbook for the name, and scan your formulas so you know what will be affected.

Delete named ranges in bulk with ModelMint

When a workbook has dozens of obsolete names, Name Scrubber is faster than the native dialog. Type part of a name to filter the list, select everything you no longer need, and delete it in one action. It also flags broken #REF! names so you can clear the dead ones without hunting through the Name Manager.