Jan 02 2022 06:44 AM
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
Jan 02 2022 07:03 AM - edited Jan 02 2022 07:03 AM
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.
I know I don't know anything (Socrates)
Jan 02 2022 07:07 AM
@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.
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.