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