renaming cell ranges

[SargeUSMC]

I have mistakenly given the same range of cells 2 different range names, and Excel 13 won't let me assign the desired name to the proper range, because it already exists. Is there a way to change this?

 

[MyHelpster]

Hi,
Please go to FORMULAS Tab >> Name Manager >> Then delete the duplicate name range you want to remove. Please see the attached image for reference.