Cell Search
Find cells by what they are, not by their text. Cell Search sweeps a sheet or the whole workbook for a category of cells — every hardcoded input, every error, every volatile function, the most complex formulas — and lists the matches in a grid you can navigate, Pretty Print, or inspect. It is the find-by-attribute companion to the Risk Heatmap’s at-a-glance coloring.
The scenario
You’ve inherited a large model and need to find every place a risk hides: the typed numbers buried in formula areas, the #REF! errors, the volatile functions that recalc on every keystroke, the handful of genuinely complex formulas. Scrolling won’t do it. Cell Search lists exactly those cells so you can review — or flag — each one.
Where to find it
ModelXcel Pro tab → Audit group → Cell Search (keytip CS, screentip “Search by Attribute”).
Step by step
- Open Cell Search. A dialog opens for the active workbook.
- Choose a scope — the active sheet or the whole workbook — and tick one or more criteria (below), or type a function name to find. At least one criterion (or a function name) is required, or you’ll see “Select at least one criterion or enter a function name…”
- Run the search. Matching cells are listed in the results grid. An empty result reports “Search completed, no matching cells were found.”
- Act on a result. Double-click a row (or right-click → Navigate to Cell) to jump to and select it; right-click → TrustLens to inspect it, or Pretty Print Formula (also: double-click the Formula column) to read a long formula laid out. Copy the grid to the clipboard if you want the list elsewhere.
What you can search for
| Criterion | Finds |
|---|---|
| Errors | Cells evaluating to an Excel error (#DIV/0!, #REF!, #N/A, #VALUE!…). |
| Hardcoded constants | Number literals embedded inside formulas — the classic “magic number” audit flag. |
| Merged cells | Merged regions (which often break ranges and references). |
| Data validations | Cells carrying a data-validation rule. |
| Dynamic arrays | Spill formulas (FILTER, SORT, UNIQUE, SEQUENCE…). |
| Volatile functions | Formulas using NOW, TODAY, RAND, OFFSET, INDIRECT… that recalc on every change. |
| Complexity score ≥ N | Formulas at or above a complexity threshold you set. |
| Function name | Every cell whose formula calls a specific function you type. |
What changes in Excel
Nothing. Cell Search only reads the workbook and lists what it finds. Jumping to a result selects that cell (a navigation, not an edit); copying the results writes to the clipboard, not the workbook. No values, formulas, or styles change, and there is nothing to undo — close the dialog when you’re done.
How it pairs with the rest of the Audit group
- Use it to build a review punch-list, then Flag Cell the ones that need follow-up into Review Issues.
- It’s the precise, list-based counterpart to the Risk Heatmap’s Audit view — the heatmap colors the same kinds of cells at a glance; Cell Search enumerates and navigates them.
- Right-click → TrustLens takes a flagged cell straight into the inspector.
A finder, not a verdict
Cell Search tells you a cell is a hardcode, an error, or a complex formula — not whether that’s wrong. A hardcoded input may be entirely intentional. Treat the results as a list to review, and verify the ones that matter with Proof & Trust.
Caveats & limitations
- Read-only. It never changes cells; navigating selects, copying writes to the clipboard.
- At least one criterion. You must tick a criterion or enter a function name before searching.
- No matches? Widen the scope (whole workbook) or loosen the criteria — for example, lower the complexity threshold.
Related
- Risk Heatmap — color the same cell categories in the live grid.
- Model Health — workbook-wide counts of these same risk indicators.
- Review Issues & Flag Cell — log the cells you find.
- TrustLens — inspect a flagged formula cell.