Find and delete cell names not used in any formulae

[excel_stuff]

Hi listers,

This is probably a simple question for many of you. I am working with someone else's workbook and have renamed cells and some names are redundant. So I want to find (and maybe list) all cells that are not used in any formula in the workbook and then delete them. Is there an easy and quick way to do it?

Thanks
Shehzad

 

[NARAYANK991]

Hi ,

Probably the easiest and safest way is to use the Name Manager add-in by Jan Karel Pieterse :

http://www.jkp-ads.com/officemarketplacenm-en.asp

Narayan

 

[excel_stuff]

thank you. I'll give this one a go.