Instructions apply to Microsoft Word and Excel 2019, 2016, and 2013 as well as Microsoft 365.
PressCtrl+C(on a Mac, pressCommand+C).
Or, right-smack the selected data and selectCopy.
kick off the Word document and place the cursor where you want the worksheet data to appear.
PressCtrl+V(on a Mac, pressCommand+V).
Or, go to theHometab and, in theClipboardgroup, selectPaste.
Don’t choose thePastedrop-down arrow.
The data appears in the Word document.
In thePaste Specialdialog box, selectPaste.
SelectMicrosoft Excel Worksheet Object.
The Excel data appears in the Word document.
Go to theHometab, select thePastedrop-down arrow, then choosePaste Special.
In thePaste Specialdialog box, selectPaste link.
ChooseMicrosoft Excel Worksheet Object.
Keep these pointers in mind after you’ve linked the data:
Should You Link or Embed?
All editing takes place in the worksheet and not in the document.
An embedded worksheet is a flat file.
There is no connection between the original worksheet and the Word document it’s now a part of.
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.
