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).
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).
Riny_van_Eekelen What and where is this define name window you speak of?
This is an old thread that started by asking where the name manager sits in Excel On-line. At the time there was no such thing in the on-line version. Then the discussion moved to using it the desktop version on a Mac. And that's how my answer got marked.
If you are still looking for the name manger in Excel on-line, there isn't one. But you can install the Excel Labs add-in and do all sorts of neat things nowadays, including naming ranges. Although it looks nothing like the traditional name manager you find in the desktop versions. See my posts from 4 and 8 March above.
Riny_van_Eekelen's reply refering to the add-in "Excel Labs" is very helpful.
Having searched all over the Internet, I feel the discussion here is valuable.
To provide some icing on the cake, I would like to share another blog post illustrating how to install and use this add-in "Excel Labs."
The blog post is here:
https://dashz.substack.com/p/name-manager-in-excel-online
- A lot of thanks to you! I didn’t understand how to delete...it was only the minus sign...😂😂
