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.
Thanks for all your comments and votes supporting this suggestion. We will continue to monitor this forum.
Thanks – Steve K [MS 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.
Scope and editing of Names to allow dynamic ranges are essential. I don’t want to use Windows. I’d rather use a different spreadsheet. Give us parity please.
Me and my partner just signup up for Office 365 Home trial.
However, the Excel for Mac cannot be used properly without a real name manager. It's a deal breaker and I am going to cancel the trial. I wanted to pay for Office Mac, but now I will not. My only option now is to use Virtual Machine to run a non crippled version of Office. But due to the nasty attitude, I will not pay for that, there are other options...
I can see that this feature was requested years ago, yet it has been neglected. Therefore I deduct that it has been left out deliberately. I simply do not agree with the idea that you deliver - on purpose - a crippled version of Excel for Mac users, yet you charge the same fee.
Please understand that Mac users will not switch to Win machines, so this will just backfire on you.
I tend to search a lot, where excel 2016 will find what I'm looking for, but won't have it centered and looking at said found cell; and even stranger, is that sometimes it finds other things; so, I tend to have to needlessly scroll a lot.
Okay, hitting the right triangle to find again a few times will land the search (and even rarely focus correctly!), and at least there is the column letter and row number in the upper left; i.e. where you can also type to fill a cell, will be the full cell contents of any partial search I did, but just to the left of that is something like M482 (or just above where you click to select all, that triangle filled box to the left of A and above 1); you can then click on that field and hit enter, and then it *will* focus on that cell as it should have just done when searching; i.e. so why the wonky basic feature (who doesn't search a .xlsx?!), and at least why the extra click and key press to get to a successful find?!
Steve Cook commented
<sigh>...I am just getting started on Excel for MAC after a zillion years on PC. I was astonished to find the pitiful little "name manager" they offer. I have a ton of error names and can't even select multiples to delete. Give us what you design for Windows please. ASAP.
Gonçalo Veiga commented
I find it ironic that the Excel team that designed the application for Mac chose to leave out the Name Manager and its useful tools, like scope and edit a name. As a Mac user, I also paid for Excel, so this discrepancy is not only unfair but it always makes me think if this is a way to get Mac users to migrate to MS systems.
So, please add a Name Manager to Excel Max 2016.
I need a Name Manager that allows me to see the scope of a name and to edit the name. Ideally of course, the other features of the Windows Name Manager - sorting on name, range etc, filter for errors etc.
Agreed! My company uses named ranges and linked workbooks extensively, so we need to see both the cells a range refers to and its scope. Easy to do on Windows version. Why must Mac be left behind?
Using the name manager has been difficult for me recently. I used to be able to utilize the cell reference box to name a range quickly, however, now that doesn't seem to work unless I go to the dropdown toolbar to insert>name>define and then add the named range. It's quite cumbersome to use the toolbar menus and I wish that the cell reference box update would work like it used as well as the entire named range process function the same as the Windows version.
Loriel Smith commented
Why does Windows treat the Mac versions of their products like the ugly step child? The code to make the functions the same for both operating systems can't be THAT difficult. Specifically the "Name manager" tool. This is why I will always use Google Docs for my excel needs...
Andrew Lister commented
Just give us Mac users the same Name manager (and keyboard shortcut!) that is on the Windows version.
Im using 2016 for mac and can not use Name manager. Please fix this!!
Philip Bee commented
Here is a bug I've experienced, and can readily reproduce. Not sure which of the steps are salient and which are red herrings.
1) Import some data in columns from CSV. Save as .xlsx.
2) Define names for the table, such that the top rows of each column are the names.
3) Select one column. Do Conditional Formatting. Have it highlight Duplicate values
4) Select some set of cells within that column. Right click, and select Filter. Choose By Cell Color.
5) Observe the spinning beachball of death.
Yes, filter column "Refered to..."
Modify "Range" name of sheet to "ThisWorkbook" and otherwise
As someone who uses named ranges extensively, I agree very strongly with the other comments here:
1] 2016 for Windows allows for resizing the dialog box columns (with retention during the session) and 2016 for Mac should as well - why not?
2] the overall inelegance of the name manger is one thing that keeps me using Excel for MS on a VM rather than...along with a laundry list of other limitations in the Mac version
Mike H commented
Long names are impossible to see. Making the dialog box resizable would be a quick fix. Please make is so the size stays the same on subsequent views.