Delete All Defined Range Names in Workbook

ASAP Utilities › Range › 26. Delete All Defined Range Names in Workbook

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

Note:
If a range name in your workbook 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 › 26. Delete All Defined Range Names in Workbook

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

Additional keywords to help you find this tool:
Remove range names in entire workbook, Clear all named ranges in Excel, Remove workbook defined names, Clear defined names, Delete named ranges across workbook, Reset defined names on all sheets, Clear workbook range names

Delete All Defined Range Names in Selection

Tip:Alt+P for the previous tool.

Delete Named Ranges with Invalid Cell References (#REF!)

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