Stop carrying over text styles when pasting

J

J. Lou

How do I get Excel to stop carrying over text styles when pasting from Word
into Excel?
 
E

Elgee

Go to Edit--> Paste Special and choose your option from there. Most likely
Unformatted Text or Values will be what you want to choose.
 
J

J. Lou

Thanks Elgee!

So this can't be disabled on an application level? I use CTRL+C and CTRL+V
to copy and paste. It would be tedious to have to choose Paste Special every
time.
 
S

Sheeloo

You can add the Paste Special button to the ribbon (Excel 2007)

Alternatively you can hit CTRL-SPACE Bar before CTRL-C in Word (this will
remove formatting before copying to the Clipboard. You can hit CTRL-Z after
copying to restore the Word format in the original document...

If you are working in a non-commercial environment then you can use ASAP
Utilities (http://www.asap-utilities.com/download-asap-utilities.php) ... it
has a 'Clean Web imported data' which is wonderful. The toll itself is
GREAT... and FREE for non-commercial use.
 
Top