Tip of the Day | Tuesday 6 October 2026

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.

Starting this tool