Morning everyone,

I have a spreadsheet which I've inherited from someone else and it has at least 100 named cells/ranges. While they are all valid (i.e. no #REF errors in the Name Manager) I can only really see that about 5 of them are being used in the calcs. I need to tidy up the spreadsheet so I want to delete the surplus names.

Is there a simple way to get excel to tell me if (and where) a named cell is used within the workbook or am I going to have to show formulas and search for each name seperately and delete it if I get no matches?

Thanks,

Alice