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

Formula Auditing 351
Figure 2-5:
Clicking the Trace Precedents command button a third time shows a precedent on another worksheet.
To find out exactly which workbook, worksheet, and cell(s) hold the direct precedents of cell C2, I double-clicked somewhere on the dotted arrow. (Clicking the icon with the worksheet miniature doesn’t do a thing.) Double- clicking the dotted tracer arrow opens the Go To dialog box, which shows a list of all the precedents, including the workbook, worksheet, and cell refer- ences. To go to a precedent on another worksheet, double-click the reference in the Go To list box, or select it and click OK. (If the worksheet is in another workbook, this workbook file must already be open before you can go to it.)
The Go To dialog box, shown in Figure 2-6, displays the following direct precedent of cell C2, which is cell B4 on Sheet2 of the same workbook:
‘[Error Tracing.xls]Sheet2’!$B$4
To jump directly to this cell, double-click the cell reference in the Go To dialog box.
You can also select precedent cells that are on the same worksheet as the active cell by double-clicking somewhere on the cell’s tracer arrow. Excel selects the precedent cell without bothering to open up the Go To dialog box.
Book III Chapter 2
Logical Functions and Error Trapping