Paste Special when copying from applications other than Excel

Microsoft Office Excel 2003

Show All Show All

Paste Special when copying from applications other than Excel

You can use the Paste Special dialog to copy complex items from an application other than Excel and paste them into an Excel worksheet.

Show Source

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

ShowPaste or Paste link

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, but no link is created. Select the Paste link check box to link the pasted data to its source document.

Show As

Specifies the type of information you want to paste from the Clipboard.

Show Display as icon

Displays the Clipboard contents as an icon. Use this option if you do not want linked data to be displayed in your file.