Forum Discussion
NO NAME MANAGER IN EXCEL ONLINE
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).
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.
PeterBartholomew1 Can't see why it wouldn't work. The only bit that seems to be missing is that you can't set the scope (ws or wb) of a Name. Haven't tried yet to create some of these on the desktop and see how they come across in the AFE on line.
yes, AFE doesn't support worksheet scope, doesn't matter online or offline. Names with worksheet scope are not shown.
Excel for web doesn't show names with worksheet scope in name box of another sheet. However, if type in formula it converts it to something like Sheet1!local and it works.
Hi Riny,
I'm unable to find the Excel Labs icon, which section of the ribbon is this in?
Thanks,
Josh
JoshuaPlank It was there when I made the screenshot. Now it isn't.
But, click the add-in icon on the far right. If you don't see Excel Labs in 'My Add-ins' you can perhaps find it in the list op 'Popular add-ins' or press the 'Add more' button and search for it and install it.
Thought it was there by default in the online version, but I guess you need to install it first.
