1. Technology
Send to a Friend via Email
Embedding and Linking to Excel Files in Word Documents
Part 2: Embedding an Excel Worksheet in a Word Document
 More of this Feature
• Part 1: Linking to an Excel Worksheet
 
 Related Terms
• Data Source
• Excel
• Workbook
 
 Related Resources
• Enabling/Disabling Picture Placeholders
• Excel and Mail Merge
• Word Tutorials
 

The process of embedding an Excel worksheet in your Word document is essentially the same as linking to an Excel worksheet. The only difference is in the options you specify in the Paste Special dialog box. While the results might appear the same at first, they are dramatically different. If you missed the first part of the tutorial, now would be a good time to go back and read up on the differences between embedding and linking.

If you're using Word 2007, learn how to embed Excel data in Word 2007. Or, to embed an Excel file in earlier versions, follow these simple steps:

1. Open both the Word document and the Excel spreadsheet
2. In Excel, copy the range of cells you want to include
3. In your Word document position the cursor where you would like the table inserted
4. On the Edit menu, select Paste Special…



5. Click the radio button beside Paste



6. Under the label As:, select Microsoft Excel Worksheet Object
7. Click OK




Previous: Linking to an Excel Worksheet in a Word Document
Return to Advanced Tutorials


©2014 About.com. All rights reserved.