Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.tables
C. Van Dam C. Van Dam is offline
external usenet poster
 
Posts: 1
Default How do you import an Excel table into Word without losing format?

I'm trying to import Excel spreadsheets into Word (as tables), but no matter
how I do it (I've tried copy/paste, as well as insert file), the formatting
applied in the Excel spreadsheet is scrambled when the data is pulled into
the Word table.

I've searched the help files, and have followed the directions step by step
to no avail. If anyone can suggest a way to pull this data into Word without
requiring massive formatting fixes afterwards, it would be much appreciated.
The tables end up so screwed up in the Word document that it's easier to
retype the entire table than it is to fix the formatting.

Thanks in advance for any help!
  #2   Report Post  
Posted to microsoft.public.word.tables
Jezebel Jezebel is offline
external usenet poster
 
Posts: 1,384
Default How do you import an Excel table into Word without losing format?

If you can live with the tables as embedded Excel objects, use Edit
PasteSpecial : Paste as Excel Worksheet object.

Apart from that, can you explain a little more about what's going wrong? --
simple cut and paste from Excel to Word isn't normally so dire.



"C. Van Dam" wrote in message
news
I'm trying to import Excel spreadsheets into Word (as tables), but no
matter
how I do it (I've tried copy/paste, as well as insert file), the
formatting
applied in the Excel spreadsheet is scrambled when the data is pulled into
the Word table.

I've searched the help files, and have followed the directions step by
step
to no avail. If anyone can suggest a way to pull this data into Word
without
requiring massive formatting fixes afterwards, it would be much
appreciated.
The tables end up so screwed up in the Word document that it's easier to
retype the entire table than it is to fix the formatting.

Thanks in advance for any help!



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
I am having difficulty with deleting headers and footers LHD New Users 5 July 24th 06 01:44 AM
Change paper size; Word changes to invalid margins OhioTech New Users 10 July 6th 06 02:00 PM
Word & WordPerfect MrsMac Microsoft Word Help 5 June 10th 06 03:14 AM
Format Fractions in Mail Merge. John McGhie [MVP - Word and Word Macintosh] Mailmerge 4 March 22nd 06 08:55 AM
How do I format numbers in a Word table, data merged from Excel CJDRUMACHOSE Tables 1 November 11th 05 03:28 PM


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

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"