How to Find All Formulas in a Worksheet

Before you can trust a worksheet you need to know which cells calculate and which cells are just typed in. Knowing how to find all formulas in Excel lets you see the live structure of a model at a glance and catch the spots where someone overwrote a formula with a number.

Select every formula at once

Excel can highlight all formula cells on a sheet in one action using Go To Special. This is the fastest built-in way to see where the logic lives.

1. Press Ctrl+G to open Go To, then click Special.
2. Choose Formulas and leave all four subtypes ticked.
3. Click OK to select every formula cell on the sheet.
4. Apply a fill color while they are selected if you want a permanent map.

See the formulas instead of their results

Sometimes you want to read the formulas in place rather than just select them. Excel has a single toggle for this.

Press Ctrl plus the grave accent key (the grave accent, usually above Tab) to switch the whole sheet between showing results and showing formulas. Press it again to switch back. You can also use Show Formulas on the Formulas tab.

Tell formulas apart from typed values

Once formulas are selected, the cells left unselected are your inputs and constants. This contrast is what auditors care about, because a number sitting where a formula should be is a classic source of broken models.

A common failure is a row of formulas with one cell quietly overwritten by a typed figure. The pattern still looks consistent until you isolate the formulas and notice the gap.

• Selected cells calculate and update when inputs change.
• Unselected numeric cells are constants you can edit directly.
• A constant inside a block of formulas is worth a second look.
• Text labels and blanks are ignored by the formula selection.

The harder problem: numbers buried inside formulas

Selecting formula cells tells you which cells are formulas, but it cannot see a number typed inside a formula, such as =Revenue*1.08 where the 1.08 is a hidden assumption. Those constants never show up as separate cells, so Go To Special walks right past them.

These buried numbers are the most dangerous kind of hardcode because they look like clean formulas. Finding them by eye means opening every formula one at a time.

Surface every hardcode automatically

ModelMint Find Hardcodes scans the sheet and flags formulas that contain typed numbers, the assumptions hiding inside otherwise legitimate formulas. Instead of reading hundreds of formulas by hand, you get a list of exactly the cells where a constant was baked in.

Combined with the built-in formula selection, this gives you a full picture: which cells are formulas, which are inputs, and which formulas are quietly carrying their own numbers.

• Flags numeric literals embedded inside formulas.
• Skips legitimate references and clean inputs.
• Turns a manual formula-by-formula read into a single scan.
• Pairs with Go To Special for a complete audit of the sheet.