Forum Discussion
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??
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).
I agree, no name manager is an issue.
A possible workaround for some naming would be to use Office Scripts. For example, you would be able to set the name of a table using table.setName(name).
A possible workaround for some naming would be to use Office Scripts. For example, you would be able to set the name of a table using table.setName(name).