Question: what is auditing formula in excel?
Answer: Excel Formula Auditing. ... Below are the various ways that you can audit a formula. Trace Precedents. Trace Precedents shows you all of the cells used to calculate a certain cell's value. When active, you see a blue box around the cells and an arrow showing the direction of information flow.