This article explains how to insert an Excel spreadsheet into a Word document. Instructions apply to Microsoft Word and Excel 2019, 2016, and 2013 as well as Microsoft 365. Here's how to embed an Excel worksheet using the simple paste option:
Here's how to embed using the Paste Special option:
The steps to link a worksheet to a Word document are similar to the steps to embed the data.
Keep these pointers in mind after you've linked the data:
When you link an Excel worksheet to a Word document, every time the worksheet is updated, the changes are reflected in the document. All editing takes place in the worksheet and not in the document. Use this option if you plan to make changes to the worksheet, especially if these changes involve complex calculations. An embedded worksheet is a flat file. Once it's part of a Word document, it behaves like a piece of that document and can be edited in Word. There is no connection between the original worksheet and the Word document it's now a part of. Use this option if you plan to make minimal changes to the table data or if the data involves simple calculations. When you embed an Excel worksheet into a Word document, you can either copy and paste from Excel to Word or embed using the Paste Special feature. The copy-and-paste method is faster but some formatting may change and some table functionality may be lost. The Paste Special feature provides more options for how the data will appear.
Thanks for letting us know!
Tell us why! |