See what feeds the formula and what the formula feeds before one small edit travels through a shared workbook
Use a decision–workbook-version–selected-cell–meaning–unit–precedent-level–dependent-level–arrow-colour–other-sheet-or-workbook–untraceable-item–change-impact–manual-test–review–release chain. Trace both directions before editing, read each relationship as a sentence and document where the visual map stops.
Why this English matters now
Reading Excel’s Trace Precedents and Dependents before changing a shared formula is practical English for students, researchers and analysts searching how to trace formulas in Excel, find which cells affect a formula or see which results depend on one cell.
Microsoft’s current guidance defines precedent cells as cells referred to by a formula and dependent cells as cells whose formulas refer to the selected cell. Trace Precedents looks upstream; Trace Dependents looks downstream; repeated clicks reveal additional levels where Excel can trace them.
Tracer arrows are a map of references, not proof that the model is correct. Strong readers preserve the workbook, state what the selected cell means, distinguish blue, red and black arrows, open required linked workbooks, record untraceable features and test the downstream results after any authorised change.
Checked against the linked first-party sources on 30 October 2026. Interfaces, managed-device rules and school procedures can change, so reopen the current source before a live assessment, disclosure or account decision.
The practical reading method
Use a decision–workbook-version–selected-cell–meaning–unit–precedent-level–dependent-level–arrow-colour–other-sheet-or-workbook–untraceable-item–change-impact–manual-test–review–release chain. Trace both directions before editing, read each relationship as a sentence and document where the visual map stops.
- Microsoft defines a precedent as a cell that provides data to a formula and a dependent as a cell containing a formula that refers to another cell.
- Microsoft says blue arrows show cells without errors, red arrows show cells causing errors and a black arrow can point through a worksheet icon to another worksheet or workbook.
- Microsoft says the other workbook must be open before Excel can trace those dependencies.
- Microsoft lists untraceable items, including text boxes, embedded charts or pictures, PivotTable reports, named constants and certain formulas in closed workbooks.
Official factual floor
- Microsoft Support: Display the relationships between formulas and cells
- Microsoft Support: Evaluate a nested formula one step at a time
- MOE English Language Syllabus 2020
- IMDA Digital Skills for Life
- Microsoft says Trace Precedents displays arrows to cells that directly provide data to the selected formula cell, and additional clicks can reveal more levels.
- Microsoft says Trace Dependents displays arrows to formulas that depend on the selected cell, with additional levels available where traceable.
- Microsoft says arrows disappear after some formula, row, column or cell changes and must be generated again.
Did You Know?
The same cell can be both a dependent and a precedent. A subtotal may depend on raw inputs while also feeding a final grade, budget or chart, so tracing only one direction can miss half of the impact story.
Full chapter index
- 1. Name the decision behind the selected cell
- 2. Preserve a shared workbook copy
- 3. Read the formula before the arrows
- 4. Read precedents as upstream providers
- 5. Reveal additional precedent levels
- 6. Read dependents as downstream users
- 7. Reveal additional dependent levels
- 8. Interpret arrow colours carefully
- 9. Follow worksheet and workbook icons
- 10. Document untraceable items
- 11. Predict the impact before editing
- 12. Regenerate arrows after changes
- 13. Verify the exact shared workbook
The mechanism
A reference map is useful only when the cell’s real-world meaning is known.
Microsoft defines a precedent as a cell that provides data to a formula and a dependent as a cell containing a formula that refers to another cell. In this chapter, the decisive phrase is name the decision behind the selected cell. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: The team traces G18 without knowing whether it is a raw score, weighted score or final grade.
Tracer arrows show reference relationships Excel can currently display. They do not prove that inputs are authoritative, directions are causally meaningful, units match, every external link is open, hidden code is harmless or the formula implements the correct academic or business rule.
- 1. state the label
- 2. state the unit
- 3. state the time period
- 4. identify the accountable owner
Save a controlled copy; state the selected cell’s meaning and unit; inspect its formula; trace precedents level by level; trace dependents level by level; read arrow colours and worksheet icons; open authorised linked workbooks; record untraceable items; capture the map; make one approved change; recalculate; compare downstream outputs; remove and regenerate arrows; save, close, reopen and verify the exact shared workbook. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook, sheet, cell and unit, formula, direct and indirect precedents, direct and indirect dependents, arrow colours, other-sheet and workbook references, closed links, untraceable items, intended change, predicted impacts, observed impacts, reviewer and final file identity.
Transfer: Purpose language supports spreadsheet reasoning. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
The formula text reveals operators, ranges and functions that arrows alone do not explain.
Microsoft says the other workbook must be open before Excel can trace those dependencies. In this chapter, the decisive phrase is read the formula before the arrows. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A total is traced without noticing that the range excludes the final row.
Tracer arrows show reference relationships Excel can currently display. They do not prove that inputs are authoritative, directions are causally meaningful, units match, every external link is open, hidden code is harmless or the formula implements the correct academic or business rule.
- 1. expand the formula bar
- 2. name every range
- 3. check absolute and relative references
- 4. translate the rule into a sentence
Save a controlled copy; state the selected cell’s meaning and unit; inspect its formula; trace precedents level by level; trace dependents level by level; read arrow colours and worksheet icons; open authorised linked workbooks; record untraceable items; capture the map; make one approved change; recalculate; compare downstream outputs; remove and regenerate arrows; save, close, reopen and verify the exact shared workbook. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook, sheet, cell and unit, formula, direct and indirect precedents, direct and indirect dependents, arrow colours, other-sheet and workbook references, closed links, untraceable items, intended change, predicted impacts, observed impacts, reviewer and final file identity.
Transfer: Formula language supports mathematics. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Precedents are cells referred to by the selected formula.
Microsoft lists untraceable items, including text boxes, embedded charts or pictures, PivotTable reports, named constants and certain formulas in closed workbooks. In this chapter, the decisive phrase is read precedents as upstream providers. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A constant assumption and a measured value are both called inputs without distinguishing their evidence status.
Tracer arrows show reference relationships Excel can currently display. They do not prove that inputs are authoritative, directions are causally meaningful, units match, every external link is open, hidden code is harmless or the formula implements the correct academic or business rule.
- 1. click Trace Precedents
- 2. list direct providers
- 3. state what each contributes
- 4. label assumptions and observations
Save a controlled copy; state the selected cell’s meaning and unit; inspect its formula; trace precedents level by level; trace dependents level by level; read arrow colours and worksheet icons; open authorised linked workbooks; record untraceable items; capture the map; make one approved change; recalculate; compare downstream outputs; remove and regenerate arrows; save, close, reopen and verify the exact shared workbook. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook, sheet, cell and unit, formula, direct and indirect precedents, direct and indirect dependents, arrow colours, other-sheet and workbook references, closed links, untraceable items, intended change, predicted impacts, observed impacts, reviewer and final file identity.
Transfer: Source language supports evidence. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Repeated tracing can show cells that feed the direct providers.
Microsoft defines a precedent as a cell that provides data to a formula and a dependent as a cell containing a formula that refers to another cell. In this chapter, the decisive phrase is reveal additional precedent levels. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: Only the first level is checked, while an upstream lookup uses an outdated table.
Tracer arrows show reference relationships Excel can currently display. They do not prove that inputs are authoritative, directions are causally meaningful, units match, every external link is open, hidden code is harmless or the formula implements the correct academic or business rule.
- 1. trace another level
- 2. record the new path
- 3. stop and inspect high-risk branches
- 4. note when Excel beeps or cannot continue
Save a controlled copy; state the selected cell’s meaning and unit; inspect its formula; trace precedents level by level; trace dependents level by level; read arrow colours and worksheet icons; open authorised linked workbooks; record untraceable items; capture the map; make one approved change; recalculate; compare downstream outputs; remove and regenerate arrows; save, close, reopen and verify the exact shared workbook. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook, sheet, cell and unit, formula, direct and indirect precedents, direct and indirect dependents, arrow colours, other-sheet and workbook references, closed links, untraceable items, intended change, predicted impacts, observed impacts, reviewer and final file identity.
Transfer: Level language supports structured review. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Dependents are formulas that refer to the selected cell.
Microsoft says blue arrows show cells without errors, red arrows show cells causing errors and a black arrow can point through a worksheet icon to another worksheet or workbook. In this chapter, the decisive phrase is read dependents as downstream users. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A source value is corrected without noticing it drives a dashboard and submission summary.
Tracer arrows show reference relationships Excel can currently display. They do not prove that inputs are authoritative, directions are causally meaningful, units match, every external link is open, hidden code is harmless or the formula implements the correct academic or business rule.
- 1. click Trace Dependents
- 2. list direct consumers
- 3. state their purpose
- 4. identify published outputs
Save a controlled copy; state the selected cell’s meaning and unit; inspect its formula; trace precedents level by level; trace dependents level by level; read arrow colours and worksheet icons; open authorised linked workbooks; record untraceable items; capture the map; make one approved change; recalculate; compare downstream outputs; remove and regenerate arrows; save, close, reopen and verify the exact shared workbook. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook, sheet, cell and unit, formula, direct and indirect precedents, direct and indirect dependents, arrow colours, other-sheet and workbook references, closed links, untraceable items, intended change, predicted impacts, observed impacts, reviewer and final file identity.
Transfer: Impact language supports responsible editing. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Downstream effects can continue through intermediate cells.
Microsoft says the other workbook must be open before Excel can trace those dependencies. In this chapter, the decisive phrase is reveal additional dependent levels. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: The first dependent is a subtotal, but its final report and chart are never inspected.
Tracer arrows show reference relationships Excel can currently display. They do not prove that inputs are authoritative, directions are causally meaningful, units match, every external link is open, hidden code is harmless or the formula implements the correct academic or business rule.
- 1. trace another level
- 2. follow critical branches
- 3. identify decision-facing outputs
- 4. record the stopping point
Save a controlled copy; state the selected cell’s meaning and unit; inspect its formula; trace precedents level by level; trace dependents level by level; read arrow colours and worksheet icons; open authorised linked workbooks; record untraceable items; capture the map; make one approved change; recalculate; compare downstream outputs; remove and regenerate arrows; save, close, reopen and verify the exact shared workbook. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook, sheet, cell and unit, formula, direct and indirect precedents, direct and indirect dependents, arrow colours, other-sheet and workbook references, closed links, untraceable items, intended change, predicted impacts, observed impacts, reviewer and final file identity.
Transfer: Consequence language supports planning. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Microsoft distinguishes blue normal references, red error-causing references and black cross-sheet or workbook routes.
Microsoft lists untraceable items, including text boxes, embedded charts or pictures, PivotTable reports, named constants and certain formulas in closed workbooks. In this chapter, the decisive phrase is interpret arrow colours carefully. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A red arrow is called a formatting problem instead of evidence that an upstream cell causes an error.
Tracer arrows show reference relationships Excel can currently display. They do not prove that inputs are authoritative, directions are causally meaningful, units match, every external link is open, hidden code is harmless or the formula implements the correct academic or business rule.
- 1. record the colour
- 2. open the related cell
- 3. read the error type
- 4. avoid treating colour as a complete diagnosis
Save a controlled copy; state the selected cell’s meaning and unit; inspect its formula; trace precedents level by level; trace dependents level by level; read arrow colours and worksheet icons; open authorised linked workbooks; record untraceable items; capture the map; make one approved change; recalculate; compare downstream outputs; remove and regenerate arrows; save, close, reopen and verify the exact shared workbook. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook, sheet, cell and unit, formula, direct and indirect precedents, direct and indirect dependents, arrow colours, other-sheet and workbook references, closed links, untraceable items, intended change, predicted impacts, observed impacts, reviewer and final file identity.
Transfer: Visual vocabulary supports diagnosis. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
A black arrow and worksheet icon can indicate a relationship beyond the current sheet.
Microsoft defines a precedent as a cell that provides data to a formula and a dependent as a cell containing a formula that refers to another cell. In this chapter, the decisive phrase is follow worksheet and workbook icons. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: The reviewer sees the icon but reports that the model has no external source.
Tracer arrows show reference relationships Excel can currently display. They do not prove that inputs are authoritative, directions are causally meaningful, units match, every external link is open, hidden code is harmless or the formula implements the correct academic or business rule.
- 1. double-click the arrow
- 2. read the Go To list
- 3. open the authorised destination
- 4. record workbook and sheet names
Save a controlled copy; state the selected cell’s meaning and unit; inspect its formula; trace precedents level by level; trace dependents level by level; read arrow colours and worksheet icons; open authorised linked workbooks; record untraceable items; capture the map; make one approved change; recalculate; compare downstream outputs; remove and regenerate arrows; save, close, reopen and verify the exact shared workbook. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook, sheet, cell and unit, formula, direct and indirect precedents, direct and indirect dependents, arrow colours, other-sheet and workbook references, closed links, untraceable items, intended change, predicted impacts, observed impacts, reviewer and final file identity.
Transfer: Location language supports traceability. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Microsoft lists objects and references the auditing tools do not trace.
Microsoft says blue arrows show cells without errors, red arrows show cells causing errors and a black arrow can point through a worksheet icon to another worksheet or workbook. In this chapter, the decisive phrase is document untraceable items. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: No arrow appears, so a PivotTable or named constant is assumed irrelevant.
Tracer arrows show reference relationships Excel can currently display. They do not prove that inputs are authoritative, directions are causally meaningful, units match, every external link is open, hidden code is harmless or the formula implements the correct academic or business rule.
- 1. read the documented limitations
- 2. inventory charts and PivotTables
- 3. inspect names and links separately
- 4. state what remains unknown
Save a controlled copy; state the selected cell’s meaning and unit; inspect its formula; trace precedents level by level; trace dependents level by level; read arrow colours and worksheet icons; open authorised linked workbooks; record untraceable items; capture the map; make one approved change; recalculate; compare downstream outputs; remove and regenerate arrows; save, close, reopen and verify the exact shared workbook. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook, sheet, cell and unit, formula, direct and indirect precedents, direct and indirect dependents, arrow colours, other-sheet and workbook references, closed links, untraceable items, intended change, predicted impacts, observed impacts, reviewer and final file identity.
Transfer: Limit language supports honest reporting. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
A trace becomes a test plan when expected downstream changes are written in advance.
Microsoft says the other workbook must be open before Excel can trace those dependencies. In this chapter, the decisive phrase is predict the impact before editing. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: A threshold cell is changed and every movement is accepted as intended.
Tracer arrows show reference relationships Excel can currently display. They do not prove that inputs are authoritative, directions are causally meaningful, units match, every external link is open, hidden code is harmless or the formula implements the correct academic or business rule.
- 1. state the proposed edit
- 2. predict which dependents should change
- 3. predict which should not
- 4. define acceptable differences
Save a controlled copy; state the selected cell’s meaning and unit; inspect its formula; trace precedents level by level; trace dependents level by level; read arrow colours and worksheet icons; open authorised linked workbooks; record untraceable items; capture the map; make one approved change; recalculate; compare downstream outputs; remove and regenerate arrows; save, close, reopen and verify the exact shared workbook. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook, sheet, cell and unit, formula, direct and indirect precedents, direct and indirect dependents, arrow colours, other-sheet and workbook references, closed links, untraceable items, intended change, predicted impacts, observed impacts, reviewer and final file identity.
Transfer: Hypothesis language supports testing. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
The mechanism
Microsoft says some structural and formula edits remove tracer arrows.
Microsoft lists untraceable items, including text boxes, embedded charts or pictures, PivotTable reports, named constants and certain formulas in closed workbooks. In this chapter, the decisive phrase is regenerate arrows after changes. It identifies the state or boundary to check before a click, upload, disclosure or connection turns an assumption into a real consequence.
A practical school or study situation
Example: Old screenshot arrows are treated as the current dependency map after columns were inserted.
Tracer arrows show reference relationships Excel can currently display. They do not prove that inputs are authoritative, directions are causally meaningful, units match, every external link is open, hidden code is harmless or the formula implements the correct academic or business rule.
- 1. remove arrows deliberately
- 2. make the authorised change
- 3. trace again
- 4. compare the new map with the recorded baseline
Save a controlled copy; state the selected cell’s meaning and unit; inspect its formula; trace precedents level by level; trace dependents level by level; read arrow colours and worksheet icons; open authorised linked workbooks; record untraceable items; capture the map; make one approved change; recalculate; compare downstream outputs; remove and regenerate arrows; save, close, reopen and verify the exact shared workbook. Then name the remaining uncertainty. A successful click is evidence about one operation at one time; it is not an unlimited promise about safety, authorship, privacy, delivery or future behaviour.
Build a reproducible note
Record workbook, sheet, cell and unit, formula, direct and indirect precedents, direct and indirect dependents, arrow colours, other-sheet and workbook references, closed links, untraceable items, intended change, predicted impacts, observed impacts, reviewer and final file identity.
Transfer: Change language supports auditability. The transferable habit is to preserve exact nouns and verbs, match them to authority and test the resulting state. That is a career skill as much as an English skill.
Four useful discoveries
Name the decision behind the selected cell
A reference map is useful only when the cell’s real-world meaning is known.
Boundary: A well-labelled cell can still use the wrong rule.
Preserve a shared workbook copy
Tracing is read-only, but the work usually precedes an edit that can affect many results.
Boundary: Copies can diverge from the current shared source.
Read the formula before the arrows
The formula text reveals operators, ranges and functions that arrows alone do not explain.
Boundary: A syntactically valid formula can still be conceptually wrong.
Read precedents as upstream providers
Precedents are cells referred to by the selected formula.
Boundary: Reference direction does not establish causation.
Practice with realistic decisions
Reveal additional precedent levels
Only the first level is checked, while an upstream lookup uses an outdated table.
- trace another level
- record the new path
- stop and inspect high-risk branches
- note when Excel beeps or cannot continue
Read dependents as downstream users
A source value is corrected without noticing it drives a dashboard and submission summary.
- click Trace Dependents
- list direct consumers
- state their purpose
- identify published outputs
Reveal additional dependent levels
The first dependent is a subtotal, but its final report and chart are never inspected.
- trace another level
- follow critical branches
- identify decision-facing outputs
- record the stopping point
Advice for students, families and educators
For students
- Explain every arrow as a sentence: this cell provides data to that formula.
- Trace both directions before changing a shared formula.
For families
- Ask what the cell means and who uses it, not only whether the number looks right.
- Encourage a copy before workbook edits.
For educators
- Include one other-sheet reference and one untraceable feature in practice tasks.
- Assess the stated limits and downstream test, not only a screenshot of arrows.
Frequently asked questions
What is a precedent?
A cell referred to by a formula in another cell.
What is a dependent?
A cell containing a formula that refers to the selected cell.
What do blue arrows mean?
References without errors in Microsoft’s tracer display.
What do red arrows mean?
References associated with cells causing errors.
What does a black arrow mean?
A route involving another worksheet or workbook through a worksheet icon.
Why click Trace again?
To reveal another level where Excel can trace it.
Why does Excel beep?
Microsoft says all levels may be traced or the item may be untraceable.
Do closed workbooks matter?
Yes; some cross-workbook dependencies require the other workbook to be open.
What should I verify?
Meaning, formula, both directions, levels, colours, external routes, limits, impacts and exact file.
Why English?
Because precedent, dependent, direct, indirect, error, external and untraceable name different relationships.
Useful next reading
- Excel Evaluate Formula — follow one selected formula’s intermediate calculations
- Excel Watch Window — monitor important cells while testing a change
- Why English Matters in Singapore — connect precise spreadsheet explanation to study and careers
Closing thought
A shared formula is part of a network. Read upstream before trusting the input, read downstream before changing the output path and document the places where Excel’s arrows stop so the workbook can be reviewed honestly.