Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Pasting an Excel sheet in Word
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! |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Pasting an Excel sheet in Word
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. -- JoAnn Paules MVP Microsoft [Publisher] "Eric" wrote in message ... 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! |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Pasting an Excel sheet in Word
Hi ?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 :-) |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Pasting an Excel sheet in Word
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?!?!?! "Cindy M -WordMVP-" wrote: Hi ?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 :-) |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Pasting an Excel sheet in Word
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. -- Regards |:) Bob Jones [MVP] Office:Mac "Eric" wrote in message ... 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?!?!?! "Cindy M -WordMVP-" wrote: Hi ?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 :-) |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Pasting an Excel sheet in Word
That's what I suggested.
-- JoAnn Paules MVP Microsoft [Publisher] "CyberTaz" typegeneraltaz1ATcomcastdotnet wrote in message ... 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. -- Regards |:) Bob Jones [MVP] Office:Mac "Eric" wrote in message ... 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?!?!?! "Cindy M -WordMVP-" wrote: Hi ?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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why dont MS just f**king re-write Word from scratch? Its dogsh*t | Microsoft Word Help | |||
How to put graphics on envelopes? | Microsoft Word Help | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Word should allow to 'divide' page by 3 or 4, not just 2 | Page Layout | |||
Excel worksheet in Word linked text boxes | Page Layout |