In this tutorial we’ll take a look at how to use the Watch Window feature in Excel. This tool is a great way to keep an eye on other areas of your workbook or even other workbooks while managing your data.
You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.
In this example, I have a worksheet that contains information for two of my expenses:
These are linked to an Income Statement on another worksheet:
I don’t want to have to keep flipping back and forth between worksheets, or even workbooks to see the impact of any changes made to the expenses on the net income. This is where the Watch Window can come in to play. I can have a floating object like this:
…or a one fixed above my formula bar, such as this:
Either will allow me to track certain cells from another worksheet or workbook.
Take a few minutes and watch the video to see how easy it is to set up a Watch Window in Excel.
What can you do next?
Share this post with others that can benefit from it!
Leave a comment or reply below – let me know what you think!
Subscribe to this blog for more great tips in the future!
Check out my YouTube channel – click on the YouTube icon below!