Microsoft Excel has a very effective formula auditing tool, which is useful to track the relationship between cells and formulas. The formula auditing tool is located in the formulas tab under the Formula Auditing section where h Trace Precedents, Trace Dependents, Remove Arrows, Show Formula, Error Checking, & Evaluate Formulas are included.
Trace Precedents:Trace precedents is used to show an arrow to indicate the cells or ranges which affect the active cells value.
Trace Dependents:Trace Dependents is used to showan arrow to indicate the cells or ranges that are affected by the active cell. Remove Arrows:This is used to remove the arrows of “Trace precedents” and “Trace Dependents”.
Show Formula:This is used to show formula in cell instead of returningthe value.
Error Checking:Error checking is used to check if there is any error in the formula.
Evaluate Formula:This is used to check the formula step by step.
Let’s take an example to understand how you can move betweenprecedents and dependent cells.
Example 1: We have data in range A2:B11, in which column A contains “Agent List” and column B “Reporting Value”. Cell B8 containsthe total reporting value. Cell B10 containsthe No. of Agents. Cell B11 contains the Average Value of reporting values.
To use Trace Precedents
To use Trace Dependents
To remove the arrows
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.