Hi All – the Name Manager is now available in Excel for Mac if you’ve opted into the Insiders program and chosen the Beta updates.
You can read more about it here, including the required version number – https://insider.office.com/en-us/blog/improved-name-manager-in-excel-for-mac.
For information about how to join the Insiders program – https://insider.office.com/en-us/join/mac
An error occurred while saving the commentAndrew Pickering Brook commented
MS has just made LAMBDA functions available for Excel (even for Mac!). However, all of the MS Support "How Toos" and "Help" demonstrate how to create them using a Name Manager that does not exist on the Mac version. Eventually I did manage to get them to work, but only by viewing someones YouTube clip. So yes MS, a Name Manager that is the same as the Windows version would be useful.
6,839 votes505 comments · Excel for Windows (Desktop Application) » Macros and Add-ins · Flag idea as inappropriate… · Admin →
Thank you for the continued interest in this space. While we don’t have specific plans to announce at this time, we have been researching the topic, conducting customer interviews, and are working with the Python team at Microsoft so we can build a plan that we think can address the scenarios you told us about and ensure it can run wherever Excel runs.
Keyur [Microsoft Excel]