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.
Using the controls in the Formula Auditing group, follow either of
these steps:
a Click Trace Precedents.
Click Trace Dependents.
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
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.
Search JabSto ::

Custom Search