Watch Window finally coming to Excel for Mac

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

An essential Excel testing and debugging tool is finally in Excel 365 for Mac.  The Watch Window makes fixing workbooks a lot easier.

Watch Window is a separate pane which shows the current status of selected cells from across many workbooks or sheets.  When you can’t figure out why Excel is misbehaving, the Watch Window puts key cells in a single view.

It’s on the Formula Tab | Watch Window. 

image 94 473x205 - Watch Window finally coming to Excel for Mac

Select a cell or range then click the + button to add them to Watch Window.  For each cell you can see:

  • Workbook
  • Sheet
  • Name
  • Cell reference
  • Value
  • Formula

Narrow the width for any columns you don’t need (like Workbook in the above example).

Rearrange columns

The columns can be rearranged by drag and drop. Here we’ve put the cell reference, value and formula first.

image 95 - Watch Window finally coming to Excel for Mac

That’s a very useful trick NOT possible in Excel for Windows! 

Sadly, the columns can’t be sorted.

Floating Window

Watch Window appears as a docked pane on the right but can be dragged off to make a floating window.  Drag from the ‘Watch Window’ title bar.

As a floating window, Watch Window can be anywhere on the screen leaving Excel completely or partly in view.

image 97 - Watch Window finally coming to Excel for Mac

Who has Watch Window?

Excel 365 for Mac Insiders have it now. Fast Version 16.43 (Build 20110105) and later. Look on the Formulas tab to see it arrive on public releases of Excel 365 for Mac.

New look in Microsoft 365 for Mac coming in early 2021
Office for Mac now supports M1 chips directly
Excel now has Dynamic Arrays – Windows, Mac and more …

Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address