Chapter 29: Sharing Data with Other Office Applications
617
Cross-Reference
See Chapter 4 for more information about the Office Clipboard. n
Copying from Excel to Word
One of the most frequently used software combinations is a spreadsheet and a word processor.
This section describes some of the ways to copy information from an Excel worksheet to a Word
document. Although I talk about Word here, most of the information in this section also applies to
PowerPoint.Generally speaking, you can copy something from Excel and paste it into Word in one of
two ways:l (^) As static information: If the Excel data changes, the changes aren’t reflected in the
Word document.
l (^) As a link: If the Excel data changes, the changes are shown in the Word document.
You can find all the various paste options for Word in the Paste drop-down list of Word’s Home
Clipboard group. In addition, various paste options are available from the Paste Special dialog box,
which appears when you choose Home ➪ Clipboard ➪ Paste ➪ Paste Special.
Note
If you use Word’s standard paste command (Home ➪ Clipboard ➪ Paste, or Ctrl+V), you’ll find that the paste
method varies, depending on what is pasted. An Excel range copied and pasted to Word is pasted as a static
table. An Excel chart, on the other hand, is pasted as a link. n
Pasting static information
Often, you don’t need a link when you copy data from Excel to Word. For example, if you’re pre-
paring a report in your word processor and you simply want to include a range of data from an
Excel worksheet, you probably don’t need to create a link (unless the data in the Excel worksheet
may be changed).After you’ve copied an Excel range, activate Word and choose Home ➪ Clipboard ➪ Paste, or
press Ctrl+V. The range appears as a Word table and is not linked to the Excel workbook.New Feature
When you paste information from Excel into a Word document, Word 2010 displays a Paste Options Smart
Tag, shown in Figure 29.1. This lets you choose a formatting option for the pasted information. n