How do I copy data into Excel and maintain the formatting?

G

Guest

I continuously copy data from the internet into an Excel 2007 spreadsheet.
How can I get the copied data to have the same formating as the spreedsheet
without continuosly having to click the smart tag and pick the "match
destination formatting"? I am seeking a way (via template or other means) of
doing this operation automatically without having to us the smart tag each
time. Thanks for your suggestions.
 

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

Bookmarks and exporting data into Excel 1
Excel 2007 Loses Formatting 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
how do I maintain formating when sending excel document? 1
How do I maintain columns when I copy JMP data into Excel? 0
How to copy a whole Excel spreadsheet page in 2007 vs 2003? 2
How do I import from csv file without auto formatting? 4
Access Import MS Outlook messages into MS Access - The Email Body Loses Formatting 0

Top