Microsoft Office Tutorials and References

In Depth Information

**Debugging your formulas**

Delete a watch

1
Click the Formulas tab.

2
Click Watch Window.

3
Click the watch that you want to delete.

4
Click Delete Watch.

5
Click the Close button.

1

2

4

5

3

2

Evaluate parts of a formula

1
Click the cell with the formula that you want to evaluate.

2
Click the Formulas tab.

3
Click Evaluate Formula.

4
Click Evaluate (one or more times) to move through the formula’s

elements.

5
Click Close.

3

1

5

4