Forum Discussion

VivekDholakia's avatar
VivekDholakia
Copper Contributor
May 08, 2021
Solved

NO NAME MANAGER IN EXCEL ONLINE

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?? 
Excel for web
office 365
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    May 09, 2021

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

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 08, 2021

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.

lorenzocs's avatar
lorenzocs
Copper Contributor
May 08, 2021

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

 

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    May 08, 2021

    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.

    • iamseb's avatar
      iamseb
      Copper Contributor
      Feb 22, 2022

      Riny_van_Eekelen My excel for mac version 16.58 does have it, but my colleague with the same version of excel does not. Any insights?

      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Feb 22, 2022

        iamseb Don't. My original response is quite old. At the time (i.e. May 2021) Excel for the Mac did not have a Name Manager. But a few months ago it did show up in my MS365 subscription Excel version. and I'm an Insider as well. Not sure if it has been rolled out to all.

    • lorenzocs's avatar
      lorenzocs
      Copper Contributor
      May 08, 2021
      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?
      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        May 09, 2021

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

Resources