Excel spreadsheet is three pages long, 16 x 91 cells, header is three lines.

Word document will be 6x9, with a page number footer.

Since the spreadsheet is so wide, traditionally these spreadsheets have been
printed, and scanned into camera ready material, and the printer inserts this
hardcopy into printer layouts.

I was hoping to copy spreadsheet into Word document, and get the same output
as printing spreadsheet does, three page long (landscape), with header.

Creating a new Word section, with page 9x6 fails. Header is lost, and page
number footer in Word rotates to right side of page.

Creating a text box, and pasting into text box fails because data overflows
to right, and rotate is not available with text box.

Creating text box, and rotating text left 90 fails because paste only allows
unformatted text, spreadsheet headers are lost.

Creating text boxes with link-text fails, because paste of data removes
excel headers, and formats as text, removing the right justification of each
column.

Special Paste (any picture format) fails, because picture reduces the three
page spreadsheet to very small font (maybe 4).

Outputting spreadsheet into three pages on pdf, and pasting each page
seperately creates a fuzzy look, even at 600 dpi.

Any other possibilities?

Thanks,
Bob

"Jean-Guy Marcil" wrote:

Bob was telling us:
Bob nous racontait que :

Okay - Paste Special, using picture format = That works, but very
small type, and header is lost. Paste places whole spreadsheet,

I do not think you can copy/paste a spreadsheet AND include the Excel header
at the same time.
I have never seen it done. You should probably ask in an Excel group (unless
someone here knows how to do this) about this (and, if they tell you it is
possible, please, report back here!)

which is really 3 pages long onto one page, very small type (maybe

How can you put a spreadsheet worth 3 pages on a 9x6 page?
If it is too big, all you can do is reduce the pasted object so that it
fits. A pasted object cannot overflow on to another page. If you must do
that, divide your spreadsheet in three areas, and do 3 paste actions.

4). Rotating works, but font size does not change, and last 2 pages
off page.

Please, it would help if you wrote complete sentences...
Sometimes, if we guess the missing words, we can get it wrong., and
consequently give inappropriate advice, thereby wasting everybody's time. Do
not forget that everybody involved here is a volunteer...

--
Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
ISTOO
Word MVP site: http://www.word.mvps.org