View Single Post
  #6   Report Post  
Posted to microsoft.public.word.tables
PeterP
 
Posts: n/a
Default How do I insert an Excel table in Word, then resize it to fit?

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.

"Laurie" wrote:

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.

"Angela" wrote:

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.

"Laurie" wrote:

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.