Linking a cel from Excel to a Cell in a Word table
I am trying to link a cell in an Excel table to a cell in a Word table by
copying the cell in Excel then doing a paste in Word and selecting "Match Destination Table Style and Link to Excel" option so it will update as Excel is updated. In Word it is adding a line above and a line below the linked data. Is there anything I can do so this doesn't happen? Thanks in advance. |
Linking a cel from Excel to a Cell in a Word table
Try (in Word)
Edit-Paste Special-Unformatted Text "Terri" wrote: I am trying to link a cell in an Excel table to a cell in a Word table by copying the cell in Excel then doing a paste in Word and selecting "Match Destination Table Style and Link to Excel" option so it will update as Excel is updated. In Word it is adding a line above and a line below the linked data. Is there anything I can do so this doesn't happen? Thanks in advance. |
Linking Excel to Word
Ok it solved that problem but it lost the Word formatting. Is there
something that I can do to keep the Word formatting? |
Linking Excel to Word
Paste as 'Formatted Text' and choose 'Destination...' from the drop down you
get after clicking on the down arrow on 'Paste Options' ... "Terri" wrote: Ok it solved that problem but it lost the Word formatting. Is there something that I can do to keep the Word formatting? |
All times are GMT +1. The time now is 11:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com