Excel for Mac 2019: Work Around the Missing Watch Window
Question details
The user needs to monitor important cells while working in Excel for Mac 2019 and cannot find the Watch Window.

- Product
- Microsoft Excel for Mac 2019
- Device & OS
- Mac; macOS version not provided
- Scenario
- The user wants to follow an exercise or exam workflow that uses the Watch Window.
- Observed behavior
- The Watch Window feature cannot be found in Excel for Mac 2019, although it may be available in Excel for Windows.
In Excel, open the Excel menu and select About Excel to confirm your version. Identify the cells you need to monitor and, for an exam or course, check whether an alternative workflow is permitted.
Monitor cells on a separate worksheet
Use linked formulas to collect important values in one place when the Watch Window is unavailable.
Excel for Mac 2019 does not support the Watch Window. A monitoring worksheet can display linked cell values, but it is not a floating window and may not satisfy an exercise that specifically requires Watch Window.
Click the plus button next to the sheet tabs to add a worksheet, then rename it Monitor.
On the Monitor sheet, select a cell and enter a reference such as ='Sheet1'!A1, replacing the sheet name and cell address with the value you want to track.
Type a descriptive label beside each linked value and repeat the formula for the other cells you need to monitor.
Click the Monitor sheet tab to review the linked values, then return to the source sheet to continue editing.

Use Excel for Windows when Watch Window is required
Choose this option if an assignment or exam requires the actual Watch Window and Windows Excel is available.
Manage spreadsheets with WPS Office
WPS Office is a free, lightweight Microsoft Office alternative with a familiar interface and support for common Office formats, making it easy to bring existing spreadsheets into your workflow. It does not restore the Excel for Mac Watch Window.

Frequently Asked Questions
Why can't I find Watch Window in Excel for Mac 2019?
Excel for Mac 2019 does not support Watch Window. Use linked formulas on a monitoring sheet or, if allowed, open the workbook in Excel for Windows.
Can I monitor a cell from another worksheet?
Yes. On a monitoring sheet, enter a formula such as ='Sheet1'!A1, replacing Sheet1 and A1 with the source sheet and cell.
Will a monitoring sheet count as Watch Window in an exam?
Not necessarily. Ask your instructor or exam administrator whether linked formulas or Excel for Windows are permitted before the exam.
Where is Watch Window in Excel for Windows?
In a supported version of Excel for Windows, select Formulas > Watch Window, then choose Add Watch to add a selected cell.




