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).
Riny_van_Eekelen My excel for mac version 16.58 does have it, but my colleague with the same version of excel does not. Any insights?
iamseb Don't. My original response is quite old. At the time (i.e. May 2021) Excel for the Mac did not have a Name Manager. But a few months ago it did show up in my MS365 subscription Excel version. and I'm an Insider as well. Not sure if it has been rolled out to all.