How to trace where a formula gets its numbers
Trace precedents in Grid by Zaweba draws arrows from the cells a formula reads, trace dependents shows what uses a cell, and error checking flags problems.
Select the formula cell and trace its precedents. In Grid by Zaweba, trace precedents draws arrows from every cell the formula reads to the formula itself, so you can see at a glance where its numbers come from. Trace dependents does the reverse, showing every formula that uses a given cell. Error checking and Show Formulas help with the rest.
When you need it
A workbook you didn't build, or one you built a year ago, can be a puzzle. A total looks wrong and you need to know what feeds it. You want to delete a column and need to know whether anything depends on it. An #REF! has appeared and you need to find its source. Tracing answers each of these without reading formulas cell by cell.
Tracing precedents step by step
Click the cell with the formula and choose trace precedents. Arrows appear from each cell or range the formula refers to. Run it again to go back another level, showing what feeds those cells in turn. A few clicks reveal the whole chain from raw figures to final answer.
If the formula reads cells on another sheet, the arrow points off the sheet, telling you the source is elsewhere. The formula itself shows the sheet name.
Remove the arrows when you're done, so they don't clutter the sheet.
Tracing dependents
Click a cell holding a value or formula and trace dependents. Arrows go from it to every formula that uses it. If none appear, nothing on the sheet depends on that cell, which tells you it's safe to change or delete. If lots appear, you know a change there will ripple widely.
Seeing references while editing
Editing a formula is another way to trace it. Press F2 or click into the formula bar and Grid draws a coloured box around each range the formula uses, in the same colour as the reference in the formula text. It's the quickest way to check that a SUM covers the right rows or that a lookup points at the right table.
Error checking and Show Formulas
Error checking points out cells with problems, taking you from one cell showing an error to the next. It's a good first pass over an unfamiliar workbook.
Show Formulas switches the whole sheet to display formulas instead of results. Scan down a column of what should be identical formulas and an odd one stands out, perhaps a total that someone typed over with a fixed number.
The status bar helps too. Select a range and it shows the Average, Count and Sum, so you can check a total by eye. It also warns about circular references, where a formula depends on its own result.
Making formulas easier to trace
Names help. A formula that reads Price times Quantity is clearer than one reading D2 times F2, and Name Manager lists every name and what it refers to.
Tables help too. Structured references such as Table1[Qty] say what column they mean.
Functions that build references from text, such as INDIRECT, are harder to trace because the reference is assembled while the formula runs. Use them sparingly.
If you've connected your own AI account to Grid, Explain this formula describes what a formula does in plain words, which pairs well with the arrows when a formula is long.
Tracing turns a spreadsheet from a wall of numbers into something you can follow. In Grid by Zaweba the arrows, coloured boxes and error checks are all there to help you trust the figures.
