List All Formulas Used in Workbook

ASAP Utilities › Info & List › 12. List All Formulas Used in Workbook

This tool creates a detailed overview of all formulas used across the worksheets in your workbook. For each formula, the report shows:

Sheet: The worksheet where the formula is located.

Cell: The cell address containing the formula (clickable hyperlink to jump to the cell)

Value: The formula's calculated result

Displayed value: How the result appears in the cell, based on its number format

Formula: The actual formula text used in the cell This is useful for:

Auditing your workbook

Reviewing or documenting formulas

Finding and analyzing external references (e.g., formulas that link to other files)

Spotting inconsistencies or outdated formulas The report is generated in a new workbook, so you can save, sort, or filter the information without affecting your original file.

Screenshots

Info & List › 12 List All Formulas Used in Workbook

Starting this tool

Click ASAP Utilities › Info & List › 12. List All Formulas Used in Workbook
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Additional keywords for this tool:
formula audit, formula listing tool, Excel formula summary, cell formula extractor, document Excel formulas, Excel formula tracking, external links in formulas, identify workbook links, Excel formula mapping, list linked formulas, trace formulas to sheets, formula checker, Excel report formulas, workbook formula viewer

Choose your language preference below

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

List All Sheet Names in Workbook

Create a Visual Map of Cell Types in a New Workbook

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.