Tip of the Day | Sunday October 26th, 2025

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

List All Named Ranges in Workbook

This tool creates a detailed list of all named ranges in your workbook.

It generates a new workbook with a report that includes:

The name of each defined range

The sheet and cell reference the name refers to

The scope (workbook-level or worksheet-level, including the sheet name if applicable)

Any associated comments or descriptions

The visibility status (whether the name is visible or hidden)

This overview helps you:

Review and document all named ranges

Detect errors, duplicates, or broken references

Identify hidden names that may affect formulas or logic

Clean up unused or outdated names

Understand workbook structure for auditing or development

The report includes both visible and hidden names.
Hidden names are not shown in Excel's Name Manager but can still be used in formulas or accessed via VBA. This tool helps surface those names for full transparency.

Starting this tool

Click ASAP Utilities › Info & List › 10. List All Named Ranges in Workbook
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Info & List › List All Named Ranges in Workbook

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Yesterday's Tip

Tomorrow's Tip

Download

©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.