Name Range - Removing

McDan1el

Board Regular
Joined
Sep 14, 2007
Messages
89
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,
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

McDan1el

Board Regular
Joined
Sep 14, 2007
Messages
89
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! :)
 

Watch MrExcel Video

Forum statistics

Threads
1,123,281
Messages
5,600,704
Members
414,401
Latest member
grenona2020

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top