Tracing Formula in Excel 2010
In this article I am going to explain about Tracing Formula in Excel 2010.
Tracing Formula in Excel 2010
Excel provide several hundred function that we can use in our document for calculation the data. But Sometime we want to know what other cell affected by a certain cell. In other word we can say that what other cell meet to complete the calculation result. Tracing formula is the properties by we can find the what the other cell meet to complete the calculation result.
To Trace Formula we have to follow following steps.
Step 1
Select cell that contain the formula result.
Step 2
On Formula tab click in Formula Auditing group click on Trance precedents.
Step 3
Then Formula precedents will be display.
Step 4
It we want to remove Formula precedents then we click on Remove precedents.
Ask Your Question
Got a programming related question? You may want to post your question here