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 There is no Name Manager in MacOs. It's what you show in your picture "Define Name" (see picture) where you add, delete and edit named ranges/formulae. But there is nothing that compares to the Name Manager in the Windows version.
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...😂😂
