how to copy word table to excel with same format

The above steps would insert the copied table in Word, where it’s still linked to the original table in Excel. Suppose you have a table as shown below and you want to copy it from Excel to MS Word and keep this linked. By having the linked table, you only need to make changes in Excel data and these would automatically get reflected in the table you copied to Word. This is quite useful when there is a possibility that you may have to update the data in Excel and it would also need to be updated in Word. This way, if you make any changes in the Excel table that you copied, you will see that these are reflected in real-time in the table in Word as well.

In the above method, we copied the data from Excel and inserted it as a static table into Word.Īnother option that you can use is to copy and paste the table into a Word document and keep the two tables linked. It shows up when you click on the Paste Options icon after you have pasted the table in Word.Įmbed Excel Table into Word (as a Linked Object) If you don’t want to get copy the formatting from Excel and would rather want to use the formatting of the Word document, you can use the option Use Destination Style option.If you make any changes to any data, you will have to manually adjust the formula values as well In my example, I have the formulas in the Total row, but when copied to Word, these are static values.

If there are any formulas in the table in Excel, they won’t be copied.Once you have the table in Word, you can format and work with it just like any other table that you insert in Word.Ī couple of things to note when using this method: The above steps would copy the data from Excel and paste it as a static table in the Word document.

How to copy word table to excel with same format