Page 370 - Excel 2013 All-in-One For Dummies

352 Formula Auditing
Figure 2-6:
Double- clicking
the dotted tracer arrow opens the Go To dialog box showing the location.
You can use the Special button in the Go To dialog box (see Figure 2-6) to select all the direct or indirect precedents or the direct or indirect dependents that are on the same sheet as the formula in the selected cell. After opening the Go To dialog box (Ctrl+G or F5) and clicking the Special button, you simply click the Precedents or Dependents option button and then choose between the Direct Only and All Levels option buttons before you click OK.
Tracing dependents
You can click the Trace Dependents command button in the Formula Auditing group of the Formulas tab on the Ribbon or press Alt+MD to trace all the generations of cells that either directly or indirectly utilize the formula in the selected cell (kind of like tracing the genealogy of all your ancestors). Tracing dependents with the Trace Dependents command button is much like tracing precedents with the Trace Precedents command button. Each time you click this button, Excel draws another set of arrows that show
a generation of dependents further removed. To display both the direct and indirect dependents of a cell in one fell swoop, double-click the Trace Dependents command button.
Figure 2-7 shows what happened after I selected cell B9 and then double- clicked the Trace Dependents command button on the Formulas tab of the