Excel Watch Window - AdvantEdge Training & Consulting

Excel Watch Window

In some large Excel workbooks a dependent cell may refer to a precedent cell on another worksheet or many rows or columns away. The Excel Watch Window lets you see the dependent cell adjust as you make changes to the precedent cell. You can watch values change on dependent cells scattered throughout a workbook from this single window.

Just click Watch Window in the Formula Auditing group of the Formulas tab in Excel. Click Add Watch and choose the dependent cell you want to watch.

Now leave that window open, and make a change to the precedent cell. The window will immediately update with the change. Use Undo (Control + Z) and Redo (Control + R) to toggle the change.
Excel watch window

For more ways to make Excel work for you, take a training course from AdvantEdge Training & Consulting!

If you have at least 5 people we can create a session just for you.  Or, you can contact us for a private session. Contact Us

Questions? Don't see what you need?

We can help!

Business Training Classes
AdvantEdge Training & Consulting, Inc.

Recent Posts

Subscribe to our Newsletter

Copyright AdvantEdge Training & Consulting

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Scroll to Top