Microsoft Office Tutorials and References

In Depth Information

**Checking formula references**

Checking formula references

When you create a formula that draws values from several

different places in your workbook—or from other workbooks—it

can be difficult to see what’s going wrong if your formula isn’t

producing the expected results. Excel helps you locate a cell’s

precedents (the cells that the formula uses in its calculation) and

dependents (the cells that depend on the current cell to

calculate their own values). To help you find what you need to check

your formulas, Excel groups all the tools that you need on the

Formula Auditing group on the Formulas tab.

Find cell precedents and dependents

1
Click the cell that you want to examine.

2
Click the Formulas tab.

3

2

3

Using the controls in the Formula Auditing group, follow either of

these steps:

a
Click Trace Precedents.

b

Click Trace Dependents.

1

Remove tracer arrows

1
Click the Formulas tab.

2
Click the Remove Arrows down arrow, and follow any of these steps:

a
Click Remove Arrows to remove all arrows.

b
Click Remove Precedent Arrows to remove the precedent arrows.

c
Click Remove Dependent Arrows to remove the dependent

arrows.

1

2

TIP Tracer arrows are particularly effective when they’re used

to examine formulas that include named ranges. When you

refer to a named range, you know what the indicated cells are

supposed to represent.