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.