Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Adding a page break to a Word doc with an Excel spreadsheet linked
I've linked an Excel Spreadsheet into a Word doc but the Excel doc, a page
long, remains on the second page and will not page break in the Word document. I've added page breaks to the Excel doc but with no luck. Any suggestions? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Adding a page break to a Word doc with an Excel spreadsheet linked
Excel Worksheets are effectively single graphical objects as far as Word is
concerned when it comes to page / document layout and they cannot break across pages. If they are too big to fit on the current page they will be moved to the start of the next page. The structural content of them is beyond Word's reach. -- Enjoy, Tony "G" wrote in message ... I've linked an Excel Spreadsheet into a Word doc but the Excel doc, a page long, remains on the second page and will not page break in the Word document. I've added page breaks to the Excel doc but with no luck. Any suggestions? |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Adding a page break to a Word doc with an Excel spreadsheet linked
An Excel Spreadsheet embedded inside of Word is an Object. Word will
treat it the same as though it was a graphic and keep it all on one page, and hide the portions which don't fit. However, if you open it, select all the information stored inside it, copy, click into your Word document and Paste, Word will convert it to a Word Table. Another alternative will be to have more than one embedded object each showing a different "page" worth of information. -- Dawn Crosier Microsoft MVP "Education Lasts a Lifetime" This message is posted to a newsgroup. Please post replies and questions to the newsgroup so that others can learn as well. "G" wrote in message ... I've linked an Excel Spreadsheet into a Word doc but the Excel doc, a page long, remains on the second page and will not page break in the Word document. I've added page breaks to the Excel doc but with no luck. Any suggestions? |
#4
|
|||
|
|||
Quote:
I have done what is suggested (split object to copy in multiple parts). It works well. My target Word document has 2 sections (different headers/ footers etc...) and I need to copy some parts in Section 1, some in section 2. How can I position the cursor in the second section of the word document to paste the second part of the text/ object ? Thanks Eric |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WP merge file to Word | Tables | |||
page number positioning and format | Page Layout | |||
Hebrew Suggestions | Microsoft Word Help | |||
Excel worksheet in Word linked text boxes | Page Layout | |||
Excel Link: Adding rows in Excel does not add cells in Word | Tables |