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.