Monday, April 20, 2009

“Watching the Action”

Keeping an eye on the values of certain Excel cells can be problematical if you are working with a large spreadsheet (or multiple spreadsheets). Solution: “Watch Window” to the rescue!

The Watch Window can display the value of any cell or cells in a viewing pane that can be relocated on your screen. The simple instructions are:

1. Select the Formulas tab on the ribbon
2. Select Watch Window from the Formula Auditing section
3. The Watch Window will appear
4. Click the Add Watch button to specify the cell(s) you wish to monitor

“All along the watchtower…” (Gotta love Dylan…)

No comments: