Drag and drop without changing the format of the cell left behind

P

phil1ray

I would like to move text from one cell to another without losing the
format of the cell I draged it from, or have the format auto revert
back after I drop the cell.
 
J

jeff

I don't know of a way to do this. Why not
CTRL-Drag (copy/drag)? It'll keep the original
contents in the originating cell along with
the formatting.

jeff
 
D

Dave Peterson

If the cell contains a formula using relative references like =A1, then when
it's ctrl-dragged, it'll adjust to its new location.
 
D

Dave Peterson

How about Cut and Paste, then Copy it back and paste to its original location.
Then clear contents of that original location.
 
D

Dave Peterson

And if you copied that cell, then any formulas that point at it will still point
at the original location, too.
 
Top