Tip of the Day | Wednesday February 11th, 2026

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

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.

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

©1999-2026 ∙ 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 26 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.