Excel to Word document

[EduPAz]

Hi,

I have a Excel table that has columns with a lot of text and columns with numbers. It's like a form.

I would like to put it in in a Word document without losing the format. I already tried everything that is in Paste Special but I can't get it right.

Any ideas about how to solve this?

Thanks!

Edu

 

[philaugust2004]

1.highlight the table in Excel
2 Click on place in Word where yiu want the table
3 under paste options choose link and keep source formatting

 

[Macropod]

I have a Excel table that has columns with a lot of text and columns with numbers. It's like a form.

I would like to put it in in a Word document without losing the format. I already tried everything that is in Paste Special but I can't get it right.

One of the Paste Special options in Word is an Excel worksheet (accessed via Paste>Paste Special>Microsoft Excel Worksheet Object). That paste option cannot do anything but preserve the format, because you're pasting the actual worksheet into Word.

 

[Macropod]

Cross-posted at: Excel Form to Word document
Please read Mr Excel's policy on Cross-Posting in rule #13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html