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:

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 7.2.

• Will Windows 7 is dominated by about Snow Leopard and OS Chrome? After the release of source code for Google Chrome operating system to developers, the software giant, Microsoft’s Windows 7...
• Stream Techniques In streams, wild trout generally find their food, their shelter and the right temperatures behind rocks as well as in...
• Tip Tricks: Three Methods When You Don't Have a Tip Calculator Chances are, you've gone out to eat in a nice restaurant before, and intend to do so again.  Hopefully, when...
• The Backswing The swing itself, to a very large degree, is actually a chain reaction if you think about it. When you...
• Should you write your own tax software? Lazy Man and Money posted a reader's question over in the MBN Forums asking for help: Do you have an...