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