Skip to content

5000+ Great Articles

Best Articles & Essays: Interesting Articles to Read Online

  • Everything You Need to Know about Profiles on Amazon Prime Video How-To
  • Create Bootable USB Recovery Drive in Windows 8/10 Computer Tips
  • How to Use the Microsoft Anti-Malware Script Interface Script
  • 10 Awesome Chrome Extensions You Should Install Google Software/Tips
  • Format an SD Card the Easy Way Free Software Downloads
  • Find out How Well Two Person Know Each Other on Facebook How-To
  • How to Backup Your Android Phone Smartphones
  • Google Chrome Memory Usage/Memory Leak Issues? Google Software/Tips

Use the Excel Watch Window to Monitor Important Cells in a Workbook

Posted on October 6, 2020 By blog_786 No Comments on Use the Excel Watch Window to Monitor Important Cells in a Workbook

Sometimes a great feature in an application never gets the credit it deserves, and Excel’s viewport is a great example of one such feature.

If you use Excel regularly, you’ve probably worked with very large worksheets, spanning hundreds if not thousands of lines. It would be helpful if some of the cells that you need to track often could be displayed in a separate window so you can see the current value and formula at a glance. Microsoft has created a watch window in Excel for this very purpose.

Use the Excel view window

Using the viewport, you can select important cells in a separate window and keep track of them there, which saves you the trouble of scrolling through the entire worksheet.

Let’s take a look at an example below. Let’s say this data is part of a much larger dataset, and we want to keep track of a few important cells that change quite often.

Use the Excel Watch Window to Monitor Important Cells in a Workbook

Click the Formulas tab on the Ribbon and find the Watch Window button under the Formula Auditing section.

Use the Excel Watch Window to Monitor Important Cells in a Workbook

This will open the Watch Window dialog. The field is of course empty as we haven’t added any tracking cells yet.

Use the Excel Watch Window to Monitor Important Cells in a Workbook

Now let’s add a cell to the viewport. To do this, click the Add Observation link at the top of the dialog box.

Use the Excel Watch Window to Monitor Important Cells in a Workbook

In the Add Observation dialog box, you can select cells in one of two ways. You can enter a cell reference directly or select cells with your mouse. Entering data into cells directly is useful when you only have one or two cells that you want to track.

However, you are not limited to selecting only one or a few cells at a time. You can add adjacent cells to the viewport by clicking and dragging your mouse to select a series of cells. When you’re done, click the Add button.

Use the Excel Watch Window to Monitor Important Cells in a Workbook

You will notice a few things after you add cells to the viewport. First, Excel started monitoring cells. Any changes to the value or formula for that cell are immediately displayed in the viewport.

Second, the viewport also tells you other important information about the cells, including the workbook and worksheet the cells are in, and the cell name if you gave it.

Use the Excel Watch Window to Monitor Important Cells in a Workbook

Optionally, you can even drag the viewport to one of the sides of Excel to dock it so it doesn’t take up valuable space on the floating sheet.

Use the Excel Watch Window to Monitor Important Cells in a Workbook

You can add cells from other sheets to the same Excel workbook, but you cannot add cells from another workbook. Each book has its own separate viewport. If you’re working with large spreadsheets, the Watch Window saves real-time time and is likely to increase your productivity, allowing you to spend more time working and less time browsing in Excel. If you have any questions, do not hesitate to comment. Enjoy!

Also, don’t forget to check out my other Excel articles where you can learn how to filter data, insert an Excel spreadsheet in Word, open multiple instances of Excel, track changes in Excel, and subtract dates in Excel

–

Share this:

  • Twitter
  • Facebook
MS Office Tips

Post navigation

Previous Post: What is SeaPort.exe and How to Remove It
Next Post: 4 Free/Cheaper Rosetta Stone Alternatives

Related Posts

  • Insert an Excel Worksheet into a Word Doc MS Office Tips
  • How to Share or Collaborate On a Word Doc with Others MS Office Tips
  • How to Use COUNTIFS, SUMIFS, AVERAGEIFS in Excel MS Office Tips
  • How to Remove, Crack, or Break a Forgotten Excel XLS Password MS Office Tips
  • How to use AutoText and Quick Parts in MS Word MS Office Tips
  • Ultimate Guide to Repairing a Damaged or Corrupt Word File MS Office Tips

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Archives

  • September 2023
  • August 2023
  • July 2023
  • June 2023
  • May 2023
  • April 2023
  • November 2022
  • September 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • April 2022
  • March 2022
  • February 2022
  • January 2022
  • December 2021
  • November 2021
  • October 2021
  • September 2021
  • August 2021
  • March 2021
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • December 2019
  • July 2019
  • May 2019
  • April 2019
  • January 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018

Categories

  • AI Tools & Guides
  • Amazon Web Services
  • Apple Watch
  • Computer Tips
  • Cool Websites
  • Featured Posts
  • Free Software Downloads
  • Gadgets
  • Gaming
  • General Software
  • Google Software/Tips
  • Hardware
  • Help Desk
  • How-To
  • iOS
  • iPad
  • iPhone
  • islamic Books
  • Linux
  • Linux Tips
  • Mac OS X
  • macOS
  • MS Office Tips
  • Networking
  • Office Tips
  • OS X
  • Product Reviews
  • Reviews
  • Safari
  • Smart Home
  • Smartphones
  • Software Reviews
  • technology
  • text
  • Tools Review
  • Troubleshooting
  • Tutorials
  • Uncategorized
  • Urdu Books PDF
  • Web Site Tips
  • Windows
  • Windows 10
  • Windows 7
  • Windows XP Tips
  • Wordpress
  • What Is “Other” Storage on Android And How to Clean It Up ?
  • 7 Legal Websites to Get Free Music Downloads
  • Six Copyscape Alternatives That you can use
  • How to Make Phone Calls Without Revealing Your True identity
  • 50 Useful Websites on the Internet You Didn’t Know Existed
DMCA.com Protection Status

Recent Posts

  • A Simple Trick to Get 50% Discount on Audible for Three Months
  • 6 Best PayPal Alternatives (2017)
  • How to Fix the the “Invalid SIM Card” Error on Android
  • What Is “Other” Storage on Android And How to Clean It Up ?
  • 8 Best Free and Paid Cloud Storage (2017)

Recent Comments

  1. Automatically Transcribe YouTube Video/Audio with Google Docs on 5 Best Team Management Apps (For Small and Large Teams)
  2. 6 Things You Need Know About Email Encryption on Delete All Emails from Gmail With Once Click
  3. Looking For YouTube Alternative? Try These 7 Video Sharing Sites on Ten Best YouTube Video Editing Software 2023
  4. 8 (+1 New) Ways to Post on Instagram From Computer on How I Solved My Bluestacks Graphic Card Error (2 Ways)
  5. Find out what WordPress Theme and Plugin a Website is Using on How to Install a Theme on WordPress
  • Here’s How You Can Change Instagram App Icon How-To
  • How To Create Smart Mailboxes In Mail On Mac Tutorials
  • How to make offline PC games faster or slower Gaming
  • Best 7 Ways To Fix Getting Windows Ready Stuck in Windows 10 Windows 10
  • What prevents data processing in Windows 10? Windows 10
  • Where to Find Character/Word Count in Word 2010 Office Tips
  • 5 YouTube Channels Every Serious Tech Fan Should Subscribe To Reviews
  • The 7 Best Software Versions of Solitaire For Windows 10 Windows 10

Copyright © 2023 How To Blog.

Powered by PressBook News WordPress theme

Go to mobile version