I’m trying to create a window that floats in front of my workbook that lets me see selected cells from anywhere in my workbook to see how changes affect cells that aren’t within view on a large spreadsheet. When I searched for it on several Excel blogs the answer was: the Watch window doesn’t exist on Mac. It’s a PC-only feature. Hence my question.
Mac has a Watch Window - which works as it has worked years.
It can be visible same time with 'normal' Excel-sheet too.
I have used a Watch Window only while coding.
Your a window would be something else ...
it would need more ... testing