Calc Guide

To use the Detective, select a cell with a formula, then start the Detective. On the
spreadsheet, you will see lines ending in circles to indicate precedents, and lines
ending in arrows for dependents. The lines show the flow of information.
Use the Detective to assist in following the precedents referred to in a formula in a
cell. By tracing these precedents, you frequently can find the source of the errors.
Place the cursor in the cell in question and then choose Tools > Detective > Trace
Precedents from the menu bar or press Shift+F7. Figure 162 shows a simple
example of tracing precedents.
Cursor placed in cell
Figure 162: Tracing precedents using the Detective
Chapter 7 Using Formulas and Functions 185