Pasting an Excel sheet in Word

[Guest]

Hello -

I am trying to paste a 2 page Excel sheet into Word. How do I get the whole
sheet to display in word? Is there a way to also have it repeat the top row
over a page break?

This will be distilled to a PDF, so I need to see all the rows as I can't
scroll through them once my report is complete.

Thanks!

 

[JoAnn Paules [MVP]]

Since you're going to create a .pdf file anyway, why not leave it as two
separate documents and after your .pdf created with the Word part, insert
the Excel .pdfs.

 

[Cindy M -WordMVP-]

Hi =?Utf-8?B?RXJpYw==?=,

I am trying to paste a 2 page Excel sheet into Word. How do I get the whole
sheet to display in word? Is there a way to also have it repeat the top row
over a page break?

This will be distilled to a PDF, so I need to see all the rows as I can't
scroll through them once my report is complete.

Word cannot "break" a graphical object over multiple pages. That leaves you
with two options:

1. Use the default paste option to paste the Excel table as a Word table. You
can set the Word table to repeat header rows (select the row, then use the
command in the Table menu)

2. Paste two individual objects from Excel, one on the first and the other on
the second page.

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

 

[Guest]

Thanks -- I am going to just use the table option due to the fact the report
will be in Word internally and some at work are not as tech saavy .
Hopefully a MS will think of this in the next upgrade?!?!?!

 

[CyberTaz]

I can't speak for the knock-offs, but if you're using Acrobat 7 to create
the PDFs there's no need to go through Word in the first place. You might
want to consider creating 2 separate PDFs - one from the Word doc, one from
Excel - then combine the two for the final report.

 

[JoAnn Paules [MVP]]

That's what I suggested.

--

JoAnn Paules
MVP Microsoft [Publisher]