• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Part 10. Advanced Excel and Web Features > Copying and Linking to Office Docume...

Copying and Linking to Office Documents

In an Excel worksheet, select the cells that you want to copy or link to a Word document.

Click the Copy button on the Standard toolbar.

In a new, blank Microsoft Word document, click the Paste button on the Standard toolbar.

The cells are copied (not linked) into the Word document.


Until now, you have learned about the many ways you can copy and paste items in your workbooks. This takes you a step further by showing you how to copy and link your workbooks to other Office documents—for example, Word documents. 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.


Switching applications

You can switch between open applications just as easily as you switch between workbooks. Simply click on the taskbar button for the application you want to switch to.

To link, rather than copy, the data, click in the Word document then open the Edit menu and choose Paste Special to open the Paste Special dialog box.

Click the Paste link option button and, in the As field, choose Microsoft Excel Worksheet Object. Click OK; the cells are linked (not copied) into Word.

Switch back to your Excel workbook and edit the contents of one of cells that you copied (in this case, I changed Tom Fenter's region to 2).

Switch to the Word document and see that the cell content change was updated on the linked cells, but not the copied cells.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint