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.

excel trace error

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.

excel trace error

excel trace error


You can find similar Excel Questions and Answer hereunder

1) Is there a way I can average a range of numbers even if there is an error value in range?

2) How to handle errors in VBA with the handling error methods

3) One of my formulas has returned an error - how can I trace the error to fix it?

4) What are the different type of errors in Excel VBA, subscript out of range, compile error, time out, run time overflow

5) I have a cell with nested formulas that returns an error. In Excel, how can I step through the formulas to help with debugging?

6) You can find here the main error codes that happens in Excel VBA

7) How to use the trace error function in VBA

8) How to follow the changes of variable dynamically with the watch window in Excel

9) How to see to which cells a cell is connected or used by. How to see the dependents of a cell

10) How to see to which cells a cell is connected or used by. How to see the precedents of a cell


Here the previous and next chapter