• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Watch Window in Excel

August 14, 2021 by Andrew Childress

When you’re working in Excel, it’s often useful to watch cells and the values contained inside them. Let’s learn how to use the Watch Window in Excel.

When you’re working in Excel, it’s often useful to watch cells and the values contained inside them. With smaller sheets, this is very easy. But with larger sheets with many rows and columns, these cells may not be actually visible. Fortunately, Excel makes it simple to keep an eye on those values. Let’s learn how to use the Watch Window in Microsoft Excel.

How to Use the Watch Window in Excel

Let’s imagine that you have a series of cells that you want to monitor. These are in the range C3:C5. At a glance, you want to be able to see any changes made by you or other users. For example, if a value is changed from 68 to 78, you want to observe it, whether or not the cell is actually visible on screen.

This is where Excel’s Watch Window comes in. The Watch Window lets you monitor cells that you select. To use it, begin by highlighting the range of cells that you want to watch. Once again, this range is C3:C5 in this example.

Watch window in Excel

Then, go to the Formula tab. You’ll find this on Excel’s ribbon up at the top of your screen. Here, you’ll see an array of options. The one you want is Watch Window, found over on the right side. Click it, and the Watch Window sidebar will open.

Use watch window in Excel

Click on the + symbol in the upper left corner, and Excel will add your selected cells to the Watch Window. Now, any time you make a change to the cells, the most current value will appear in the Value column. This works whether or not the cells are visible on your workbook.

How to use watch window in Excel

As you can see, Excel’s Watch Window feature makes it easy to monitor the values inside any cell or cells in your workbook. This is a quick way to track changes and ensure that your data is accurate.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Use data validation in ExcelData Validation in Excel
Next Post:Currencies in ExcelCurrencies in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top