Paste Special when copying from programs other than Excel

You can use the Paste Special dialog box to copy complex items from a program other than Excel and paste those items into an Excel worksheet.

Source    Displays the name of the source data and its location. If you copied the data from a program that did not provide the source data and its location to the Clipboard, the source is identified as "Unknown."

Paste    Inserts or embeds the Clipboard contents at the insertion point in the format specified in the As box. When you select this option, the Clipboard contents are pasted or embedded as an object, but no link is created. If the data is embedded as an object, the source program is started when you double-click the worksheet data, and you then use the source program to edit the data.

Paste link    Creates a link from the pasted data to its source file. When you select this option, changes that are made to the source file will be reflected in the worksheet.

As    Specifies the type of data that you want to paste from the Clipboard.

Display as icon    Displays the Clipboard contents as an icon in the worksheet. When you select this check box, an icon appears in the destination area that you can click to see the embedded or linked data. Use this option if you do not want the embedded or linked data to be displayed in the worksheet.

Result    Describes the effects of the options that you select.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.