This is helpful when you have data that spans across multiple worksheets.įor example, below I have data for student scores for two different exams (something like mid-term and finals) in two different worksheets. You can easily add cells from multiple worksheets in the same watch window. To do this, simply drag it to the extreme right and leave it and it will automatically dock there. This would instantly add all the three cells to the Watch Window dialog box.ĭocking the Watch Window in Excel 20: While the watch window is a floating window by default, you can dock it to the right pane of the worksheet in Excel 20. In case you want to change the reference, you can do it in this step.
How to Keep Track of Important Cells using Watch Window
When working with large datasets full of formulas in Excel, it becomes difficult to keep a track of important cells and formula results.