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.

bouvierjr's avatar
bouvierjr
Copper Contributor
Mar 09, 2024
A number of companies, small and large, no longer want users to store data on their PCs. They want it all in the cloud, for very good reasons: when an employee leaves the company, migrating their data to someone else is easy; when an employee is OOO, allowing others to access the latest data is easy; when you want to revert to an earlier version, this is very easy (provided your cloud provider enables this - flee from any who doesn't).

So recommending to use a desktop version in the age of Internet is akin to saying that Microsoft is so stuck in the 80s (last millenium) that it will never evolve. I hope this isn's true.
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Mar 09, 2024

    bouvierjr 

    These are different things. I also keep all my data on the cloud, but prefer to use desktop client working with located on the cloud files.

    In the age of internet Desktop client is quite good integrated with the cloud, in general local storage could be needed only to work with temporary files. However, mapping is more reliable.

Resources