In an Office document (for example, an Excel worksheet), select the cells you want to copy or link to in another document (for example, a Word document).
Click the Copy button on the Standard toolbar.
In a new, blank Office document (here, a Microsoft Word document), click the Paste button on the Standard toolbar.
The cells are copied (not linked) into the Word document.
INTRODUCTION
Until now, you have learned about the many ways you can copy and paste items in your documents. This task takes you a step further by showing you how to copy and link to other Office documents for example, between Excel and Word, as outlined in this task. When you paste data, the data becomes part of the new location and is no longer representative of any changes made to the original location. When you link data, the link can be updated so that any changes to the original location will display in the new location.
To link the data (not copy), click in the document where you want the data to appear; then selct Edit, Paste Special to open the Paste Special dialog box.
Click the Paste Link option button and, in the As field, select Microsoft Excel Worksheet Object. Click OK; the cells are linked (not copied).
Switch back to your Excel worksheet and edit the contents of one of the cells you copied (in this case, I changed Tom Fenter's region to 2).
Switch to the Word document and see that the cell content was updated in the linked cells but not the copied cells.
TIP
Using the Paste Link Option
If you neglect to select the Paste Link option in the Paste Special dialog box, the linked data won't be updated when you change a cell's contents.
TIP
Pasting As Hyperlinks
Besides pasting a cell as a link to another document, you can paste a cell as a hyperlink. This enables you to click the pasted cell and immediately be switched to the worksheet that contains the cell. To paste data as a hyperlink, click in the document where you want the hyperlink to appear, open the Edit menu, and select Paste Hyperlink.
