[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" wrote:

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?

[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.

"Marty D" wrote:

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" wrote:

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?

[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

"michalaw" wrote in message
...
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.

"Marty D" wrote:

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" wrote:

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?