# Clean up your defined names before they cause silent errors

> Ctrl+Shift+J audits every defined name in the workbook and flags broken, error, and unused names, with direct navigation and in-list deletion.

Page: https://formulaudit.com/features/named-ranges

Feature: Named Ranges Auditor

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.

## 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.

## FAQ

### 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.
