Forum Discussion
fernlopez
Jun 14, 2020Copper Contributor
Named Ranges Excel for Mac
Hi. In previous versions of Excel for Mac, in the Formulas ribbon the Named Ranges section had a menu called Use in Formula. The menu included a Past Names item. That menu has disappeared. How do I d...
JKPieterse
Jun 15, 2020Silver Contributor
It should be right there. It is on my Windows Excel.
- fernlopezJun 15, 2020Copper Contributor
JKPieterse Hi. Yes, it's there under Windows, but disappeared on Mac. I suspect it was moved but can't find it or any other way to do this.
- fastexcelJun 17, 2020Brass Contributor
I checked on my Insider Fast Mac XL and I confirm that it is not there.
And Mac XL does not have a Name Manager.
(although you can buy my Manager Pro for Mac XL from here) http://www.decisionmodels.com/fxl_MgrProMac.htm
- JKPieterseJun 17, 2020Silver ContributorPerhaps you can get at the dialog by pressing Alt+i,n,p (or whatever the Mac key is for alt)?
- JKPieterseJun 17, 2020Silver ContributorIf your MAC version has a feedback button, please send a frown to Microsoft about this.