character spacing is messed up in Excel objects inserted i..

michalaw · External Since: Oct 01, 2009 Posts: 2

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 · External Since: Oct 13, 2009 Posts: 1

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 · External Since: Oct 01, 2009 Posts: 2

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 · External Since: Sep 26, 2003 Posts: 24065

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" <michalaw.TakeThisOut@discussions.microsoft.com> wrote in message
news:1387EC50-1764-4132-9BA4-F927EC997477@microsoft.com...
> 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?
>