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.