Forum Discussion
asdfaklsfjasdlkf
Jul 12, 2022Copper Contributor
Name manager missing from Excel for Mac
https://techcommunity.microsoft.com/t5/excel-blog/improved-name-manager-in-excel-for-mac/ba-p/3179498 says that name manager is available for Excel for Mac from 16.58, I have 16.62 and it's not there (and pressing Define Name opens the Define Name dialog, not the Name Manager dialog). A colleague of mine also has Excel for Mac 16.62 and in the Formulas tab there's a large Name Manager button to the left of Define Name and Create from Selection.
I've tried customising the buttons in the ribbon but Name Manager isn't anywhere to be found. Anyone know how to make it work?
asdfaklsfjasdlkf Check your license type. It must be subscription to have this feature. Use the Menu Bar and choose Excel > About Excel to display your version. If your install is managed by an IT department, ask them if the have a delay on new features in place.
- asdfaklsfjasdlkfCopper ContributorWhen I go do Excel > About Excel it says Licence: Microsoft 365 Subscription
Hi again
Thanks for replying. Try clicking on the idea light bulb and type Name Manager. Does it appear on the menu? If yes, select it.