Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Excel tables to Word--Best Solution?

I've been given a large number of Excel tables to import into Word (very
lengthy, very complex, and very difficult). Now, a straight copy and paste is
a funny experience and it will take a lot of time to manually tweak every
single column and row so everything works in Word. Does anyone know of a way
to make Excel tables a bit more "Word friendly?" Thanx!

Erik
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default Excel tables to Word--Best Solution?

Are you wanting to transfer the Excel information as Static or Dynamic? How
have you transfered information from Excel format to a Word format up to this
point?
--
William<"M"
Using 2007


"erik_gregory" wrote:

I've been given a large number of Excel tables to import into Word (very
lengthy, very complex, and very difficult). Now, a straight copy and paste is
a funny experience and it will take a lot of time to manually tweak every
single column and row so everything works in Word. Does anyone know of a way
to make Excel tables a bit more "Word friendly?" Thanx!

Erik

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default Excel tables to Word--Best Solution?

I want to transfer static tables to Word. My poor method to date has been
copying and pasting from Excel to Word, and then the exhaustive reformat. Any
workaround? Thanks!

E

"Sunday88310" wrote:

Are you wanting to transfer the Excel information as Static or Dynamic? How
have you transfered information from Excel format to a Word format up to this
point?
--
William<"M"
Using 2007


"erik_gregory" wrote:

I've been given a large number of Excel tables to import into Word (very
lengthy, very complex, and very difficult). Now, a straight copy and paste is
a funny experience and it will take a lot of time to manually tweak every
single column and row so everything works in Word. Does anyone know of a way
to make Excel tables a bit more "Word friendly?" Thanx!

Erik

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 103
Default Excel tables to Word--Best Solution?

Link Excel in word Allows editing in Excel and updates to word
Select Cells-- Click Copy-- Make Word Active
Position Insert point -- Click Edit and Paste Special @ the dialog
Box click Microsoft office Excel worksheet Object. Click Paste Link
Close dialog Box, remove check mark from Pictures Placeholder
Save Print
If you have questions please open a new requeste under same subject.
The other two ways are Copy and paste which is completely static
The other is to Embed which allows edit in word and updates in Excel.

--
William<"M"
Using 2007


"erik_gregory" wrote:

I want to transfer static tables to Word. My poor method to date has been
copying and pasting from Excel to Word, and then the exhaustive reformat. Any
workaround? Thanks!

E

"Sunday88310" wrote:

Are you wanting to transfer the Excel information as Static or Dynamic? How
have you transfered information from Excel format to a Word format up to this
point?
--
William<"M"
Using 2007


"erik_gregory" wrote:

I've been given a large number of Excel tables to import into Word (very
lengthy, very complex, and very difficult). Now, a straight copy and paste is
a funny experience and it will take a lot of time to manually tweak every
single column and row so everything works in Word. Does anyone know of a way
to make Excel tables a bit more "Word friendly?" Thanx!

Erik

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
copying word tables into excel vmwexway Excel Worksheet Functions 0 March 1st 06 03:33 PM
copying word tables into excel vmwexway Excel Worksheet Functions 0 March 1st 06 03:32 PM
Automating import of Word tables into Excel Han Excel Discussion (Misc queries) 0 January 18th 06 08:42 AM
Copy Word tables to Excel Don Excel Discussion (Misc queries) 3 February 13th 05 04:31 PM
most effective way to link ms word tables to excel Mark S Lloyd Excel Discussion (Misc queries) 0 November 26th 04 08:11 PM


All times are GMT +1. The time now is 01:34 AM.

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"