Browse » Home
Friday, February 25, 2011
How to Use Formula Auditing in Microsoft Excel 2007
1.
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.
2.
Click on the 'Formula' tab in the Ribbon. The Ribbon is the group of icons and tools located directly above the work area.
3.
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 included in. The arrows that Excel adds to your work sheet will print on your document.
4.
Click 'Remove Arrows' to delete the arrows the auditing function added to your worksheet.