Copying defaults

A

attyshane

how do i change the copying defaults in office. I did it yesterday but
cannot duplicate. I want to change copying to copy just text and not
formatting of source document and I don't want to have to convert excel table
to text--i want to be able to just copy the text only

thanks

s
 
G

Gord Dibben

Copy>Paste Special>Values.

Or possibly

Copy>Paste Special>Text

If you did it yesterday without the Paste Special perhaps you had two
workbooks open, each in a separate instance of Excel.


Gord Dibben MS Excel MVP
 

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

Copy and Paste 2007 1
Zip Code formatting problem 3
Autofill defaults 4
Copy and paste slow 1
format cells as zip code not working 3
Copy & Paste defaults 2
Paste contents, but keep formula of destination 2
Pivot table copy and pasteing 2

Top