how to attach word document in excel

原创 admin 2021-01-09 03:59 

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.

版权声明: 本文为4find – 解决程序猿问题原创文章,欢迎转载。转载请务必注明出处! (参考格式:本文转自4find – 解决程序猿问题,原文地址:http://4find.cc/archives/6752

发表评论


表情