How do I copy color text & paste keeping color
 

How do you copy text from a cell and paste it to another cell and Keep its
origianl color?

How do I copy color text & paste keeping color
 

EXCEL 2007

1. In cell A1 I have the word smith with a background colour of yellow.

2. Do a Ctrl-C in cell A1 to copy the cell contents.

3. Do a Ctrl-V in cell D8 (for example) and cell contents are copied across
with identical formats.

If my comments have helped please hit Yes.

Thanks.



"bduck" wrote:

How do you copy text from a cell and paste it to another cell and Keep its
origianl color?

How do I copy color text & paste keeping color
 

Doesn't it paste the formatting for you when you just do a copy|paste?

If no, you may want to explain what you're doing and what happens.

bduck wrote:

How do you copy text from a cell and paste it to another cell and Keep its
origianl color?

--

Dave Peterson

How do I copy color text & paste keeping color
 

Copy the cell, rather than copying from the formula bar.
--
David Biddulph


"bduck" wrote in message
...
How do you copy text from a cell and paste it to another cell and Keep its
origianl color?