How to Embed Excel Tables into Word

To start of with you may be asking yourself; why bother adding Excel tables to Word when you can just as easily make your own tables in Word? But if the tables are already created in Excel, it’s easy and simple, just copy and paste the excel table into your Word document.

One problem with doing this is once you have pasted the Excel table into Word, any changes you make in Excel won’t change the Word version. You have to embed the table into Word for you to be able to freely changed both versions.

To do this simply highlight the Excel data you want, copy it, back to the Word document and go to Paste > Paste Special > Paste Link as: Microsoft Excel Worksheet Object. You will now have an embedded table in your Word document which will change as you make any changes in the original Excel document.

Tags

, , , , ,
Andy Trainer


Connect with Andy on Google.

View all posts by Andy Trainer

Leave a Comment