Embedding and Linking from the Clipboard

When you copy data to the Clipboard, the source application typically posts the data to the Clipboard in a variety of formats. When you use the Paste Special command in Excel (or another application, if you’re not pasting into Excel), the Paste Special dialog box lists all the available formats that the receiving application knows how to use, as Figure 31-1 shows. For example, if you copy a Microsoft PowerPoint 2010 slide, PowerPoint posts the slide to the Clipboard in more than a dozen formats. If you right-click a cell in your Excel worksheet and click the Paste Special command, the Paste Special dialog box lists only the formats that Excel can accept.

In many cases, the format that appears first in the ...

Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.