Microsoft Office Tutorials and References
In Depth Information
Finding and correcting errors in calculations
To set a watch, click the cell you want to monitor, and then on the Formulas tab, in the
Formula Auditing group, click Watch Window. Click Add Watch to have Excel monitor the
As soon as you enter the new value, the Watch Window displays the new result of the
formula. When you’re done watching the formula, select the watch, click Delete Watch, and
close the Watch Window.
In this exercise, you’ll use the formula-auditing capabilities in Excel to identify and correct
errors in a formula.
SET UP You need the ConveyerBid workbook located in the Chapter03 practice file
folder to complete this exercise. Open the workbook, and then follow the steps.
Click cell D21 .
On the Formulas tab, in the Formula Auditing group, click Watch Window to open
the Watch Window .
Click Add Watch , and then in the Add Watch dialog box, click Add to add cell D21
to the watch list.
Click cell D8 , which activates the cell and displays =SUM(C3:C7) in the formula bar.
On the Formulas tab, in the Formula Auditing group, click the Trace Precedents
button to display a blue arrow that begins at the cell range C3:C7 and points to cell
D8 , indicating that the cells in the range C3:C7 provide the values for the formula in
cell D8 .