|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
05-07-2007, 10:32 PM
|
#1 |
|
Member (8 bit)
Join Date: Apr 2003
Posts: 161
|
Microsoft Excel Question
I'm using Excel on a PC (2002 Office Version I believe). Anyway, I have a spreadsheet with a bunch of color coded cells. I have another spreadsheet with a bunch of data I need entered into those color coded cells. Is there anyway to copy the text from one spreadsheet to the other spreadsheet with the color coded cells without erasing the background colors? At the moment when I use copy and paste it not only copies the text but overwrites the existing background color.
|
|
|
|
05-07-2007, 11:26 PM
|
#2 |
|
Member (4 bit)
Join Date: May 2007
Posts: 10
|
This should work. After you copy the data and are ready to paste it,
->right click->select "Paste Special" -> select "Values" -> "OK" |
|
|
|
|
05-07-2007, 11:30 PM
|
#3 |
|
Member (8 bit)
Join Date: Apr 2003
Posts: 161
|
Thank you, you are a life saver
|
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel Formula Question | Dswissmiss | Software Discussion & Support | 2 | 04-30-2007 03:32 PM |
| Windows XP, Microsoft OEM System builder, RAID Question | Charlie W | Build Your Own PC | 7 | 11-19-2006 11:23 PM |
| Excel question | Dominion | Software Discussion & Support | 2 | 01-20-2006 09:10 AM |
| Pest - browser hijacked | mb26 | Internet, Web Applications, & The Cloud | 21 | 06-08-2004 09:08 AM |
| Microsoft creating Windows for supercomputers | toomyg | General Discussion | 14 | 05-27-2004 06:22 PM |
Linear Mode
