Office for Mac Issues

Excel for Mac 2019: Work Around the Missing Watch Window

Phi Hung VoPhi Hung Vo Nov 18, 2026 869 views

Question details

The user needs to monitor important cells while working in Excel for Mac 2019 and cannot find the Watch Window.

Work Around the Missing Watch Window in Excel for Mac 2019
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.
Before you start

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.

Solution 1Recommended

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.

1
Add a monitoring sheet

Click the plus button next to the sheet tabs to add a worksheet, then rename it Monitor.

2
Link an important cell

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.

3
Add labels and references

Type a descriptive label beside each linked value and repeat the formula for the other cells you need to monitor.

4
Check values while working

Click the Monitor sheet tab to review the linked values, then return to the source sheet to continue editing.

Monitor cells on a separate worksheet
Free Microsoft Office alternative

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.

Use linked formulas to organize values for spreadsheet monitoringOpen and edit Microsoft Excel XLS and XLSX filesWork with spreadsheets in a familiar, easy-to-use interfaceMove existing Office documents into a lightweight office suite
microsoft office alternative - wps office

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.