1-866-245-5224 sales@keystonelearning.com

Excel 2007: Using the Watch Window

Excel 2007: Using the Watch Window

While using the Watch window isn’t nearly as robust as creating scenarios, it is a cool little feature that allows you to “watch” what’s happening to your formula results when you modify precedent cells.

Adding a Cell to the Watch Window

     
  1. Select the cell you want to add to the Watch window
     
  2.  
  3. Click the Watch Window command in the Formula Auditing group on the Formulas tab
     

Figure 43. Watch Window

    3.       Click Add Watch…

Figure 44. Add Watch Dialog Box

    4.       Verify the cell range is correct

    5.       Click Add

Deleting a Cell from the Watch Window

     
  1. Click the Watch Window command in the Formula Auditing group on the Formulas tab
     
  2.  
  3. Select the line that contains the cell watch you want to delete
     
  4.  
  5. Click Delete Watch