Cell Watch on Excel 2002

I am by no means an Excel guru. It pretty much comes down to the fact that I know just enough to do what I need to do. Performing a new task, outside of my daily ones, usually requires a phone call to my best friend, who is an Excel guru.

Now one of the things that I really disliked doing in Excel was scrolling up and down to check on the values of certain cells as they changed. Scroll down, scroll back up. Seems simple enough but doing it over and over was enough to get me complaining. So my Excel guru suggested I use the Watch Window.

By using the Watch Window, I can monitor different cells in a small window that is always visible. I can even monitor cells that are not on the screen or in a different workbook on my spreadsheet. This way I can immediately see the values as they change.

You can easily add a cell to the Watch Window. Simply right click a cell and select Add Watch. You will see the Watch Window appear and it will remain on top as you work on your spreadsheet. You can reposition the window so it is out of the way by dragging and dropping the window to its new location. Now, thanks to my Excel guru, I no longer have to scroll up and down or flip between workbooks to see cell values as they change.

Article Written by

  • jonathan moses katcher

    You can also select the entire row beneath the table of data you want to freeze by clicking on the row header and then select from the toolbar: window ->freeze panes.
    To unfreeze, Select window -> unfreeze.

  • http://robertglenfogarty.com/ Robert Glen Fogarty

    Of course! With only one hand, though (as they hold quiche in the other).