How to Trace Dependents in Excel
A range of cells that shows how changing certain values in your formulas affect the results of those formulas and that makes it easy to calculate . Tracer arrow. An indicator that shows the relationship between the active cell and its related cell. To display a tracer arrow to each cell that directly provides data to the active cell. Click on the Formulas tab. In the Formula Auditing group click Trace Precedents. Display the relationships between formulas and cells and trace the relationships between these cells and formulas with tracer arrows, as shown in this figure.
To display a tracer arrow to each cell that directly provides data to the active cell. Click on the Formulas tab.
In the Formula Auditing group click Trace Precedents. Blue arrows show cells with no errors. Red arrows show cells that cause errors. If the selected cell is referenced by a cell on another worksheet or workbook a black arrow points from the selected cell to a worksheet icon.
How to show trace dependents or precedents arrow in Excel?
The other workbook must be open before Excel can trace these dependencies. If the other workbook is not open Excel may prompt you to locate and open it.
To identify the next level of cells that provide data to the active cell click Trace Precedents again. To remove tracer arrows one level at a time starting with the precedent cell farthest away from the active cell. To remove another level of tracer arrows click the button again.
Display the Relationships Between Formulas and Cells
To remove all the arrows Click on the Remove Arrows command once. Tracer arrows are arrows that can help you to understand the flow of data on a worksheet and can help you to understand formulas that contain lots of cell references. These can be used to help understand and visualise the relationships between cells.
Tracer arrows will disappear if you change the formula they point to or you insert or delete any rows or columns. There are 6 buttons on the Formula Auditing toolbar that can be used to add and remove tracer arrows from your worksheet.
Adding tracer arrows lets you visually step through which formulas refer to which cells. If a referenced cell contains a formula and that formula also contains an error, then a red line is drawn between the formula cells.
Tracer arrows are also known as "cell tracers" and are always in the direction of the data flow. Double clicking on any of the arrows you will be moved to the cell at the end of the arrow. The terms dependent and precedent refer to the relationships that cells containing references to other cells have. Remove All Arrows - Removes all tracer arrows from the worksheet. Tracing Dependent Cells Cells which contain formulas that refer to other cells are called dependents.
These are cells that use the value in the selected cell. A cell that has dependents can contain either a formula or a constant value. Trace Dependents - Draws a tracer arrow to the active cell from formulas that depend on the value in the active cell.
To add additional levels of indirect dependents, click the Trace Dependents button again.
Display the relationships between formulas and cells
If Excel beeps it means you have traced all the levels of the formula. Remove Dependent Arrows - Removes tracer arrows from one level of precedents on the active worksheet.
To remove the next level of arrows, click the Remove Dependent Arrows button again. The rate is in cell "C2". You can find out which cells refer to this value by selecting the cell and pressing the Trace Dependents button.
The arrows are pointing to all the cells that contain a formula that refers to cell "C2". The dot in cell C2 indicates that it has dependents. Pressing the Trace Dependents button again will display another set of arrows, indicating the next level of dependents or indirect dependencies. You can press the Remove Dependent Arrows button to remove one level of dependents.
Tracing Precedent Cells This allows you to trace cells in the opposite direction meaning you can start from a cell that contains a formula and trace back to all the cells that are referenced by that formula. Cells that are referred to by a formula in another cell are called precedents. These are cells whose values are used by the formula in the selected cell.