How to find hardcoded numbers in Excel

Native steps checked against Microsoft Support on 16 November 2026 · updated 16 November 2026

To find hardcoded numbers in Excel, press Ctrl+G, choose Special, then select Constants and clear the text and logical options so only numbers are selected. Excel highlights every typed number in the range, which is where a review usually starts.

The native Excel method

  1. Select the range, the sheet or the whole workbook you want to check.
  2. Press Ctrl+G to open Go To, then choose Special.
  3. Select Constants, then untick Text, Logicals and Errors so only numbers are selected.
  4. Choose OK; Excel selects every cell with a typed number in the range.
  5. Repeat with Formulas ticked to compare the two populations.

How Go To Special works

Microsoft documents Go To Special as the way to select cells that contain specific types of data: constants, formulas, blanks, the current region, and more (Microsoft Support).

Constants is the option that matters for a hardcode hunt: it selects cells containing typed values rather than formulas. Cleared of text and logicals, what remains is every number a person typed into the model.

The limits of a selection

A selection tells you where the numbers are, not whether they belong. Assumption tabs are supposed to be full of typed numbers; a calculation block is not. Separating the two is a judgement about the model’s design, and Excel leaves that entirely to you.

The selection also does not group, count or export anything, so reviewing a workbook with a few hundred constants means clicking through them.

The quicker version

Formula mapping is the other native trick: colour every formula so the typed cells stand out visually. It is fast, and it leaves nothing behind to attach to a review note.

The CalcoraSuite way (planned)

The planned audit lists hardcoded inputs as findings — the cell, the surrounding pattern and the reason it was flagged — so the output can be exported and re-run after fixes. The model audit page carries its status.

The CalcoraSuite way

Planned, not released. The model audit page carries the current status of each step (planned).

  1. Run the audit on the workbook or a single sheet.
  2. Read the hardcoded-input findings, each with its cell reference and the pattern it breaks.
  3. Jump to a finding, fix it, then re-run to watch it drop off the list.

Sources

Every native step above was checked against these Microsoft pages on 16 November 2026.

Get the add-in before release

Early access testers get each add-in first, with a short list of what to try.