Excel 2010 - Dropdown item change

[Badgers]

HI,

I have a dropdown list in excel and I want to rename one of the items, but I have already selected those items in the excel sheet.

When I change it, the others selected don't change, does anyone know how to make this dynamic to save me reselecting the change..

Thanks

 

[SkipVought]

Edit > Replace maybe?

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]