Forum Discussion
NO NAME MANAGER IN EXCEL ONLINE
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).
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.