Microsoft Office Tutorials and References
In Depth Information
Debugging your formulas
Debugging your formulas
When you share a workbook with your colleagues, some of
the values in that workbook might change rapidly as new data
is entered. For example, workbook data probably will change
quickly if you are evaluating stock prices. Stock market values
change frequently, so your data will as well. You can monitor
the value in a cell even while you’re using another workbook by
setting a watch. When you set a watch, the values of the cells
you’re monitoring appear in the Watch Window.
Another way that you can monitor your data is to check the
result of part of a calculation by using the Evaluate Formula
dialog box. When you click the Evaluate Formula button, Excel
displays the formula in the active cell and the subtotal for part
of the calculation. You can move through the formula bit by bit,
with Excel showing you the result of each piece of the formula.
1
3
2 6
Monitor a formula for changes
1 Click the Formulas tab.
2 Click Watch Window.
3 Click Add Watch.
4 Select the cells that you want to watch.
5 Click Add.
6
Click Watch Window.
4
5
Search JabSto ::




Custom Search