How Do You Use Formula Auditing In Microsoft Excel 2007?
Formulas in Microsoft Excel range from simple to complex. There can be numerous cell references contained within a single formula. This can make keeping track of the elements of that formula difficult and confusing. Using Excel’s Formula Auditing makes it easier for users to determine which cells are included in a particular formula by presenting a visual connection of graphic arrows between the cells. There are also auditing features that allow users to determine which formulas a cell is included in. Click in the cell to which you would like to trace the connections. For example, if you would like to know which cells are part of a particular formula, click in the cell containing the formula. Click on the “Formula” tab in the Ribbon. The Ribbon is the group of icons and tools located directly above the work area. Select the auditing option you want to appear on your worksheet. Trace Precedents will show cells included within a formula. Trace Dependents will show which formula a cell is
