spot_img

Embed

 

Embed an Excel worksheet in a Word document and work with Excel in Word. You can also embed files in Excel.

1. Select the Excel data.

Excel Worksheet

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.

In Word, click Paste

5. Click Paste Special.

Click Paste Special

The Paste Special dialog box appears.

6. Click Paste, Microsoft Excel Worksheet Object.

7. Click OK.

Click Paste, Microsoft Excel Worksheet Object

8. Double click the object to work with it. For example, format the table and insert a SUM function.

Embedded Worksheet in Word

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.

spot_img
Previous articleCreate Drop-down Lists in Excel
Next articleGoal Seek in Excel