Hi,

I created a table in Excel. Am trying to paste this table into word. So i use: Paste--link and keep source formatting.



The problem is once i select "link and keep source formatting" i get extra space between rows.

HOw do i avoid the extra space between rows?

Thanks.

What version of Office are you using?
I just copied a tabel from Excel, and Pasted it into Word, and it was a perfect copy (with no spaces).
In fact I didn't have the option to Paste ---link and keep formatting as you suggested.
I didn't even have the "Paste Special" option available; simply Paste.

Using Office 2007.

Gary

Hi Minny,

You'll probably get the result you're after by using Paste Special > Link to File and choosing the 'Excel Worksheet Object' or 'Picture (Enhanced Metafile)' paste format.

Gary: The OP's profile indicates Office 2010. If you want the data to be linked, you have to use 'link and keep formatting' (which may only be available in Office 2010) or the 'Paste Special' option. The 'Paste Special' option is available in Office 2007.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]