character spacing is messed up in Excel objects inserted in Word

[michalaw]

My office often creates tables in Excel, and then needs to insert them into
Word documents. Often we notice that, after we insert the Excel object into
the Word document, the characters in some cells get squished together, and
are too stretched out, even though we haven't done anything that would cause
the character spacing to change. Can anyone tell me why this occurs and how
to fix it?

 

[Marty D]

Try selecting the table that was put into Word, right click, go to Table
Properties, then on the dialog box select Options and reduce the margins on
the left and right to 0.01. Then make sure that the paragraph spacing before
and after is either Auto or 0 pt. Then uncheck the box for "Don't add space
for paragraphs of the same style." You should be able to find paragraph
spacing by selecting the whole table, right clicking, and selecting
Paragraph.
This should clean it up and make it easier to read.

 

[michalaw]

Thanks for the reply. I can't make your suggestions work, though - the table
is inserted as an Excel object, and I can't find a way to get to Table
Properties or paragraph spacing. I had always understood that those options
are only available for Word tables.

 

[Suzanne S. Barnhill]

Instead of inserting as an OLE object, just paste the content into Word; it
will come in as a table. It will not be linked to Excel, however; if you
need the data to update, then you have no alternative to using an OLE
object.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org