Delete All Defined Range Names in Selection

ASAP Utilities › Range › 25. Delete All Defined Range Names in Selection

This tool removes all defined range names within your selected cells, helping you clean up your workbook by deleting unwanted or unused range names.

Note:
If a range name in your selection is used in a formula, removing it will cause that formula to return an error when the referenced name no longer exists.

Starting this tool

Click › Range › 25. Delete All Defined Range Names in Selection

Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Additional keywords to help you find this tool:
Remove defined names, Clear defined names from selected cells, Delete range names, Remove named ranges, Clear named ranges in Excel, Delete defined names, Reset defined names in selection

Replace Named Ranges in Formulas with Cell References

Tip:Alt+P for the previous tool.

Delete All Defined Range Names in Workbook

Tip: Alt+N for the next tool.

Designed by Excel users for Excel users.

Practical tools many Excel users wish were built into Excel.

Save Time in Excel. The Easy Way.

ASAP Utilities helps you save time and do what Excel alone can't.

You can get started right away. No training needed.

Most users start with a few tools. Many end up using ASAP Utilities daily.

Used by teams in 28,500+ organizations.

Get Started with ASAP Utilities

Start saving time in Excel with practical tools you can use right away.

Download See What You Can Do

No sign-up required.
Free 90-day trial