renaming cell ranges

SargeUSMC

SargeUSMC

Joined
Apr 25, 2012
Messages
8
Reaction score
1
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

MyHelpster

Joined
Jul 3, 2014
Messages
9
Reaction score
0
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.
Illustration 1.png
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA for Dependents shortcut menu 0
Range headings 0
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
Merging from an Excel file with graphics 1
Pasting a cell into bookmarked table from excel vba 1
Excel - Wich Function should I use? 1
Restoring Overwritten Files 2

Top