Excel Functions Tutorials
- Excel Tools
- Excel Ribbons and Tabs
- Quick Access Toolbar in Excel (QAT)
- "Save As" Shortcut in Excel
- Accounting Number Format in Excel
- Add-Ins in excel
- Add Filter in Excel
- Advanced Filter in Excel
- Auto Filter In Excel
- Auto Format Excel
- AutoFill in Excel
- Analysis ToolPak in Excel
- ANOVA in Excel
- Border in Excel
- Checkbox in Excel
- Check Mark in Excel (? Tick Symbol)
- Combo Box in Excel and VBA
- Conditional Formatting in Excel
- Conditional Formatting with Formulas
- Conditional Formatting for Blank Cells
- Conditional Formatting Based on Another Cell Value
- Conditional Formatting in Pivot Table
- Consolidate Data in Excel
- Comma Style in Excel
- CSV vs Excel
- Data Bars in Excel
- Data Table in Excel
- Data Validation Excel
- Data Model in Excel
- Developer Tab in Excel
- Descriptive Statistics in Excel
- Dynamic Named Range in Excel
- Drawing in Excel
- Excel Fill Handle
- Excel Fill Down
- Error Bars in Excel
- Excel Forms for Data Entry
- Excel Tables
- Excel Power View
- Exponential Smoothing in Excel
- Filters in Excel
- Flash Fill in Excel
- Freeze Panes in Excel
- Freeze Columns in Excel
- Freeze Cells in Excel
- Format Painter in Excel
- Shortcut for Format Painter in Excel
- F-Test in Excel
- Goal Seek in Excel
- Gridlines in Excel
- Heat Map in Excel
- 3D Maps in Excel
- Header and Footer in Excel
- Insert Button in Excel
- Insert / Draw Line in Excel
- Insert Function in Excel
- List Box in Excel VBA
- Lock Cells in Excel
- Macros in Excel
- Enable Macros in Excel
- Merge and Center in Excel
- Merge Cells in Excel
- Merge Tables in Excel
- Name Box in Excel
- Name Range in Excel
- Null in Excel
- One Variable Data Table in Excel
- OneDrive Excel
- Protect Workbook in Excel
- Pivot Table in Excel
- Pivot Table Examples
- Pivot Table Filter
- Pivot Table Slicer
- Paste Special in Excel (With Top 10 Shortcuts)
- Quick Analysis Tools in Excel
- Radio Button in Excel
- Recording Macros in Excel
- Regression Analysis in Excel
- Scenario Manager in Excel
- Scroll Bars in Excel
- Scroll Lock in Excel
- Slicers in Excel
- Solver in Excel
- Sort by Color in Excel
- Sort by Number in Excel
- Sort Data in Excel
- Sparklines in Excel
- Spell Check in Excel
- Split Panes in Excel (Horizontally, Vertically, Cross Split)
- Status Bar in Excel
- Text to Columns in Excel
- Timeline in Excel
- Toolbar on Excel
- Track Changes in Excel
- Trend Line in Excel
- Two-Variable Data Table in Excel
- Watch Window in Excel
- Wrap Text in Excel
- XML in Excel
- Financial Functions in Excel (17+)
- Logical Functions in Excel (15+)
- TEXT Functions in Excel (29+)
- Lookup Reference in Excel (44+)
- Maths Functions in Excel (52+)
- Date and Time Function in Excel (22+)
- Statistical Function in Excel (50+)
- Information Functions in Excel (5+)
- Excel Charts (48+)
- Excel Tips (178+)
- VBA (162+)
Watch window in excel is used to watch for the changes in the formulas we use while working with a large amount of data and formulas, they are available from the formulas tab In the formula auditing section, when we click on watch window a wizard box appears and it gives us the option to select the cell for which the values we need to be monitored or watched.
Watch Window in Excel (Table of Contents)
What is Watch Window in Excel?
As working professionals, we all deal with excel formulas in excel. More often, there are cells in the worksheet where we have our important formulas that are the main thing for our calculations.
In such a scenario, it is important to keep an eye on those cells to check whether the calculation is right or wrong.
Usually, when we are working with a small amount of data, it is easy to find the mistakes and correct it. However, when you have to deal with large sets of data we cannot do that regularly.
We have a tool called Watch Window to inspect some useful and important cells in any time without scrolling back is a wonderful thing to have. Today, I will introduce you to this fabulous tool.
This is available from the 2010 version. In this article, we will see how to watch window works.
How to use Watch Window in Excel?
Go to Formula Tab then Formula Auditing and Watch Window
The shortcut key to open this Window is ALT + M + W.
- Keep track of useful cells or formulas in the worksheet or workbook.
- It will work on different sheets.
- You can add or delete cells or formulas from this window.
Watch Window in Excel – Examples
Let’s get started to understand this practice.
Suppose you have sales data from range A1:A391. As shown in the below image we have total sales and we need to keep a track of the total sales amount.
We can do this by our wonderful tool called Excel Watch Window. Follow the below steps to add watch window.
- Select the targeted cell you want to watch. Go to Formula Tab then Formula Auditing and Watch Window in Excel
- In this dialogue box click on the add button.
- Below window will open and by default it will the targeted cell which you have selected earlier.
- Click on add button now. This will instantly create the below Watch Window
Add Watch Window from multiple sheets. We can watch multiple sheets cells in the same watch window. This is very helpful when you deal with multiple sheets.
Assume you have below sample data in two different sheets.
Now we need to add watch window for both employees CTC in one window. To add follow below steps.
- Select the data in the first sheet i.e. Employee 1 sheet.
- Go to Formula Tab then Formula Auditing and Watch Window
- Clicks add and this will add one cell watcher for this sheet because you have selected only one cell.
- Now again click on add watch and select the second sheet (Employee 2 sheet) CTC cell.
- Click on add and it will show two different sheet names under Sheet name.
- Part 1: In this section, it is showing the name of the workbook we are referring. In this example, we have used only one workbook. Therefore, it is showing only one workbook name.
- Part 2: In this section, it is showing the name of the worksheet we are referring. In this example, we have used two different worksheets. Therefore, it is showing two different worksheet names.
- Part 3: In this section, it is showing the name of the cell in that worksheet we are referring. In this example, it is showing C12 as cell reference in both the sheets.
- Part 4: In this section, it is showing the value of the cell in that worksheet we are referring. In this example, it is showing 4,32,000 in first sheet reference and 5,38,650 in second sheet reference.
- Part 5: In this section, it is showing the formula cells from which cells it is taking reference. In this example, it is showing C7 + C9 + C10 as cell reference in both the sheets.
Delete Cells from Watch Window in Excel
Like how we added watch window to our important cells, we too can delete those cells from the watch window. Follow below steps to delete the cells.
- Select the existing Watch Window section.
- Select the cells you want to delete and click Delete. To delete more than one use shift and arrow keys.
Dock Your Watch Window Below Your Excel Ribbon
Watch window is the floater in general. You can fix it at below your ribbon. In order to do that just double click on the title bar of the watch window.
As soon as you double click on the title bar it will fix it below the excel ribbon bar.
Important Points of Watch Window in Excel
- You can add as many as cells in your watch window. But, the more you add the more sluggish your workbook becomes.
- Duck the watch window to the right end of the excel (only in excel 2013 afterward versions)
- You can add cells from different worksheets but you cannot add cells from another workbook. Every workbook has its own watch window section.
- It is very useful to track all the important cells in a single frame window.
- Best thing is you need set it one time. Need not to do it at regular intervals of time.
Things to Remember about Watch Window in Excel.
Below are some of the important things about Watch Window
- Name of the Cell: When you add watch window to a cell it will also capture the name of the cell is given by the user.
- Address of the Cell: It will show you the cell address.
- Value of the Cell: It will display the value of the particular cell.
- Formula of the Cell: It will also display the formula of the cell.
- Worksheet Name: It will capture the worksheet name also. It is very useful when you are dealing with so many worksheets.
- Workbook Name: It will also capture the name of the workbook along with the worksheet name.
This has been a guide to Watch Window in Excel. Here we discuss how to use Excel Watch Window along with example and downloadable excel templates. You may also look at these useful functions in excel –