- Understanding Formulas
- Creating a Simple Formula
- Creating a Formula Using Formula AutoComplete
- Editing a Formula
- Understanding Cell Referencing
- Using Absolute Cell References
- Using Mixed Cell References
- Using 3-D Cell References
- Naming Cells and Ranges
- Entering Named Cells and Ranges
- Managing Names
- Simplifying a Formula with Ranges
- Displaying Calculations with the Status Bar
- Calculating Totals with AutoSum
- Calculating Totals with Quick Analysis
- Performing One Time Calculations
- Converting Formulas and Values
- Correcting Calculation Errors
- Correcting Formulas
- Auditing a Worksheet
- Locating Circular References
- Performing Calculations Using Functions
- Creating Functions
- Creating Functions Using the Library
- Calculating Multiple Results
- Using Nested Functions
- Using Constants and Functions in Names
Auditing a Worksheet
In a complex worksheet, it can be difficult to understand the relationships between cells and formulas. Auditing tools enable you to clearly determine these relationships. When the Auditing feature is turned on, it uses a series of arrows to show you which cells are part of which formulas. When you use the auditing tools, tracer arrows point out cells that provide data to formulas and the cells that contain formulas that refer to the cells. A box is drawn around the range of cells that provide data to formulas.
Trace Worksheet Relationships
- Click the Formulas tab.
Use any of the following options:
- Click the Trace Precedents button to find cells that provide data to a formula.
- Click the Trace Dependents button to find out which formulas refer to a cell.
- Click the Error Checking button arrow, and then click Trace Error to locate the problem if a formula displays an error value, such as #DIV/0!.
- Click the Remove Arrows button arrow, and then click Remove Precedent Arrows, Remove Dependent Arrows, or Remove All Arrows to remove precedent and dependent arrows.
- If necessary, click OK to locate the problem.