How do I insert an Excel table in Word, then resize it to fit?

L

Laurie

I copy the table from Excel into Word, but then it's way too big and I don't
know how to shrink it to fit my Word doc.
 
A

Angela

After you have the table in Word, right click on the little pop up square at
the top left corner of the table. Scroll down to Auto Fit, choose Auto Fit
to Window. It doesn't always work on excesively wide tables, but it helps.
 
L

Laurie

Thanks Angela.
I have also learned this: if when I paste the table into the Word doc, I
choose Paste Special and then choose Excel Object, then the table comes with
corners that I can drag and shrink the table to fit.
Thanks again.
 
C

Cindy M -WordMVP-

Hi =?Utf-8?B?TGF1cmll?=,
I have also learned this: if when I paste the table into the Word doc, I
choose Paste Special and then choose Excel Object, then the table comes with
corners that I can drag and shrink the table to fit.
You just need to be aware that such a table cannot break over multiple pages:
it's restricted to a single page.

Cindy Meister
 
P

PeterP

Another option that we use where I work, is to "Paste Special" and select
"Enhanced Metafile." The Excel table seems to behave better than just
pasting as an Excel object, and the corner boxes are there for resizing,
although that is rarely needed.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top