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

  • Thread starter Thread starter phil1ray
  • Start date Start date
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.
 
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
 
If the cell contains a formula using relative references like =A1, then when
it's ctrl-dragged, it'll adjust to its new location.
 
How about Cut and Paste, then Copy it back and paste to its original location.
Then clear contents of that original location.
 
And if you copied that cell, then any formulas that point at it will still point
at the original location, too.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numbers change in cell even when formatted as text 4
drag and drop 5
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Click and drag 2
EXCEL - I can not drag a cell with text to another cell, 2
Text in Text-formatted cells changes to ### after the 255th charac 2
Stop XL from changing format? 1
protect cell format 1

Back
Top