Embedding an Excel Worksheet

Word allows you to embed a worksheet directly from Excel. The link established between your document and the Excel worksheet can be updated whenever you desire. To embed a worksheet in your document, follow these steps:

1. Open the Excel worksheet.
2. Select the portion of the worksheet you wish to embed in your Word document.
3. Press Ctrl+C to copy the selection to the Clipboard.
4. Switch to the Word document.
5. Position the insertion pointer where you want the worksheet placed.
6. Choose Paste Special from the Edit menu. The Paste Special dialog box will appear. (Click here to see a related figure.)
7. Select the Microsoft Excel Worksheet Object as the preferred method of pasting.
8. Make sure the Paste Link radio button is selected.
9. Click on OK. Word inserts the linked spreadsheet in your document.

When you later want to modify the Excel worksheet, simply double-click your mouse on it within your document. You can edit it using tools you are familiar with in Excel, and you can then click your mouse outside of the worksheet (elsewhere in your Word document) to return to regular Word editing. Any changes you make to the embedded spreadsheet are automatically saved in the original Excel spreadsheet.