Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
insert excel spreadsheet
Hello
I have a Word document into which I want to insert an Excel spreadsheet. I want to be able to update the spreadsheet and have the word document update at the same time. I also want to be able to print the word document with the excel data shown as a table. I think this is possible, but I cannot find the route. I have excel 2007 and word 2007 Thanks KK |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
insert excel spreadsheet
Copy your Excel data
Paste into Word using the Paste Special/Paste Link option On Mar 22, 9:46*am, "KRK" wrote: Hello I have a Word document into which I want to insert an Excel spreadsheet. I want to be able to update the spreadsheet and have the word document update at the same time. I also want to be able to print the word document with the excel data shown as a table. I think this is possible, but I cannot find the route. I have excel 2007 and word 2007 Thanks KK |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
insert excel spreadsheet
Hi KRK,
This is possible so all you have to do is open both the excel and word documents. Select the range of cells you want to show in the word document, then copy the selected cells and then in the word document and place your cursor where you want to put the data. In the menu bar select Edit- Paste Special. After you do that a dialog box shows up and you just click the paste button and select Excel worksheet object from the list, and then hit OK. To update the spreadsheet and word document at the same time all you have to do is copy and paste the data from excel to word. After you paste there should be a paste options button in the lower right hand corner of your data, click the down arrow and select Match Destination Table Style and Link to Excel link and that's it. Hope this Helps! Brandon G. "KRK" wrote: Hello I have a Word document into which I want to insert an Excel spreadsheet. I want to be able to update the spreadsheet and have the word document update at the same time. I also want to be able to print the word document with the excel data shown as a table. I think this is possible, but I cannot find the route. I have excel 2007 and word 2007 Thanks KK . |
#4
Posted to microsoft.public.word.newusers
|
|||
|
|||
insert excel spreadsheet
And note that you MUST insert the link IN LINE or the link will not update.
-- Terry Farrell - MSWord MVP "KRK" wrote in message ... Hello I have a Word document into which I want to insert an Excel spreadsheet. I want to be able to update the spreadsheet and have the word document update at the same time. I also want to be able to print the word document with the excel data shown as a table. I think this is possible, but I cannot find the route. I have excel 2007 and word 2007 Thanks KK |
#5
Posted to microsoft.public.word.newusers
|
|||
|
|||
insert excel spreadsheet _ Thanks all
Thanks for the help,
KK "KRK" wrote in message ... Hello I have a Word document into which I want to insert an Excel spreadsheet. I want to be able to update the spreadsheet and have the word document update at the same time. I also want to be able to print the word document with the excel data shown as a table. I think this is possible, but I cannot find the route. I have excel 2007 and word 2007 Thanks KK |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert 'Landscape' Excel Spreadsheet into 'Portrait' Word Document | Page Layout | |||
Excel spreadsheet in Word | Microsoft Word Help | |||
excel spreadsheet to word doc | Microsoft Word Help | |||
How do I insert an excel spreadsheet in Word? | Microsoft Word Help | |||
embedded Excel spreadsheet | Microsoft Word Help |