A better Name manager
What I love, please read this a need, is a better Name manager.
The size of the list is way to small. If you work a lot with names, then you get longer names which are not easy to select.
Also would like to see an easier way to replace, rename and exchange Names and references. When I make a Template sheet with names/reverences and want to make multiply copies bij code or manualy, its a crime to change or update the Name.
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
Peter Delis commented
It's clear Microsoft is committed to harmonising the Excel Windows and Mac versions as is evidenced in the VBA interface.
It's a shame that they have overlooked updating the Name Manager. I can only hope that they look to this forum and take onboard the suggestion that the Excel Apple Name manager is in serious need of harmonisation.
Charles Coy commented
Yes please! Often working on complex model workbooks where long lists of names are used across the workbook.
Would be ideal to have exactly what the MS Windows version of Excel has (Names Manager) where each range (or multiple) can be modified and removed.
The Define name dialog box available in excel for MAC is very limiting. From small things like it not being re-sizeable, resulting in the list of defined names displayed being truncated, to large more impactful things like not showing the results of the named range (field value, or formula results) which limits ones ability to validate the named range. It's remedial and ineffective. For people who have used the Windows version with a full more robust name manager this is a huge step backwards ! It makes me regret lobbying at work to get a MAC to replace my PC.
I would think it would be in Microsoft's best interest to have more business people WANT to use a MAC at work, However, when the Office 365 suite of tools (a suite that is pervasive in all major companies) has significant gaps in functionality on the MAC version, you are shooting yourselves in the perverbial foot.
Charles Williams commented
You can use my addin product FastExcel Manager Pro for Mac:
This contains Name Manager Pro which has a lo more features than the standard Windows Name Manager.
But its a chargeable product.
I agree, plus, I should be able to specify worksheet vs workbook names directly like the PC version, instead of the roundabout way I can never remember and have to Google every time that the Mac version has.
doesn't need to be better - you already have a better one for PCs. just port it!
Just moved from Office Mac 2011 to 2016 kicking and screaming, with the loss of the ability use keyboard rather than right click for inserting columns or rows. You can click "=3+3" with manually adding the + sign ...REALLY ?? Finally the whole suite is sludgy and SLOW... The tool bars are graphically hard to read compared to the old GUI. Not to mention you have to flip back and forth trying to find things that used to at your finger tips like the view screen or other frequently used things on laptops. HORRIBLE HORRIBLE! Does Microsoft test these things with users on Macs?
even Google Sheets puts Excel for Mac to shame when it comes to Named Range management
***Post moved by the moderator to the appropriate forum category.***
This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.
I have the same question (24)
Martin Geithmann commented
Agree that a better name manager is needed. The existing way the feature is laid out is confusing, the dialog boxes very small on high-res displays, and makes a powerful feature harder to use than it needs to be.
Michael Wagener commented
Excel for Mac is becoming really irritating these days and it all revolves around the crippled version of Name Manager that they are trying to pass off on us. One has to wonder what motivates them. I like Excel (in fact a lot of my life revolves around it... ), and I like Mac. Why can I not have a product that actually works? That would be nice, instead of having to accommodate work-arounds to get by. Like the current bug where one cannot open the Cell-Name section of the Edit-bar presently... oh my goodness me... ! It's exasperating...
Making Mac Name Manager feature identical to Windows version would be great. I didn't realize how much value the features on the Window platform added until I worked on my most recent project. Having to use the weak functionality of the Mac version of Name Manager has added literally 10-20% to the amount of time needed to accomplish the same tasks on the Windows version. In some instances, I can't accomplish what I want to at all.
Please add back the scope for the Name Manager. How can I pay for an upgrade that has removed features that have been part of the program for decades?
Yes, we would like the ability to define scope at global and local levels of named ranges, like you can already do on Windows Excel.
I have had to switch to mac office for a new job, and I can only echo how frustrating it is to not have a proper Name Manager. I use named ranges extensively, and the simple task of renaming a range has now created several additional tasks in order to update the reference to the range throughout the workbook. what other features of excel will I have to live without?
Command +F3 (or Command+fn+F3 depening in how yr keyboard is setup) opens the Define Name dialogue box, in the same way as Menu: Insert / Name / Define Name.
However the Define Name dialogue box does not have the same functionality as the Name Manager. It does not perform intelligent editing of the names of named areas.
The Name Manager is a handy work-around for places where formulas aren't accepted, such as in setting up dynamic charts. The Windows version lets you work in one window to do all you can with names, while with Mac we have Define, Paste, Create, Apply - separate operations instead of all in one place. How about making the Mac Name Manager mimic the Windows version.
Gene Albrecht commented
Where has the Name Manager for Mac (Excel 2016) gone? I have imported work done earlier on a Windows platform and now need to work with the named ranges...but cannot find a way to access the Name Manager. The suggestion I find on the web to push command +fn + F3 does not work.
Bill Kantor commented
Named ranges are such a great way to write and understand formulas. But this capability is severely impoverished wihtout a name manager where you can see and edit important attributes such as Scope. Please provide the same functionality as on the Windows version.