- In short
- List the workbook's defined names (name, scope, refers-to, visibility). A named-ranges inventory block. The source table is left as it is and can be reversed in one step with Undo Last. Everything runs on your computer, with no internet involved.
What it is for
List Named Ranges is used to list the workbook's named ranges.
When to use it
It earns its place whenever you have to none.
Example scenarios
- None.
What it needs
An output cell. Supported data types: text, number, date (by selection).
How to use it
- Select the range to audit.
- On the XLMind Plus tab, open the Advanced Audit menu in the Formula Audit group and choose List Named Ranges.
- Confirm; a named-ranges inventory block.
What it produces
A named-ranges inventory block.
Effect on your data and undo
List Named Ranges does not change your source data; the result is added as a separate item. Undo Last reverses it whenever you need.
How it differs from similar tools
Compared with a hand-built formula setup there is nothing to maintain; the source table keeps its formulas and formats untouched.
Good to know
No special preconditions.
Limitations
No special preconditions.
Frequently asked questions
- Where does the result go?
- A named-ranges inventory block.
- Does the result stay linked to the source?
- What you get is static: it will not follow later edits, so rerun the tool once the data moves on.
- Any known limits?
- No special preconditions.
- Does it work offline?
- Yes. Everything runs on your computer; the internet is only needed for licensing and updates.
Works well with
- As a preparation step, try List External Link Formulas
- Afterwards, try List Hyperlinks
- As a complement, use Formula Map Summary
Your Excel data is processed on your own computer and is not shared with AI services. The limited data needed for licensing, sales and support is held on our infrastructure in Türkiye.