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).
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.
