Rename Cell Name

[Guest]

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

 

[JulieD]

Hi Dragon

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

Cheers
JulieD

 

[Nick Hodge]

Dragon

Insert>Name>Define

http://www.nickhodge.co.uk/gui/insertmenu.htm#Name

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Guest]

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

 

[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.