Forum Discussion
I can't find Name Manager dialog box displayed in my ribbon bar (excel 365)
Dear community, Can anyone tells me how to insert or display the Name Manger dialog box in my ribbon bar in excel 365. I am currently using a HOME edition of Office 365. I need the name manager...
Alternatives could be
- install Excel Labs add-in from Microsoft and within it use Advanced Formula Environment
- you may define named ranges in Name Box (to the left from Formula Bar) and check existing names from its drop-down
Thanks Sergei,
I think i will download a copy of the workbook and edit it in desk version than i will upload it back to drive with the needed changes.
I hoped that there is a simple way of managing names without downloading every time a copy of the workbook.
I appreciate your answer.
Thank you,
I think i will download a copy of the workbook and edit it in desk version than i will upload it back to drive with the needed changes.
I hoped that there is a simple way of managing names without downloading every time a copy of the workbook.
I appreciate your answer.
Thank you,
Razvan_Morogan When you've opened the file in the browser you can then click that Edit button to open in desktop. There should be no need for downloading, saving and uploading as the file automatically saves from desktop. Are you not using OneDrive or Sharepoint by any chance?
AFE is simple enough, but all depends on goals
