How do I copy color text & paste keeping color

B

bduck

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

trip_to_tokyo

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.
 
D

Dave Peterson

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.
 

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

Match table shading (color) to Visio color/Transparency 1
Need help modifying code 0
Student & Home? 1
Tracked changes by multiple people modified to one 0
How to paste this down? 3
Layout Guide color 0
Change text color with an IF statement 5
Copy addition formula of non-consecutive horizontal cells 2

Top