Excel imports into Word

[Lee]

I produce several large reports each year, and to this
point, its all done in Word. I imbed Excel charts and
spreadsheets into this Word document, which works fine
except when I have some Excel spreadsheets that need to be
rotated 90 degrees into a landscape orientation. I cannot
see how to rotate those spreadsheets, and it requires me
to manually produce that page and insert it into the print
job.

The questions I have are: is there any way to put an Excel
spreadsheet into a word document and rotate it to fit?
Also, on two occasions, on a large, one page Excel
spreadsheet, that spreadsheet cannot be imported into the
Word document without losing lines, and I cannot resize it
to fit.

Am I exceeding the ability of Word and is there other
software that putting this all into would work better?
I'd sure like to be able to have this all as one single
file, put it on a CD and take it to our print shop, with
the simple request of "print 500 copies of this" instead
of having to have detailed explanations of what to print
separately and hand insert.

Thanks.

 

[garfield-n-odie]

Hi, Lee.

If you are pasting the Excel spreadsheets into Word as Excel objects,
then you cannot rotate them. Instead, you can create a landscape page
in your otherwise-portrait Word document (see item 1 in
http://word.mvps.org/faqs/formatting/LandscapeSection.htm), then insert
your Excel object into the landscape page.

If you are pasting as pictures or enhanced metafiles, then it is
possible to rotate them by formatting them as NOT inline-with-text
(right-click on the picture, left-click on Format Picture | Layout |
select a wrapping option other than inline-with-text), then using one of
the rotate buttons or the rotate command from the Drawing toolbar.

There is a limit to how many rows/columns you can paste from Excel into
Word. This limit is not an exact number of rows or columns. Instead,
the limit is the number of rows or columns can fit with a maximum
reduction of 69% of original size. If you select an Excel range that
has to be shrunk more than 69% to fit within the margins of the Word
page, then the pasted image will be shrunk to 69%, and any columns/rows
that don't fit will be truncated. If you have a large Excel range that
you need to paste into Word, it may be necessary to copy and paste it in
two or more parts.