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.
Select a cell or range then click the + button to add them to Watch Window. For each cell you can see:
- Cell reference
Narrow the width for any columns you don’t need (like Workbook in the above example).
The columns can be rearranged by drag and drop. Here we’ve put the cell reference, value and formula first.
That’s a very useful trick NOT possible in Excel for Windows!
Sadly, the columns can’t be sorted.
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.
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.