View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tshirttom tshirttom is offline
external usenet poster
 
Posts: 1
Default How do I copy data into Excel and maintain the formatting?

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.