Copy/paste question

R

Randy Harris

I would like to move the contents of one cell to another. The cell has a
background fill. When I do a cut/paste, the cell which was cut from, loses
its style (changes to white background and loses the border). How can I do
a cut/paste and not lose the formatting?
 
K

Ken Russell

Copy/paste instead of cut/paste.

--
Ken Russell

| I would like to move the contents of one cell to another. The cell has a
| background fill. When I do a cut/paste, the cell which was cut from,
loses
| its style (changes to white background and loses the border). How can I
do
| a cut/paste and not lose the formatting?
|
|
 
P

Paul

Randy Harris said:
I would like to move the contents of one cell to another. The cell has a
background fill. When I do a cut/paste, the cell which was cut from, loses
its style (changes to white background and loses the border). How can I do
a cut/paste and not lose the formatting?
Click to expand...

If you want to copy the formatting to the new cell and also leave it in the
original cell, use copy/paste (rather than cut/paste) and then clear the
contents of the original cell (select it and press Delete key).

If you want to leave all cells formatted as before, but simply transfer the
contents from one cell to another, use copy/paste special, values and then
clear the contents of the original cell as above.
 
Top