Excel 2010 Bible

Chapter 29: Sharing Data with Other Office Applications

619

Notice the two option buttons: Paste and Paste Link. If you select one of the choices in the Paste

Special dialog box with the Paste option selected, the data is pasted without creating a link.

The paste options in Word’s Paste Special dialog box when a range is copied include

l Microsoft Excel Worksheet Object: You can edit this object with Excel. Double-click,

and the Word Ribbon is replaced with the Excel Ribbon. See “Embedding an Excel range

in a Word document,” later in this chapter.

l (^) Formatted Text (RTF): The range is pasted as a table, with some formatting retained.
l Unformatted Text: Only the raw information is pasted, with no formatting. Cells are sep-
arated with a Tab character.
l Picture (Windows Metafile): The range is pasted as a picture.
l (^) Bitmap: The range is pasted as a picture.
l Picture (Enhanced Metafile): The range is pasted as a picture.
l (^) HTML Format: The range is pasted as a table, with all formatting retained. This format is
pasted when you choose Home ➪ Clipboard ➪ Paste.
l (^) Unformatted Unicode Text: Only the raw information is pasted, with no formatting.
Cells are separated with a Tab character.
If you’ve copied an Excel chart to the Clipboard, Word’s Paste Special dialog box displays different
options. Figure 29.3 shows the Paste Special dialog box when an Excel chart is copied. The
options are
l Microsoft Excel Chart Object: You can edit this object with Excel. Double-click, and the
Word Ribbon is replaced with the Excel Ribbon.
l Picture (Windows Metafile): The chart is pasted as a picture.
l (^) Bitmap: The chart is pasted as bitmap image.
l Picture (Enhanced Metafile): The chart is pasted as a picture.
l (^) Picture (GIF): The chart is pasted as a GIF image.
l Picture (PNG): The chart is pasted as a PNG (Portable Network Graphics) image.
l (^) Picture (JPEG): The chart is pasted as a JPEG image, which usually results in a fuzzy
image.
l (^) Microsoft Office Graphic Object: The image is linked to the Excel range, and you can
also edit it in Word. This format is pasted when you choose Home ➪ Clipboard ➪ Paste.