How do I insert and format an Excel spreadsheet into a document?

[aquaticdoc]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I need to insert a spreadsheet into a document, but turn it sideways and leave it shrunk so that it fits on a single page. I have tried copy / paste and copy / paste special and paste hyperlink as well as insert / file, but cannot make this work at all. The inserted spreadsheet covers several pages and is broken in bizarre ways.

 

[John McGhie]

You can't rotate a spreadsheet that spans more than a page.

The only way to rotate any kind of spreadsheet is to past it as a PDF or a
"picture", after which, it is no longer a spreadsheet.

Excel can span spreadsheets over multiple sheets. Word can not.

The normal way to do this is to print the text from Word and the numbers
from Excel, then collate the pages by hand. Obviously, that works really
badly if you want the file electronically.

You can print the text from Word and the spreadsheet from Excel, both to
PDF, then stitch the PDFs together with Adobe Acrobat or similar. That gets
you an electronic file, but it is read-only to everyone.

No good solutions...

Cheers

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

I need to insert a spreadsheet into a document, but turn it sideways and leave
it shrunk so that it fits on a single page. I have tried copy / paste and copy
/ paste special and paste hyperlink as well as insert / file, but cannot make
this work at all. The inserted spreadsheet covers several pages and is broken
in bizarre ways.

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Sydney, Australia. S33°53'34.20 E151°14'54.50
+61 4 1209 1410, mailto:[email protected]