![best trace precedents excel tool best trace precedents excel tool](https://keyskillset.com/wp-content/uploads/2020/04/Audit1.png)
1+0.2 is underlined showing it as the next step. The expression with an underline will always be executed next. By clicking the Evaluate button several times, the formula gets evaluated step-wise. In the Evaluate Formula dialog box, the formula is displayed in the box under Evaluation. Click Evaluate Formula in the Formula Auditing group.To find how a complex formula in a cell works step by step, you can use Evaluate Formula command.Ĭonsider the formula NPV (Middle Year) in the cell C14. The worksheet containing that precedent appears. The reference appears in the Reference box.Click a reference of one of the precedents.A Go TO dialog box appears, showing the precedents.Īs you observe, there are four precedents, on four different worksheets.
![best trace precedents excel tool best trace precedents excel tool](http://1.bp.blogspot.com/-ZKU4dl_THuE/U3I4rw8baGI/AAAAAAAAJ6s/Vk9G1Dy7ADI/s1600/Audit2.png)
The worksheet icon indicates that the precedents are in a different worksheet.ĭouble-click on the arrow. A worksheet icon appears at the end of the arrow. The Formulas in the worksheet will appear, so that you will know which cells contain formulas and what the formulas are.Ĭlick Trace Precedents. The worksheet below contains the summary of sales by the salespersons in the regions East, North, South, and West.Ĭlick Show Formulas in the Formula Auditing group. All the cells under Pass Category in Exam Results table will be mapped as the dependents. Repeat for all the cells under Pass Category in Exam Results table.Ĭlick in a cell under Pass Category in Student Grades table.Ĭlick Trace Dependents.The cell to its left (Marks) and the range E4:F8 will be mapped as the precedents. Click in a cell under Pass Category in Exam Results table.Now, consider a worksheet with several formulae. You have understood the concept of Precedents and Dependents. Click Trace Dependents in the Formula Auditing group.Click in the cell B6 is not referenced by any formula or click in any empty cell.Otherwise, you will get an error message. Note − For tracing dependents of a cell, the cell should be referenced by a formula in another cell. All the arrows in the worksheet will disappear. Click the Formula tab > Trace Dependents in the Formula Auditing group.Īnother arrow appears from C4 to C2, showing C2 is dependent on C4 also.Ĭlick Remove Arrows in the Formula Auditing group.Click Trace Dependents in the Formula Auditing group.Īn arrow appears from B2 to C2, showing C2 is dependent on B2.Therefore, C2 is a dependent cell on the cells B2 and C4 In the example below, C2 has the formula =B2*C4. That means, if the active cell contributes to a formula in another cell, the other cell is a dependent cell on the active cell. Tracing Dependentsĭependent cells contain formulas that refer to other cells. Click in a cell that does not contain a formula or click in an empty cell.Ĭlick Remove Arrows in the Formula Auditing group.Īll the arrows in the worksheet will disappear.
![best trace precedents excel tool best trace precedents excel tool](https://image.slidesharecdn.com/usingtracearrows-110716113809-phpapp01/95/using-trace-arrows-in-excel-3-728.jpg)
Note that for tracing precedents of a cell, the cell should have a formula with valid references. Two arrows, one from B2 to C2 and another from C4 to C2 will be displayed, tracing the precedents.