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
A better idea would be a Names sheet. Just reusing the existing spreadsheet interface, as that's already really commonly used by everyone and well understood. Then you could also import names from CSV etc. which would be very beneficial. Finally it'd be cross platform also.
You can actually do this with VBA, and it's actually not that hard either...
Leonardo Valenca commented
Plus, the REAL crux of the matter here is to make a BETTER NAME MANAGER ACROSS ALL PLATFORMS, meaning a tool that featurewise is more closely related to the formula bar for instance, which would allow for better editing, visualization, etc. The way it currently is simply sucks, makes working with name manager a lousy chore...
I am happy to read this, but being a sarcastic person when it goes about MS.
I did ask this 10+ years ago, and posted the request here almost 6 years ago. Wow, amazing how quick MS is to recognise what their users need.
Will it be available before the end of next month, or...
Please add the Name Manager Function to Excel Mac. It's a crucial tool.
WHEN? (too frustrated not to shout)
Tim Moran commented
I’ve just started to update/Re-write a number of complex financial models porting to use the new dynamic arrays functions. What a nightmare without a Names Manager. I’ve been using Excel since 1990. I moved to MACs in 2012. I’ve managed to date without the Names Manager feature because I’m more of a casual user and add to my existing models infrequently. But trying to re-hash everything from legacy to dynamic without a decent Names Manager is a killer.
Zafar Aziz commented
I extensively use the name range manager in building complicated Excel valuation models. I have some ideas / suggestion which if incorporated would be of great help to me (and potentially others). If I want to share my ideas/suggestion what would be the best medium
Dave McEvoy commented
Just read Kevin McCauley's comment. where's your evidence? Why can't Excel be agnostic to platform? Please avoid cheap shot answers to that.
Dave McEvoy commented
This can't be right. Only 2 votes for something that other forums suggest users have been asking for 10 years. Please add Name Manager for tables and referenced ranges in Excel for Mac. My vote makes 3.
Andrew 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.
The name manager in Excel for Mac is virtually non-existant compared to the version in Windows. Please add the same functionality for the Mac-version.
Kevin McCauley commented
Microsoft should delete Name Manager in Windows too. After all no one uses this feature. You could probably save a few thousand dollars. #MicrosoftIsCheap
The Define Name dialog box should be larger and/or should be able to be resized by the user. I have workbooks with a hundred names and I can see about five at a time.
No name manager still? Impossible to work with names in excel for MAC!
Include it please ini Excel for Mac
John Henry commented
Truly unbelievable how long this has gone on for. Excel has had a stranglehold on analytics for decades - not without reason of course. But this sort of wilful disregard for Mac users, in a world where tools like Tableau, Smartsheet, Airtable and Google Sheets are growing, is just ridiculous.
This feature has been talked about in every Excel for Mac version going back to Excel 2011. It's 2020. As a developer who works with Excel for Windows and Mac platforms, I'm really surprised that Microsoft did not include or implement this desperately needed feature in Excel for Mac.
It is almost impossible to edit and manage hundreds of range names and multiple Table names in Excel for Mac without a feature like Name Manager that's found in Excel for Windows. This makes it more difficult to natively implement solutions in Excel on the Mac platform. I'm developing and testing workbook templates for use on both platforms and these include VBA code, as well as data connections to queries in a SQL Server 2017 database. The Name manager vastly simplifies the process of troubleshooting and fixing problems with range and table names - for example, broken references. At the end of the day, I have no choice but to only use Excel for Windows in order to develop solutions, and then open and test the solutions on the Mac platform for compatibility, and then go back to Windows to make adjustments. Going back and forth is not very efficient.
Also baffling is that in the Mac version, the Excel for Mac Help topic provides instructions on using the Name Manager in the Excel for Mac version.
dominique fischer commented
I am ready to throw away my Mac. Most of what I need does not work as well... OH! shuck...Maybe it's exactly what MS is hoping by providing sub-standard versions of their products for the Mac!!!
Courtney Nafus commented
It's very disappointing that this feature isn't compatible with MAC OS, seems like it would be very easy to develop on their end! There are a massive amount of MAC/Microsoft users, capitalize folks!
John E Burke commented
ARRRRRRRRRGH I have been wrestling with this for years without realizing that the PC folks had the name manager tool I have been wishing for on the Mac since 2010 or so. PLEASE!