Tracing Formula in Excel 2010

In this article I am going to explain about Tracing Formula in Excel 2010.
  • 2350

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


More Articles

© 2018 DotNetHeaven. All rights reserved.