Forum Discussion
Solved
NO NAME MANAGER IN EXCEL ONLINE
When I get to know that there is no name manager in excel online, I got a shock by this. Now tell me how to name formulas and ranges without the name manager??
lorenzocs Let's say I want to name the range A1:A20 "myNamedRange"
Step 1: Formula ribbon, Define Name
Step 2: Enter the name you want to use, click in the "Select the range......" field.
Step 3: Click on the "collapse"-button (far right in the "Select the range....." field) and select the range to be named (or directly write the reference of the range as indicated). Press OK.
Step 4: Select A1:A20. In the Name box, you can now see the name given to that specific range.
Step 5: In the Define Name window, you can now see the named range that you just created. Edit (change name and/reference) or Delete (the minus sign) or Create a new one (the plus sign).
- Press Ctrl + F3 to open "Name Manager"
As a comment, Name Manager in Excel for Web appeared recently relative to the date of this post. And I'm not sure what for all subscriptions.
It's not the easiest to use, but I've found that you can still create and view named ranges by selecting your range, and clicking on the 'Name Box' in the top left corner, to the left of the formula bar (image attached)
I'm not as sure on how to edit names easily once you've made them, but it's a start. Hope this helps.
JoshuaPlank The original post was about the missing Name Manager in Excel On-line. It's still not there, but with the introduction of Excel Labs quite some time ago, it is possible to add, edit and delete named ranges in the on-line version.
Find and press the Excel Labs icon.
Open the Advance Formula Environment in the side window.
Now click on Names and then Ranges.
The + sign lets you add Named Ranges, the pen symbol is for editing existing ones and the waste bucket to delete them. Not all desktop features are present, but at least you can add, edit and delete named ranges on-line.
Hi Riny. I will have to try this; I must admit that I had wondered whether the AFE would be usable but hadn't got around to testing it out. Without a Name Manager the online version of Excel is unusable; it allows me to achieve nothing of interest.
I could still do with form controls but, with a bit of luck, the new check marks at least will find their way online in order to provide at least a limited level of interactivity.
- It's such a frustration to buy a car without doors and hear: "well, if you need doors - just use the other car"...
- The lack of named ranges and named functions in the online version together with the impossibility to dynamically import ranges from another online sheet (importrange) are the main reasons my company cannot switch to Excel. It is very strange that Microsoft doesn't understand that modern companies want to have their data in the cloud and nothing on the PCs of their employees.
I agree. I am mobile (on the road) often and need to easily amend my Excel worksheets from my mobile phone. I just discovered the lack of named cell functionality. Does anyone know when Microsoft intend to roll out this feature in the Excel application for Android phones? I am using version 1.0.1 (16.0.16130.20188).
Thank you,
Jason.
- I agree, no name manager is an issue.
A possible workaround for some naming would be to use Office Scripts. For example, you would be able to set the name of a table using table.setName(name). The lack of any controls, event handlers and name management in 365 online all came as something of a shock to me. Any names present in a workbook ported from the pc desktop still work and names appear in the type script object model. It might therefore be possible to upload names/comments/&formulas from the grid to the workbook using the automate functionality. I have still to try this though.
Short answer is to use Excel 365 desktop on Windows. All other versions (Excel for web, Excel on Mac, Excel mobile, etc) have limited functionality compare to it.
Excel for web is developed quite fast, perhaps this functionality will be available as well relatively in a short while.
- A number of companies, small and large, no longer want users to store data on their PCs. They want it all in the cloud, for very good reasons: when an employee leaves the company, migrating their data to someone else is easy; when an employee is OOO, allowing others to access the latest data is easy; when you want to revert to an earlier version, this is very easy (provided your cloud provider enables this - flee from any who doesn't).
So recommending to use a desktop version in the age of Internet is akin to saying that Microsoft is so stuck in the 80s (last millenium) that it will never evolve. I hope this isn's true.These are different things. I also keep all my data on the cloud, but prefer to use desktop client working with located on the cloud files.
In the age of internet Desktop client is quite good integrated with the cloud, in general local storage could be needed only to work with temporary files. However, mapping is more reliable.
- Sergei is apparently correct. One must not use the Excel for Android version 1.0.1, which provides no ability to name cells. Nor does it allow you to edit or use names in your formulas. It does allow already existing names to work, but no other functionality is offered.
Jason. Why is there no "Name Manager" (GESTIONE NOMI in Italian) in the Excel version for macOS on the FORMULAS tab?
On Windows, I can edit, delete cell names, on Mac it is not possible.
1 Photo: MacOS
2 Photo: Windows
lorenzocs There is no Name Manager in MacOs. It's what you show in your picture "Define Name" (see picture) where you add, delete and edit named ranges/formulae. But there is nothing that compares to the Name Manager in the Windows version.
