Ms Office Tune Up

Using a range snapshot is a useful and nifty trick, but it’s only practical if you want to watch one or two values. However, it’s not unusual for a large or complex worksheet model to have a large number of cells that require watching, particularly when you first build the model. If you need to keep an eye on a lot of cells, forget the Paste Picture Link command. Instead, use Excel’s more elegant solution: the Watch Window. This window enables you to keep tabs on both the value and the formula in any cell in any worksheet in any open workbook. Here’s how you set up a watch:

Calculating Multiple Solutions to a Formula

1. Activate the workbook that contains the cell or cells you want to watch.
2. Choose Formulas, Watch Window. Excel displays the Watch Window.
3. Click Add Watch. Excel displays the Add Watch dialog box.
4. Either select the cell you want to watch or type in a reference formula for the cell (for example, =A1). Note that you can select a range to add multiple cells to the Watch Window.
5. Click Add. Excel adds the cell or cells to the Watch Window, as shown in Figure 1.

Figure 1 Use the Watch Window to keep an eye on the values and formulas of unseen cells that reside in other worksheets or workbooks.

Technorati Tags: watch window, cell value, excel 2007

Popularity: 2% [?]

If you liked this post, would you please buy me a twelve-ounce lattes for only $2