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.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. Click Trace Precedents in the Formula Auditing group.In the following example, the active cell is C2. Precedent cells are those cells that are referred to by a formula in the active cell. Repeat this step for all the workbooks you are auditing.Check that under For objects, show, All is selected.
In the Excel Options dialog box, click Advanced.You need to check whether the display options for the workbooks you are using are correctly set. Excel cannot go to a cell in a workbook that is not open. If your formulas refer to cells in a different workbook, open that workbook also. You can display all the formulas in the active worksheet with a single command. These findings are shown graphically by arrow lines that makes the visualization easy. Which formulas are referring to the active cell.Which cells are contributing in the calculation of a formula in the active cell.Excel Formula Auditing commands provide you an easy way to find You might want to check formulas for accuracy or find the source of an error.
0 kommentar(er)
