How to use Watch Window in Excel to track key formulas and their results

  • Post author:
  • Post category:Windows

The Excel 101: you update an input, then spend the next 10 minutes jumping between tabs to see how it affected your key data. You then update another input, and it’s rinse and repeat. If only there were a way to see the impact immediately! Luckily for you, the Watch Window lets you do exactly that, even if your formulas are in far-away worksheets or workbooks. Here’s how to use this game-changing tool.