What is easiest way to move name to another cell?
What is the easiest way to move the name of a cell
to another cell?
What I mean is: suppose the name "foobar" is associated
with C1, and now I want to associate "foobar" with C2
instead.
The intuitive method does now work for me [1]: click on
the new cell (C2), highlight then cell name in the Name
Box, and type "foobar". That goes to C1.
Currently, I must click on Insert / Name / Define,
highlight the name, and manually change the Refers To
reference.
[1] Excel 2002 (10.5815.6714) SP3
|