Format copying and pasting

**sandrav** · 10-22-2012, 10:51 AM

This might be really basic but I'm having the hardest time working this out. I'm editing a .xls file in Excel 2010 and for some reason I can only get text to copy and paste and I need the format (borders, text etc). I've tried the format painter and that pasted text too!!!

Any ideas on what setting has been changed that I wasn't aware of.

Thanks
Sandra

**BeachRock** · 10-22-2012, 11:04 AM

It sounds like you are trying to format cells that have some conditional format happening. Highlight the cells and then see what conditional formating is being applied to them.

**sandrav** · 10-22-2012, 11:57 AM

no, don't see any conditional formating and I've just tried opening another new excel 2010 and did borders and the format wouldn't copy and paste only the text so it seems like it's something to do with the whole program not just one file.

**BeachRock** · 10-22-2012, 05:03 PM

Take a look at this thread.

http://www.excelforum.com/excel-gene...t-working.html

Do you have Skype installed?

**sandrav** · 10-22-2012, 09:41 PM

That's exactly the same!! Thanks so much. So I guess there isn't a solution at this time if you want IE and excel open.
I can live with that!!!

I really appreciate your help!

**BeachRock** · 10-22-2012, 11:37 PM

Glad to help.

Please make sure to mark your thread as solved.

**Cutter** · 10-23-2012, 10:01 AM

@ sandrav

Actually, you don't have to live with it. There is a fix for it here: http://blogs.skype.com/garage/2012/0...ix_for_of.html

If you are satisfied with the solution(s) provided, please remember to mark your thread as Solved.

New quick method:
Select Thread Tools (above first post on page) -> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
Go to the first post
Click edit
Click Go Advanced
Just below the word "Title" you will see a dropdown with the words "No prefix".
Change to "Solved"
Click Save