Microsoft Office Tutorials and References
In Depth Information
Error Checking
Solving Formula
Errors
Figure 18-6:
Excel’s tracing
features work with any
formulas—whether or
not they contain an
error. But Excel also
includes a related
feature, Trace Error,
which works only with
formulas that result
in error values. When
you select a cell with
an error code, and
then choose Trace
Error, Excel traces all
the precedents that
lead back to the error
by using blue arrows.
Then, Excel uses red
arrows to indicate
how the error spread.
In this example, two
blue arrows show the
precedents of cell C2,
where the error
occurred. The error then
spread to cell H2 and,
finally, to the current
cell, H15.
To perform an error check, follow these steps:
1. Movetothepositionwhereyouwanttostarttheerrorcheck.
If you want to check the entire worksheet from start to finish, click the first cell.
Otherwise, go to the location where you want to start checking. As with a spell
check, Excel moves from column to column first, and then from row to row.
However, the error checker automatically loops back to the beginning of your
worksheet, making sure to check every cell before it stops.
Search JabSto ::




Custom Search