Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,268
Default How do I copy data into Excel and maintain the formatting?

What kind of data, you can import tables/lists via web queries?

--
Regards,

Peo Sjoblom


"tshirttom" wrote in message
...
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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I copy and paste a worksheet and maintain all formatting? jana Excel Worksheet Functions 2 September 19th 06 10:08 PM
How do I maintain columns when I copy JMP data into Excel? MPTfan Excel Discussion (Misc queries) 0 May 22nd 06 09:38 PM
How do I maintain my date format, when I copy a sheet, in excel? DHT Excel Discussion (Misc queries) 2 June 29th 05 03:31 AM
Lotus 123 save as excel workbook and maintain formatting? Don Excel Discussion (Misc queries) 0 December 8th 04 12:15 AM
Lotus 123 save as excel workbook and maintain formatting? Don Excel Discussion (Misc queries) 0 December 8th 04 12:11 AM


All times are GMT +1. The time now is 09:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"