1. Select the Excel data.
2. Right click, and then click Copy (or press CTRL + c).
3. Open a Word document.
4. In word, on the Home tab, in the Clipboard group, click Paste.
5. Click Paste Special.
The Paste Special dialog box appears.
6. Click Paste, Microsoft Excel Worksheet Object.
7. Click OK.
8. Double click the object to work with it. For example, format the table and insert a SUM function.
Note: the embedded object is part of the Word file. There's no link to the original Excel file. To create a link, at step 6, click Paste Link, Microsoft Excel Worksheet Object. Now, if you double click the object, Excel opens the Excel file. To embed a file in Excel, on the Insert tab, in the Text group, click Object.
.