Sep 25 2023 02:51 AM
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 for data validation.
Many thanks,
Sep 25 2023 02:57 AM
@Razvan_Morogan Are you using Excel on-line (in a browser window) by any chance? It doesn't have Name Manager.
Sep 25 2023 03:06 AM
Sep 25 2023 03:46 AM
Open the workbook in the desktop version of Excel.
Sep 25 2023 04:36 AM
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
Sep 25 2023 04:51 AM
Sep 25 2023 04:51 AM
Sep 25 2023 06:00 AM
AFE is simple enough, but all depends on goals
Sep 25 2023 07:14 AM
@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?