Microsoft Office Tutorials and References
In Depth Information
Checking for Errors
Any formula that receives data is a dependent.
To find one or more formulas that a single cell might affect, follow these
steps:
1. Click any cell that contains data (not a formula).
2. Click the Formulas tab.
3. Click Trace Dependents.
Excel draws an arrow that points to a cell that contains a formula, as
shown in Figure 9-23. This tells you that if you change the data in the cell
you chose in Step 1, it will change the calculated result in the cell
containing a formula.
4. Click the Remove Arrows icon in the Formula Auditing group to make
the arrows go away.
Figure 9-23:
Excel can
identify
which
formulas a
particular
cell can
change.
Checking for Errors
If you create large worksheets with data and formulas filling rows and
columns, it can be hard to check to make sure that there aren’t any problems
with your spreadsheet, such as a formula dividing a number with a non-exis-
tent value in another cell.
Fortunately, Excel can catch many types of errors by following these steps:
1. Click the Formulas tab.
2. Click the Error Checking icon in the Formula Auditing group.
Search JabSto ::




Custom Search