How to Find Hardcoded Values in Excel

A hardcoded value is a number typed straight into a cell or, worse, buried inside a formula like =Rev*1.05. These plug numbers are easy to lose track of and a common source of model errors. Here is how to surface them in Excel and review them before they bite you.

Find constant cells with Go To Special

Go To Special can select every cell that holds a typed number rather than a formula. This catches standalone constants but not numbers embedded in formulas.

1. Select the range you want to check, or press Ctrl+A to cover the whole sheet.
2. Press F5 to open Go To, then click Special.
3. Choose Constants, untick Text, Logicals, and Errors, and leave Numbers ticked.
4. Click OK. Excel selects every cell holding a typed number, which you can then color or review.

Spot embedded numbers with Find & Replace

The trickier hardcodes hide inside formulas. To hunt for a specific suspect number, press Ctrl+H, type the value in Find what, set Look in to Formulas, and click Find All. This works when you know what you are looking for, but it cannot list every formula that contains some constant.

Make hardcodes visible with color

Many modeling teams adopt a convention where inputs are blue and formulas are black. After selecting constants with Go To Special, color them blue so a typed-over assumption stands out instantly the next time someone opens the file. This is a habit worth enforcing, but it only flags whole-cell constants, not the plug inside =A1*0.93.

List every formula with a hardcode using ModelMint

The gap in all the native methods is the number tucked inside a formula. ModelMint Find Hardcodes scans your selection or sheet and lists every formula that contains a hardcoded number, such as =Rev*1.05 or =Sales-25000, so you can review each plug in one place and decide whether it belongs in an input cell instead.