Instructions apply to Word for Microsoft 365, Word 2019, Word 2016, Word 2013, Word 2010, Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, and Excel 2010.
How to Link Excel to Word
To insert any part of an Excel worksheet in a Word document:
What Happens When You Link Excel to Word
Linking an Excel file to a Word document ensures that the Word document is updated every time the data in the Excel file changes. It works as a one-way link feed that brings the updated Excel data into the linked Word document. Linking an Excel worksheet also keeps your Word file small because the data doesn’t save to the Word document. Linking an Excel worksheet to a Word document has a few limitations:
If the Excel file moves, the link to the Word document needs to be re-established.If you plan to transport the Word file or use it on another computer, you must transport the Excel file along with it.You must do data editing in the Excel worksheet. It isn’t a problem unless you require different spreadsheet formats in the Word document.
How to Embed an Excel Spreadsheet in Word
The process of embedding an Excel worksheet in a Word document is essentially the same as linking to an Excel worksheet. It does require a few extra clicks, but it brings all data from the worksheet into your document, not only the selected range. There are two ways to embed an Excel worksheet in Word. The first is to embed the worksheet as an object. The second is to insert a table.
Embed an Excel Worksheet as an Object
To embed an Excel worksheet as an object:
How to Embed an Excel Spreadsheet Table
An alternative is to insert the Excel worksheet as a table. This method inserts the worksheet the same way as if you embedded it as an object. The difference is that it opens a blank Excel worksheet for you to fill out. Choose this method if you haven’t created the Excel file yet. To insert an Excel worksheet as a table in Word: When you insert and fill out a new Excel worksheet, you have an Excel file that you can update at any time. The data in the Word table automatically updates to match the data in the Excel file.
