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?

date: Tue, 5 Aug 2008 06:15:01 -0700   author:   Tricia Butler Tricia

RE: 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?

date: Tue, 5 Aug 2008 18:23:02 -0700   author:   USEN

Re: 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 Butler@discussions.microsoft.com> wrote in message 
news:7304BF00-1C8A-4E35-AEE4-731C60EBBB8E@microsoft.com...
>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?

date: Wed, 6 Aug 2008 10:35:38 +0200   author:   Stefan Blom

Re: 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 Butler@discussions.microsoft.com> wrote in message 
> news:7304BF00-1C8A-4E35-AEE4-731C60EBBB8E@microsoft.com...
> >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? 
> 
> 
>

date: Wed, 6 Aug 2008 05:03:01 -0700   author:   Tricia Butler

Re: 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 
news:46E56F05-54D6-4476-976F-572640E69BBE@microsoft.com...
> 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 Butler@discussions.microsoft.com> wrote in 
>> message
>> news:7304BF00-1C8A-4E35-AEE4-731C60EBBB8E@microsoft.com...
>> >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?
>>
>>
>>

date: Wed, 6 Aug 2008 14:39:05 +0200   author:   Stefan Blom

Re: 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 Butler@discussions.microsoft.com> wrote in message 
> > news:7304BF00-1C8A-4E35-AEE4-731C60EBBB8E@microsoft.com...
> > >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? 
> > 
> > 
> >

date: Wed, 6 Aug 2008 08:58:00 -0700   author:   USEN

Re: 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 Butler@discussions.microsoft.com> wrote in message 
> > > news:7304BF00-1C8A-4E35-AEE4-731C60EBBB8E@microsoft.com...
> > > >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? 
> > > 
> > > 
> > >

date: Wed, 6 Aug 2008 20:09:00 -0700   author:   Tricia Butler

Re: Paste large Excel spreadsheet into Word   

You are welcome. :-)

-- 
Stefan Blom
Microsoft Word MVP


"Tricia Butler"  wrote in message 
news:3A8B84B4-6EC1-4CCC-8DD5-C01A0ABEE0F2@microsoft.com...
>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 Butler@discussions.microsoft.com> wrote in 
>> > > message
>> > > news:7304BF00-1C8A-4E35-AEE4-731C60EBBB8E@microsoft.com...
>> > > >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?
>> > >
>> > >
>> > >

date: Thu, 7 Aug 2008 09:57:18 +0200   author:   Stefan Blom