Ampler highlights every cell that shares the selected cell’s formula, so you can audit a model by checking only its unique formulas instead of every cell.
Quick answer: Select a cell to audit and press F3 — Ampler marks every cell that carries the same formula, so identical cells can be checked once.
How to use it
Select a cell and press F3 to mark every cell with the same formula.
- Select a cell to audit.
- Press F3 to mark all cells that share the same formula.
Cells with an identical formula are highlighted as a group, so you audit the unique formulas rather than every cell.
Keyboard shortcut
F3 marks the matching formulas; other Ampler functions can be assigned shortcuts in Settings → Shortcuts.
Why use it
A large model has thousands of cells but far fewer distinct formulas — a formula dragged across a range is the same logic repeated. Marking every cell that shares a formula lets you audit each unique formula once, instead of clicking through identical cells.
How consultants use it
Auditing a financial model is a core consulting task, and doing it efficiently means checking the logic, not every cell. Three habits apply:
- Audit unique formulas: identical cells are checked once, not one by one.
- Spot the breaks: a cell that should share a formula but doesn’t stands out.
- Faster model review: a large model is audited in a fraction of the clicks.
Marking equal formulas turns a cell-by-cell audit into a logic review.
Tips & best practices
- Start from a representative cell in a filled range.
- Watch for cells that break the pattern — they’re where errors hide.
- Pair with Visualise formulas for a whole-sheet view.
Availability
Included in Ampler for Excel and the Ampler Suite, on Windows desktop Excel.
Frequently asked questions
How do you find all cells with the same formula in Excel?
Select a cell and press F3 with Ampler — it marks every cell that shares the same formula, so you can audit the unique ones once.
How do you audit a large model efficiently?
Use Ampler to mark cells that share a formula, so you check each unique formula once instead of clicking through every identical cell.
Why check only unique formulas?
Because a formula dragged across a range is the same logic repeated. Auditing the unique formulas covers the model’s logic far faster.