Posted: Thu Dec 13, 2007 4:36 pm Post subject: Tables from Excel to Word
I need to insert a worksheet from Excel into a Word Doc. The worksheet is
large and fits on 3 pages (11 X 17) in Excel, but it doesn't keep the print
settings when I copy/paste into Word.
I tried inserting it as an object, but it still doesn't fit. Is there any
way to make this work? Maybe a feature in Word like Excel that lets you
adjust the % of the sheet?
Posted: Fri Dec 14, 2007 3:10 pm Post subject: Re: Tables from Excel to Word
You would have to insert it in sections.Objects cannot span Word pages. Use
Copy then edit Paste special as Excel Object or Bitmap with the Link button
checked.
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
I need to insert a worksheet from Excel into a Word Doc. The
worksheet is large and fits on 3 pages (11 X 17) in Excel, but it
doesn't keep the print settings when I copy/paste into Word.
I tried inserting it as an object, but it still doesn't fit. Is
there any way to make this work? Maybe a feature in Word like Excel
that lets you adjust the % of the sheet?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
