Trace error in Excel
Trace Error in Excel lets you trace arrows back to cells referenced by a formula if it displays an error.�
The Trace Error�tool is available when auditing a worksheet within a workbook.
Note that the formula cell that you select must contain an error to use the Trace Error tool in Excel.
Invalid or inaccurate cell referencing is often a common cause of formula errors within Excel worksheets.
Using the Trace Error tool in Excel shows you the cells referenced by a selected formula that contains an error message.
If the cell referencing turns out to be the reason why the formula will not function, you can then fix the cell references within the formula cell to correct the error.
The following example demonstrates the Trace Error feature.
In the above example, Cell C11 contains a formula: B11/A11.
But, since A11 has 0, it results in a DIV/0 Error.
Now,to trace error, the following steps are to be followed.
1.Select the formula cell with the error displayed in it.
2.Click the �Trace Error� drop-down button in the �Formula Auditing� button group on the �Formulas� tab in the Ribbon.
3.Then select the �Trace Error� command in the drop-down menu to draw arrows to the cells causing the error.