Can we please have a Watch Window where we can see / monitor when the value in the cell which is being watched is changed. This functionality is available in Excel for windows under Formula's Ribbon under Audit formula section21 votes
I have good news to share. We are working to bring the Watch Window to Excel for Mac. You can try it now by opting into to the Insider program and choosing the Fast updates.
To opt into the Insider program, go to Help menu > Check for Updates. Then click the Advanced button, then opt in to Insider Fast. If you update to version 16.43 201013 or greater, you should see the Watch Window button on the Formula tab of the ribbon.
If you notice any problems or have any feedback, please click the feedback button in Excel and let us know about.
Steve [Excel for Mac team]
Make Get & Transform (formerly Power Query) available in Excel for Mac (like in Excel for Windows)3,858 votes
We are pleased to announce that the first set of Power Query features are now available in version 16.29 and greater. At this stage you can refresh from text, CSV, XLSX, JSON and XML files.
Refer to the following blog post for more details:
I encourage you to try the new functionality and share your feedback with us via Send a Smile/Frown at the top right corner in your Excel for Mac.
- Don't see your idea?