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
|
|||
|
|||
Excel Table into a Word Doc
I know this is more of a Word question but . . . I have a
small table in Excel that I want to input into Word. Now I know that I can cut and paste, but that gets to be a pain in the butt when I need to update the excel table and then recopy and repaste it into Word. I'm wondering if there is anyway to link the two files together so that any changes made in the excel file will be automatically reflected in the Word Doc? I would just edit the Word Doc, but the table has a formula in it. I don't know if it's possible to enter a formula in Word or if it will just take it as text. Any light on the idea would be greatly appreciated. Kevin |
#2
|
|||
|
|||
Excel Table into a Word Doc
Kevin, copy the Excel table, then in Word, Edit Paste Special Excel
Worksheet Object Paste Link OK. Update in Excel, it updates in Word. From Word, double-click the cells, it takes you to Excel, where you can edit. Pretty cool, huh? -- DDM "DDM's Microsoft Office Tips and Tricks" www.ddmcomputing.com "Kevin" wrote in message ... I know this is more of a Word question but . . . I have a small table in Excel that I want to input into Word. Now I know that I can cut and paste, but that gets to be a pain in the butt when I need to update the excel table and then recopy and repaste it into Word. I'm wondering if there is anyway to link the two files together so that any changes made in the excel file will be automatically reflected in the Word Doc? I would just edit the Word Doc, but the table has a formula in it. I don't know if it's possible to enter a formula in Word or if it will just take it as text. Any light on the idea would be greatly appreciated. Kevin |
#3
|
|||
|
|||
Excel Table into a Word Doc
Thanks for the tip. It works beautifully.
-----Original Message----- Kevin, copy the Excel table, then in Word, Edit Paste Special Excel Worksheet Object Paste Link OK. Update in Excel, it updates in Word. From Word, double- click the cells, it takes you to Excel, where you can edit. Pretty cool, huh? -- DDM "DDM's Microsoft Office Tips and Tricks" www.ddmcomputing.com "Kevin" wrote in message ... I know this is more of a Word question but . . . I have a small table in Excel that I want to input into Word. Now I know that I can cut and paste, but that gets to be a pain in the butt when I need to update the excel table and then recopy and repaste it into Word. I'm wondering if there is anyway to link the two files together so that any changes made in the excel file will be automatically reflected in the Word Doc? I would just edit the Word Doc, but the table has a formula in it. I don't know if it's possible to enter a formula in Word or if it will just take it as text. Any light on the idea would be greatly appreciated. Kevin . |
Thread Tools | |
Display Modes | |
|
|