SOLVED

NO NAME MANAGER IN EXCEL ONLINE

%3CLINGO-SUB%20id%3D%22lingo-sub-2337678%22%20slang%3D%22en-US%22%3ENO%20NAME%20MANAGER%20IN%20EXCEL%20ONLINE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2337678%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20I%20get%20to%20know%20that%20there%20is%20no%20name%20manager%20in%20excel%20online%2C%20I%20got%20a%20shock%20by%20this.%20Now%20tell%20me%20how%20to%20name%20formulas%20and%20ranges%20without%20the%20name%20manager%3F%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2337678%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2337722%22%20slang%3D%22en-US%22%3ERe%3A%20NO%20NAME%20MANAGER%20IN%20EXCEL%20ONLINE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2337722%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1021883%22%20target%3D%22_blank%22%3E%40VivekDholakia%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EShort%20answer%20is%20to%20use%20Excel%20365%20desktop%20on%20Windows.%20All%20other%20versions%20(Excel%20for%20web%2C%20Excel%20on%20Mac%2C%20Excel%20mobile%2C%20etc)%20have%20limited%20functionality%20compare%20to%20it.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EExcel%20for%20web%20is%20developed%20quite%20fast%2C%20perhaps%20this%20functionality%20will%20be%20available%20as%20well%20relatively%20in%20a%20short%20while.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2337836%22%20slang%3D%22en-US%22%3ERe%3A%20NO%20NAME%20MANAGER%20IN%20EXCEL%20ONLINE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2337836%22%20slang%3D%22en-US%22%3E%3CP%3EWhy%20is%20there%20no%20%22Name%20Manager%22%20(GESTIONE%20NOMI%20in%20Italian)%20in%20the%20Excel%20version%20for%20macOS%20on%20the%20FORMULAS%20tab%3F%3C%2FP%3E%3CP%3EOn%20Windows%2C%20I%20can%20edit%2C%20delete%20cell%20names%2C%20on%20Mac%20it%20is%20not%20possible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1%20Photo%3A%20MacOS%3C%2FP%3E%3CP%3E2%20Photo%3A%20Windows%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Schermata%202021-05-08%20alle%2015.56.01.png%22%20style%3D%22width%3A%20850px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F279294i1876B2D0903EE5FA%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Schermata%202021-05-08%20alle%2015.56.01.png%22%20alt%3D%22Schermata%202021-05-08%20alle%2015.56.01.png%22%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Schermata%202021-05-08%20alle%2015.56.22.png%22%20style%3D%22width%3A%20616px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F279295iA3BE6FE920288EA0%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Schermata%202021-05-08%20alle%2015.56.22.png%22%20alt%3D%22Schermata%202021-05-08%20alle%2015.56.22.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2337863%22%20slang%3D%22en-US%22%3ERe%3A%20NO%20NAME%20MANAGER%20IN%20EXCEL%20ONLINE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2337863%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1048604%22%20target%3D%22_blank%22%3E%40lorenzocs%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%2C%20I%20have%20no%20experience%20with%20Excel%20for%20Mac%2C%20perhaps%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3Bcould%20clarify.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2337942%22%20slang%3D%22en-US%22%3ERe%3A%20NO%20NAME%20MANAGER%20IN%20EXCEL%20ONLINE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2337942%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1048604%22%20target%3D%22_blank%22%3E%40lorenzocs%3C%2FA%3E%26nbsp%3BThere%20is%20no%20Name%20Manager%20in%20MacOs.%20It's%20what%20you%20show%20in%20your%20picture%20%22Define%20Name%22%20(see%20picture)%20where%20you%20add%2C%20delete%20and%20edit%20named%20ranges%2Fformulae.%20But%20there%20is%20nothing%20that%20compares%20to%20the%20Name%20Manager%20in%20the%20Windows%20version.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-05-08%20at%2017.32.58.png%22%20style%3D%22width%3A%20202px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F279300i15A0F2BB859DC72E%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-05-08%20at%2017.32.58.png%22%20alt%3D%22Screenshot%202021-05-08%20at%2017.32.58.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

When I get to know that there is no name manager in excel online, I got a shock by this. Now tell me how to name formulas and ranges without the name manager?? 

8 Replies

@VivekDholakia 

Short answer is to use Excel 365 desktop on Windows. All other versions (Excel for web, Excel on Mac, Excel mobile, etc) have limited functionality compare to it.

 

Excel for web is developed quite fast, perhaps this functionality will be available as well relatively in a short while.

Why is there no "Name Manager" (GESTIONE NOMI in Italian) in the Excel version for macOS on the FORMULAS tab?

On Windows, I can edit, delete cell names, on Mac it is not possible.

 

 

1 Photo: MacOS

2 Photo: Windows

 

Schermata 2021-05-08 alle 15.56.01.pngSchermata 2021-05-08 alle 15.56.22.png

@lorenzocs 

Sorry, I have no experience with Excel for Mac, perhaps @Riny_van_Eekelen could clarify.

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

Screenshot 2021-05-08 at 17.32.58.png

I tried “Define Name” but i can only name a cell. I can’t edit/delete a given name...could you show me how it’s done on Mac?
best response confirmed by allyreckerman (Microsoft)
Solution

@lorenzocs Let's say I want to name the range A1:A20 "myNamedRange"

Step 1: Formula ribbon, Define Name

Screenshot 2021-05-09 at 06.20.39.png

Step 2: Enter the name you want to use, click in the "Select the range......" field.

Screenshot 2021-05-09 at 06.21.23.png

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.

Screenshot 2021-05-09 at 06.21.51.pngScreenshot 2021-05-09 at 06.22.02.png

Step 4: Select A1:A20. In the Name box, you can now see the name given to that specific range.

Screenshot 2021-05-09 at 06.22.40.png

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

Screenshot 2021-05-09 at 06.22.57.png

A lot of thanks to you! I didn’t understand how to delete...it was only the minus sign...

@VivekDholakia 

The lack of any controls, event handlers and name management in 365 online all came as something of a shock to me.  Any names present in a workbook ported from the pc desktop still work and names appear in the type script object model.  It might therefore be possible to upload names/comments/&formulas from the grid to the workbook using the automate functionality.  I have still to try this though.