Tracing Formula in Excel 2010

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

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.

pres1.jpg

Step 2

On Formula tab click in Formula Auditing group click on Trance precedents.

pres2.jpg

Step 3

Then Formula precedents will be display.

pri3.jpg

Step 4

It we want to remove Formula precedents then we click on Remove precedents.

trecR.jpg

pres4.jpg

Ask Your Question 
 
Got a programming related question? You may want to post your question here
 

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.