Feature
Clean up your defined names before they cause silent errors
Broken or unused named ranges accumulate silently over a model's lifetime and can cause #REF! errors that are hard to trace back to their source.
What Formula Audit XL does
Ctrl+Shift+J audits every defined name in the workbook and flags broken, error, and unused names, with direct navigation and in-list deletion.
The problem with doing this in native Excel
- Excel's Name Manager has a Names With Errors filter, but it cannot show which names no formula uses
- The Names With Errors filter puts broken #REF! names in the same list as names with other error values
- The Name Manager does not show hidden names, so an old hidden name can stay in the file unnoticed
How Formula Audit XL does it
- 1 Press Ctrl+Shift+J. Open the Named Ranges auditor from any sheet. It scans every defined name in the workbook instantly.
- 2 Review flagged names. Each name appears with a status icon (broken, error, or unused) alongside its refers-to value. The problem names come first in the list, before the healthy ones.
- 3 Navigate and clean up. Click a name to jump to its range in the sheet. Select an obsolete name and delete it directly from the auditor panel, without opening the Name Manager.
Who needs this most
- Analysts inheriting large models with legacy names
- Finance teams preparing models for external distribution
- Auditors verifying formula references are well-defined
- Builders refactoring a model after structural changes
Named Ranges (Ctrl+Shift+J) gives you a status-aware view of every defined name in the workbook. Excel’s own Name Manager has a Names With Errors filter, but it cannot tell you which names no formula uses, and it does not show hidden names. This panel lists hidden names too, gives each name a status, and puts the problem cases at the top, so you can triage without scrolling through the whole list.
Cleanup is done in-panel: navigate to a range, verify it, and delete a redundant name without switching contexts.
Frequently asked questions
What counts as a broken named range?
Any name whose refers-to value resolves to a #REF! error, typically because the cells it pointed to, or the sheet that held them, have been deleted.
What counts as an unused named range?
A name that is defined in the workbook but that no worksheet formula uses. A name that only another name, a chart, data validation or a macro uses also shows as unused, so check those places before you delete it.
Can I delete names directly from the panel?
Yes. Select a name in the list and click Delete Name. The panel asks you to confirm, then removes the name from the workbook without opening Excel's Name Manager.
Does it work with workbook-scoped and sheet-scoped names?
Yes. Both workbook-level and sheet-level defined names are shown, with their scope clearly indicated.
Stop eyeballing models. Start auditing them.
For Microsoft Excel on Windows, Mac and the web · No data leaves your machine