Wednesday, March 15, 2017

Using the Excel Watch Window

Excel's Watch Window is a useful tool for monitoring the contents of a range of cells. It's found on the Formula tab. One can add a range of cells in a column by them and using the Add Watch... button.

Entering a formula in the first cell provides the model for those below using drag and fill. Here the source cells are found in column B.

The drag and fill uses the same formula and relative location of the source cell.

It's not as easy to remove a cell from the Watch Window since each entry has to be deleted individually. The best solution appears to be not to save a worksheet with a watch window.

No comments: