Excel 2010–Watch Window

Ever needed to keep an eye on a single result of a formula on one sheet while working on multiple sheets? You needed to be constantly switching from sheet to sheet to check the result every time you changed a value, right? No need for that anymore because Excel 2010 introduces the new Watch Window.
The Watch Window button can be found on the Formula tab, Formula Audition group. Click it and a Watch Window dialog will open. Now click on the Add Watch button in the Watch Window dialog.
WatchWindow1
A new dialog window will open for you to select the cell that you want to watch. After you select the cell, click on the Add button to close the dialog window.
WatchWindow2
You can repeat theses steps for all the cells that you want to check. After that you position you watch window on top of your sheet or you can position it where it doesn’t cover your sheet, on the top of it, bottom, left or right.
This way you will have a Watch Window that will show you the result of the cells that you’re tracking, without having to switch to the sheet where the formula is to check is result.
WatchWindow3

7 comentários:

Anonymous said...

nice info - how about watching the typos???

jppinto said...

What do you mean by "typos"?

Anonymous said...

Thanks.
Just an fyi... the watch window has been around for years. I believe 2003 had it.

Anonymous said...

No click on the Add Watch button in the Watch Window dialog.

Typo #1.

jppinto said...

Corrected! Thanks for pointing it out...

pra$ said...

Thanks for this tip! Really helped me today :)

Anonymous said...

You can repeat these(s) steps for all the cells that you want to check. After that you (Can) position you(r) watch window on top of your sheet or you can position it where it doesn’t cover your sheet, on the top of it, bottom, left or right.
This way you will have a Watch Window that will show you the result of the cells that you’re tracking, without having to switch to the sheet where the formula is to check is result.