Named Cells (Ranges)

D

Derek Hart

If I name a cell, and want to change the name, in Excel 2003, there is no
easy way to do it. Do I have to delete the name, and add back a new one?
Very tedious...
 
S

ShaneDevenshire

Hi,

Actually you don't need to delete the old range name, just add the new name.
A range can have as many names as you like. Of course that clutters up the
list, but you can come back at some later time and delete unwanted names.
 
D

Dave Peterson

Just to add...

Be careful before you delete the old names. You'll want to change anything that
uses them--formulas, other names, VBA code...
 
B

Bob Phillips

That's one way to slow your workbook down, seeing as the redundant names
will all get recalculated every time.
 
Top