Hi Jim,
[Quoted Text] > I want to copy a worksheet or range of cells from an Excel worksheet to a
> page in a word document. The problem is that when I do so the worksheet
> extends to 3 or 5 pages. How can I past the worksheet or range of cells and
> have it reduce to fit the word page document? I would like to retain updates
> from the source material. Inable to print the Excel page in excel it is
> reduced by 60% so in able for it to print on a Word page it will need to be
> reduced. Using Office )#
>
Which version of Office :-)?
This isn't going to be something that's going to happen automatically if you
want the result to be a Word table.
You can try going over Paste Special and choosing an "Excel Worksheet object".
That will definitely limit the result to a single page. The question is, whether
it will cut things off, or reduce them (the newer the version of Word, the more
likely it will reduce).
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)
|