Rename Cell Name

D

Dragon

hey all, i have change the cell anem from A1 to StartCell. Bu, how can i
rename it back to A1 or change it to another name?
Thanks in advance
Regards
Dragon
 
J

JulieD

Hi Dragon

go into insert / name / define - you can delete the name there and create
another if you wish.

Cheers
JulieD
 
D

DragonYian

Dear JulieD,
i cant delete the name by using the method you used, you know why? is that
because that name was referring bu other cell in the calculation?
Regards
Dragon
 
J

JulieD

Hi

okay then, if you have a name StartCell and it refers to cell A1 and you've
used it in formulas e.g.
=StartCell+B1 or whatever
then
do a edit / replace
find: StartCell
replace with: A1
replace all
this will change the above formula to
=A1+B1
you can then delete the name.

Cheers
JulieD
PS do on a copy of your workbook first and check it - i only checked it on a
few types of formulas.
 
Top