Excel for Mac - Delete Defined Names

Copper Contributor

Is there a way to delete / manage defined names in Excel for Mac?

 

I have created some names in a spreadsheet that I want to remove, but can't seem to find a way to remove them, there doesn't appear to be a Name Manager.

 

TIA

 

jP

2 Replies

@James Palmer 

I'm not a specialist in Office for Mac, but I think/hope this information might help you:).

Define and use names in formulas

By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names.

Hope I was able to help you with this info.

 

NikolinoDE

I know I don't know anything (Socrates)

@James Palmer In the most recent version of Excel for Mac there is a Name Manager, though perhaps still only for Insiders/Beta. Not sure though. See picture.

Screenshot 2022-01-02 at 16.00.18.png

In older versions you have to live with the list of Named Ranges in the window that opens when you click Define Name and use the minus sign, one-by-one to remove names.