Microsoft Office Tutorials and References
In Depth Information
Using Formula Auditing Arrows
33. Visually check the formula to ensure that it is correct.
Using Formula Auditing Arrows
Using Formula Auditing Arrows
If you have a complicated formula, you might want to identify direct preced-
ents and then possibly second- or third-level precedents. You can have Ex-
cel draw arrows from the current cells to all cells that make up the pre-
cedents for the current cell. To have Excel draw arrows, follow these steps:
11. From the Formula Auditing group on the Formulas tab, click Trace
Precedents. Excel draws arrows from the current cell to all the
cells that are directly referenced in the formula. For example, in
Figure 9.29 , an arrow is drawn to a worksheet icon near cell B30. This
indicates that at least one of the precedents for this cell is on an-
other worksheet.
Search JabSto ::




Custom Search