cfo.com

cfo tagline

Spreadsheets: Stop the Flip-Flopping

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

Alternate method

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

thanks..

been using excel all my life and didn't know about these tools.

Posted by Justin Thacker | September 27, 2010 01:13 pm

watch window

Fabulous article, love learning something new!!

Posted by Patricia Donohue | September 24, 2010 05:28 pm

CFO Publishing Corporation 2009. All rights reserved.