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

boouvierjr's avatar
boouvierjr
Copper Contributor
Feb 11, 2023
The lack of named ranges and named functions in the online version together with the impossibility to dynamically import ranges from another online sheet (importrange) are the main reasons my company cannot switch to Excel. It is very strange that Microsoft doesn't understand that modern companies want to have their data in the cloud and nothing on the PCs of their employees.
  • JasonYoungWesternAustralia's avatar
    JasonYoungWesternAustralia
    Copper Contributor
    Mar 20, 2023

    boouvierjr 

    I agree.  I am mobile (on the road) often and need to easily amend my Excel worksheets from my mobile phone.  I just discovered the lack of named cell functionality.  Does anyone know when Microsoft intend to roll out this feature in the Excel application for Android phones?  I am using version 1.0.1 (16.0.16130.20188).

    Thank you,

    Jason.

Resources