To find broken references in Numbers on Mac, inspect cells showing a formula error, open each formula in the Formula Editor, and follow any error link to the cell causing the problem. Numbers’ Find & Replace search does not search inside formulas, so it cannot locate broken references by searching formula text. You’ll need to check flagged cells and trace their referenced tables, sheets, and cells.

Start with cells that show a formula error

Open the spreadsheet and look for a Syntax Error icon in a formula result cell. Click the icon to read the error message. If Numbers identifies another cell as the cause, click the cell reference in the message to select it. This is the most direct route when the spreadsheet already displays an error. Apple’s guide to calculating values in Numbers describes this error message and cell link.

A visible error is a useful clue, but it does not tell you whether the root cause is a deleted or incorrect reference, a missing function argument, or another formula problem. Read the message, then inspect the formula before changing anything. If you see incorrect results without an error icon, continue with a formula review; a wrong reference can still produce a valid calculation.

Inspect the formula and trace its references

Double-click the result cell to open the Formula Editor. Read the formula’s references, then compare them with the tables and sheets that currently exist in the document. Numbers formulas can refer to ranges, whole rows or columns, and cells in other tables or sheets. A reference such as Sheet 2::Table 1::C2:G2 includes the sheet, table, and cell range; the double colons separate those names. Apple’s formula reference documentation explains these reference formats.

Check each referenced name and range against the spreadsheet. Look for a renamed or absent table or sheet, a range that no longer includes the intended cells, or a formula that points to the wrong location. A reference may be valid but still logically wrong, so use the column headings and expected calculation to judge whether it points to the right data. Numbers does not provide a documented one-click command in this guide to scan the entire spreadsheet and report every bad reference; review formula cells with errors and investigate suspicious results individually.

Why Find & Replace won’t find a broken formula

Press Command-F or choose View > Show Find & Replace to search the spreadsheet. This search covers visible text across sheets, but Apple states that Numbers searches formula results and does not search within formulas. It also matches a cell’s displayed value rather than its underlying formula. Therefore, searching for a table name, sheet name, or reference string will not reliably find formulas that contain it. Apple’s Find and Replace guide documents this limitation.

Use Find & Replace to locate visible text or results when that is useful, but don’t treat an empty search result as proof that no formula refers to a missing or unintended location. To examine a formula, select its result cell and open the Formula Editor instead.

Correct the reference carefully

In the Formula Editor, select the cell addresses you need to change and select the intended cells, or place the insertion point in the function’s argument area and click the correct cells to add references. Press Return to commit the formula. Apple also documents selecting unwanted references and pressing Delete. Check the finished formula and result before moving on; changing a reference can alter a calculation even when the syntax is valid. Apple’s instructions for changing an existing formula cover these edits.

If the reference still appears structurally correct, confirm that it points to the right table and sheet and covers the intended rows or columns. Apple notes that adding a row within a referenced range in a categorized table may not automatically include that row in the formula’s result. That is a scope issue rather than necessarily a broken reference, but it can explain a total that seems incomplete.

Prevent reference surprises after edits

When moving formulas or inserting rows and columns, review formulas that depend on affected areas. Numbers can adjust unpreserved references when formulas are moved or rows and columns are added. If a formula should continue pointing to a fixed row or column when reused elsewhere, edit it and set the relevant reference to Preserve Row or Preserve Column; Command-K preserves both row and column for a selected range. These options control how references adjust, but they do not determine whether the chosen source data is correct. Apple’s formula guide explains reference preservation.

A practical review is to start with error icons, follow any linked cause, inspect the affected formula, and verify its source cells and intended range. Use Find & Replace only for visible content. This method helps you trace formula problems without assuming Numbers has a spreadsheet-wide broken-reference report.

Sources