View Single Post
  #1   Report Post  
Help Me
 
Posts: n/a
Default 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