How do you import an Excel table into Word without losing format?

C

C. Van Dam

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!
 
J

Jezebel

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.
 

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

Paste to excel from word - auto format problem 1
Cumulative formula for word table 0
Linking data in MS Word into Excel 5
HOW TO IMPORT DATA INTO PRE-FORMATTED TABLES IN WORD 2010? 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Pasting a cell into bookmarked table from excel vba 1
Excel to Word to PDF workflow 1
Copy Word table into excel 1

Top