Name Range - Removing

[McDan1el]

Hi All,

I accidentally named 2 different ranges the same name (i have 60 Team blocks, and naming then all Team1...Team60) - Unfortunately I named Team32, Team42 as well - so when i select either Team32 or Team42 it points to the same range - i have tried selecting the appropriate range for Team42 and calling it that but it jumps back to the range for Team32.

How can i clear them to start again?

Thanks,

 

[xld]

Delete the name and the re-assign it.

 

[McDan1el]

Where is the menu for that, i normally just use the quicklink bit in the left corner - and i have tried to delete that but to no success as its still in the list... yes i know - excel n00b!

 

[xld]

Insert>Name>Define...

or

Alt-I-N-D

or

or Ctl-3

 

[McDan1el]

Hah!

Found it... Insert > Name

Thanks,