copy word table to excel keep formatting

Whenever you update the Excel file and reopen Word, Word will ask you if you want to update the doc with the new data from the linked files. Step 3: That’s it, now your table will be linked to the original Excel file. You can hover over them and you’ll find the same two options as mentioned above. In newer versions of Word, you’ll see several icons. In order to link, you have to click on the Paste Options button at the bottom right and choose either Match Destination Table Style and Link to Excel or Keep Source Formatting and Link to Excel. Step 2: Now go to your Word document and press Ctrl + V to paste the contents into the Word file. Step 1: Select the area in your Excel spreadsheet that you want to include in Word and then press Ctrl + C to copy the contents. In the second method, inserting an object, the entire spreadsheet will be placed into the Word file. Note that when using this method, you have the option to include only a part of the Excel spreadsheet in the Word document. Let’s start off with the first method, which is basically just copying and pasting from Excel into Word. In this article, I will show you how to do it using all three methods and explain what you need to do in order to create the link.

In addition to inserting an existing Excel spreadsheet, you can also insert a new Excel object into Word, which basically runs Excel inside of Word itself.

Copy word table to excel keep formatting