If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Paste large Excel spreadsheet into Word
I have a spreadsheet that one and a half pages long. When I insert it into
Word, it cuts off after one page. Is it possible to have a spreadsheet continue to multiple pages in Word? |
#2
|
|||
|
|||
I dont think you can do that directly, unless you shrink it (making all fonts smaller in the process). Also, you can cut yr spreadsheet into several sections.
__________________
Henk van Ekelenburg co-author of the eBook "Mastering Microsoft Word for Scientific Reports" (and other long documents) www.masteringword.eu/?Off |
#3
|
|||
|
|||
Paste large Excel spreadsheet into Word
Hi Tricia,
It should automatically extend to as many pages as necessary to post your entire spreadsheet. Are you doing a simple copy/paste? I just tried copying a large spreadsheet of my own to test it and pasted it into Word. It automatically extended to 5 pages in Word. I'm using 2007. "Tricia Butler" wrote: I have a spreadsheet that one and a half pages long. When I insert it into Word, it cuts off after one page. Is it possible to have a spreadsheet continue to multiple pages in Word? |
#4
|
|||
|
|||
Paste large Excel spreadsheet into Word
Note that if you pasted as an Excel object, the behavior you are describing
is to be expected, since Word does not allow objects to extend across pages. Instead, make sure to paste in RTF (table) format, if necessary via the Paste Special dialog box (Home tab | Paste | Paste Special). -- Stefan Blom Microsoft Word MVP "Tricia Butler" Tricia wrote in message ... I have a spreadsheet that one and a half pages long. When I insert it into Word, it cuts off after one page. Is it possible to have a spreadsheet continue to multiple pages in Word? |
#5
|
|||
|
|||
Paste large Excel spreadsheet into Word
Thank you so much for the responses. I did paste as an Excel object because
there are formulas, and numbers I would like to have the capability of changing with recalculation in the future. Is it possible to maintain an interactive format and have the spreadsheet still expand to multiple pages? Also, I selected a range to insert but the object is the entire spreadsheet and multiple tabs. I broke each tab into a separate file, which is better. However, I still can scroll down to blank lines and potentially just see blank rows or columns in my Word document. Thanks again "Stefan Blom" wrote: Note that if you pasted as an Excel object, the behavior you are describing is to be expected, since Word does not allow objects to extend across pages. Instead, make sure to paste in RTF (table) format, if necessary via the Paste Special dialog box (Home tab | Paste | Paste Special). -- Stefan Blom Microsoft Word MVP "Tricia Butler" Tricia wrote in message ... I have a spreadsheet that one and a half pages long. When I insert it into Word, it cuts off after one page. Is it possible to have a spreadsheet continue to multiple pages in Word? |
#6
|
|||
|
|||
Paste large Excel spreadsheet into Word
In the Paste Special dialog box, you can click the "Insert link" option to
insert the Excel range as a link but still choose to paste in "Formatted Text (RTF)" format. -- Stefan Blom Microsoft Word MVP "Tricia Butler" wrote in message ... Thank you so much for the responses. I did paste as an Excel object because there are formulas, and numbers I would like to have the capability of changing with recalculation in the future. Is it possible to maintain an interactive format and have the spreadsheet still expand to multiple pages? Also, I selected a range to insert but the object is the entire spreadsheet and multiple tabs. I broke each tab into a separate file, which is better. However, I still can scroll down to blank lines and potentially just see blank rows or columns in my Word document. Thanks again "Stefan Blom" wrote: Note that if you pasted as an Excel object, the behavior you are describing is to be expected, since Word does not allow objects to extend across pages. Instead, make sure to paste in RTF (table) format, if necessary via the Paste Special dialog box (Home tab | Paste | Paste Special). -- Stefan Blom Microsoft Word MVP "Tricia Butler" Tricia wrote in message ... I have a spreadsheet that one and a half pages long. When I insert it into Word, it cuts off after one page. Is it possible to have a spreadsheet continue to multiple pages in Word? |
#7
|
|||
|
|||
Paste large Excel spreadsheet into Word
Hi Tricia,
What version of Excel & Word are you using? If 2007 like mine, you can simply copy the Excel spreadsheet, open Word and paste it. After it has been pasted, click on the little "paste options" icon and choose to either: keep the source formatting and link to Excel or Match Destination table stype and link to Excel. NOTE: Do NOT close the Excel spreadsheet until AFTER you've made chosen one of these options. If you try to copy the spreadsheet and close it before your paste it into Word, the option to "link" it to Excel won't be available to you. Once linked to Excel...any time you make changes to the Excel spreadsheet, it will automatically change in the Word document as well. "Tricia Butler" wrote: Thank you so much for the responses. I did paste as an Excel object because there are formulas, and numbers I would like to have the capability of changing with recalculation in the future. Is it possible to maintain an interactive format and have the spreadsheet still expand to multiple pages? Also, I selected a range to insert but the object is the entire spreadsheet and multiple tabs. I broke each tab into a separate file, which is better. However, I still can scroll down to blank lines and potentially just see blank rows or columns in my Word document. Thanks again "Stefan Blom" wrote: Note that if you pasted as an Excel object, the behavior you are describing is to be expected, since Word does not allow objects to extend across pages. Instead, make sure to paste in RTF (table) format, if necessary via the Paste Special dialog box (Home tab | Paste | Paste Special). -- Stefan Blom Microsoft Word MVP "Tricia Butler" Tricia wrote in message ... I have a spreadsheet that one and a half pages long. When I insert it into Word, it cuts off after one page. Is it possible to have a spreadsheet continue to multiple pages in Word? |
#8
|
|||
|
|||
Paste large Excel spreadsheet into Word
I have opened and saved the spreadsheet in 2007 - has evolved from 1997 to
2003 etc. I followed your steps and see how this works with pasting the link. I believe I am at the crossroads of wanting the best of both worlds - I like pasting as an object so I can simply change the numbers that vary in Word by entering the Excel object, but that format does not seem to span across multiple pages. I like this better than linking to the Excel spreadsheet because others will be using the file in the future, and so the "self-contained" format is nice and I won't have to worry about opening two files and finding the "Update Link" function which I don't use that often. However, I have to be able to see all the info, so at this point, the only workable option seems to be inserting the spreadsheet as a link, and updating the info in Excel. I am thankful to have a workable option, so again thanks to you and Stefan Blom for taking the time to respond and having good suggestions! ~tricia "USEN" wrote: Hi Tricia, What version of Excel & Word are you using? If 2007 like mine, you can simply copy the Excel spreadsheet, open Word and paste it. After it has been pasted, click on the little "paste options" icon and choose to either: keep the source formatting and link to Excel or Match Destination table stype and link to Excel. NOTE: Do NOT close the Excel spreadsheet until AFTER you've made chosen one of these options. If you try to copy the spreadsheet and close it before your paste it into Word, the option to "link" it to Excel won't be available to you. Once linked to Excel...any time you make changes to the Excel spreadsheet, it will automatically change in the Word document as well. "Tricia Butler" wrote: Thank you so much for the responses. I did paste as an Excel object because there are formulas, and numbers I would like to have the capability of changing with recalculation in the future. Is it possible to maintain an interactive format and have the spreadsheet still expand to multiple pages? Also, I selected a range to insert but the object is the entire spreadsheet and multiple tabs. I broke each tab into a separate file, which is better. However, I still can scroll down to blank lines and potentially just see blank rows or columns in my Word document. Thanks again "Stefan Blom" wrote: Note that if you pasted as an Excel object, the behavior you are describing is to be expected, since Word does not allow objects to extend across pages. Instead, make sure to paste in RTF (table) format, if necessary via the Paste Special dialog box (Home tab | Paste | Paste Special). -- Stefan Blom Microsoft Word MVP "Tricia Butler" Tricia wrote in message ... I have a spreadsheet that one and a half pages long. When I insert it into Word, it cuts off after one page. Is it possible to have a spreadsheet continue to multiple pages in Word? |
#9
|
|||
|
|||
Paste large Excel spreadsheet into Word
You are welcome. :-)
-- Stefan Blom Microsoft Word MVP "Tricia Butler" wrote in message ... I have opened and saved the spreadsheet in 2007 - has evolved from 1997 to 2003 etc. I followed your steps and see how this works with pasting the link. I believe I am at the crossroads of wanting the best of both worlds - I like pasting as an object so I can simply change the numbers that vary in Word by entering the Excel object, but that format does not seem to span across multiple pages. I like this better than linking to the Excel spreadsheet because others will be using the file in the future, and so the "self-contained" format is nice and I won't have to worry about opening two files and finding the "Update Link" function which I don't use that often. However, I have to be able to see all the info, so at this point, the only workable option seems to be inserting the spreadsheet as a link, and updating the info in Excel. I am thankful to have a workable option, so again thanks to you and Stefan Blom for taking the time to respond and having good suggestions! ~tricia "USEN" wrote: Hi Tricia, What version of Excel & Word are you using? If 2007 like mine, you can simply copy the Excel spreadsheet, open Word and paste it. After it has been pasted, click on the little "paste options" icon and choose to either: keep the source formatting and link to Excel or Match Destination table stype and link to Excel. NOTE: Do NOT close the Excel spreadsheet until AFTER you've made chosen one of these options. If you try to copy the spreadsheet and close it before your paste it into Word, the option to "link" it to Excel won't be available to you. Once linked to Excel...any time you make changes to the Excel spreadsheet, it will automatically change in the Word document as well. "Tricia Butler" wrote: Thank you so much for the responses. I did paste as an Excel object because there are formulas, and numbers I would like to have the capability of changing with recalculation in the future. Is it possible to maintain an interactive format and have the spreadsheet still expand to multiple pages? Also, I selected a range to insert but the object is the entire spreadsheet and multiple tabs. I broke each tab into a separate file, which is better. However, I still can scroll down to blank lines and potentially just see blank rows or columns in my Word document. Thanks again "Stefan Blom" wrote: Note that if you pasted as an Excel object, the behavior you are describing is to be expected, since Word does not allow objects to extend across pages. Instead, make sure to paste in RTF (table) format, if necessary via the Paste Special dialog box (Home tab | Paste | Paste Special). -- Stefan Blom Microsoft Word MVP "Tricia Butler" Tricia wrote in message ... I have a spreadsheet that one and a half pages long. When I insert it into Word, it cuts off after one page. Is it possible to have a spreadsheet continue to multiple pages in Word? |
#10
|
|||
|
|||
Paste large Excel spreadsheet into Word
I've gotten to to same place with linking large spreadsheets into Word 2007,
using RTF. Works fine, intially. But after I close and reopen the Word document, the link doesn't remain valid. I get "Error! Not a valid link" if I use the Update Now button on the Links pop-up. "Stefan Blom" wrote: You are welcome. :-) -- Stefan Blom Microsoft Word MVP "Tricia Butler" wrote in message ... I have opened and saved the spreadsheet in 2007 - has evolved from 1997 to 2003 etc. I followed your steps and see how this works with pasting the link. I believe I am at the crossroads of wanting the best of both worlds - I like pasting as an object so I can simply change the numbers that vary in Word by entering the Excel object, but that format does not seem to span across multiple pages. I like this better than linking to the Excel spreadsheet because others will be using the file in the future, and so the "self-contained" format is nice and I won't have to worry about opening two files and finding the "Update Link" function which I don't use that often. However, I have to be able to see all the info, so at this point, the only workable option seems to be inserting the spreadsheet as a link, and updating the info in Excel. I am thankful to have a workable option, so again thanks to you and Stefan Blom for taking the time to respond and having good suggestions! ~tricia "USEN" wrote: Hi Tricia, What version of Excel & Word are you using? If 2007 like mine, you can simply copy the Excel spreadsheet, open Word and paste it. After it has been pasted, click on the little "paste options" icon and choose to either: keep the source formatting and link to Excel or Match Destination table stype and link to Excel. NOTE: Do NOT close the Excel spreadsheet until AFTER you've made chosen one of these options. If you try to copy the spreadsheet and close it before your paste it into Word, the option to "link" it to Excel won't be available to you. Once linked to Excel...any time you make changes to the Excel spreadsheet, it will automatically change in the Word document as well. "Tricia Butler" wrote: Thank you so much for the responses. I did paste as an Excel object because there are formulas, and numbers I would like to have the capability of changing with recalculation in the future. Is it possible to maintain an interactive format and have the spreadsheet still expand to multiple pages? Also, I selected a range to insert but the object is the entire spreadsheet and multiple tabs. I broke each tab into a separate file, which is better. However, I still can scroll down to blank lines and potentially just see blank rows or columns in my Word document. Thanks again "Stefan Blom" wrote: Note that if you pasted as an Excel object, the behavior you are describing is to be expected, since Word does not allow objects to extend across pages. Instead, make sure to paste in RTF (table) format, if necessary via the Paste Special dialog box (Home tab | Paste | Paste Special). -- Stefan Blom Microsoft Word MVP "Tricia Butler" Tricia wrote in message ... I have a spreadsheet that one and a half pages long. When I insert it into Word, it cuts off after one page. Is it possible to have a spreadsheet continue to multiple pages in Word? |
|
Thread Tools | |
Display Modes | |
|
|