![The star spangled banner song video](https://cdn1.cdnme.se/5447227/9-3/screenshot_2_64e62946ddf2b36521902657.jpg)
You can move through the formula bit by bit, with Excel showing you the result of each piece of the formula. When you click the Evaluate Formula button, Excel displays the formula in the active cell and the subtotal for part of the calculation. When you set a watch, the values of the cells you’re monitoring appear in the Watch Window.Īnother way that you can monitor your data is to check the result of part of a calculation by using the Evaluate Formula dialog box. You can monitor the value in a cell even while you’re using another workbook by setting a watch. Stock market values change frequently, so your data will as well.
![how to angle text in excel 2013 how to angle text in excel 2013](https://www.exceldashboardtemplates.com/wp-content/uploads/2012/12/image90.png)
For example, workbook data probably will change quickly if you are evaluating stock prices. When you share a workbook with your colleagues, some of the values in that workbook might change rapidly as new data is entered.
![The star spangled banner song video](https://cdn1.cdnme.se/5447227/9-3/screenshot_2_64e62946ddf2b36521902657.jpg)