logo ASAP Utilities
HomeExtra features for ExcelInfo & ListList All Named Ranges in Workbook

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu
Trustpilot

List All Named Ranges in Workbook

ASAP Utilities  › Info & List  ›  10. 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


    Info & List  ›  10 List All Named Ranges in Workbook
    Additional keywords for this tool:
    view defined names, export named ranges, show workbook names, workbook-level names, worksheet-level names, Excel name scope, hidden named ranges, audit named ranges Excel, Excel defined names report, range name visibility, named range list, name comments, formula names, list all names in Excel file
    Trustpilot
    Download  



    • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


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