Use the Excel Watch Window to monitor key worksheet cells, rather than switching back and forth between worksheets.
Bill Jelen, CFO.com | US
September 22, 2010
I like the "Watch Window", but personally I prefer to insert a reference to the cell(s) I need to watch right in the spreadsheet(s) where I am working, in a normally hidden line or column that would not affect any formula result for example... Maybe a low-tech approach, but quite effective!
Posted by Didier Jupillat | September 27, 2010 01:18 pm
been using excel all my life and didn't know about these tools.
Posted by Justin Thacker | September 27, 2010 01:13 pm
Fabulous article, love learning something new!!
Posted by Patricia Donohue | September 24, 2010 05:28 pm© CFO Publishing Corporation 2009. All rights reserved.