Paste Special - Worksheet
When data are copied to the clipboard special formatting information is also copied. Use the Paste Special dialog to determine the format in which the contents are pasted into the worksheet. The Paste Special command can also be used to remove text formatting. See the Paste Special topic for selecting the format when pasting in the plot window.
Paste Special Dialog
The Home | Clipboard | Paste | Paste Special command opens the Paste Special dialog.
Select a paste special format in the Paste
Special
dialog. This example shows options after copying
Excel data and using the Paste
Special command.
The clipboard formats displayed in the Paste Special dialog may vary depending on from where the information was copied. For example, data copied from the Grapher worksheet may yield different options than data copied from Excel.
Biff8 [Excel Spreadsheet]
The Biff8 [Excel Spreadsheet] format is a Microsoft Excel Binary Interchange File Format (BIFF) version 8.
Biff5 [Excel Spreadsheet]
The Biff5 [Excel Spreadsheet] format is a Microsoft Excel Binary Interchange File Format (BIFF) version 5.
Biff4 [Excel Spreadsheet]
The Biff4 [Excel Spreadsheet] format is a Microsoft Excel Binary Interchange File Format (BIFF) version 4.
Biff3 [Excel Spreadsheet]
The Biff3 [Excel Spreadsheet] format is a Microsoft Excel Binary Interchange File Format (BIFF) version 3.
Biff [Excel Spreadsheet]
The Biff [Excel Spreadsheet] format is a Microsoft Excel Binary Interchange File Format (BIFF).
Sylk [Microsoft SYLK]
The Sylk [Microsoft SYLK] format is a symbolic link Microsoft file format typically used to exchange data between applications, specifically spreadsheets. The Sylk file format is composed of only displayable ANSI characters, allowing it to be easily created and processed by other applications, such as databases.
Csv [Comma Separated Variable]
The Csv [Comma Separated Variable] format is comma delimited with double quotes around text strings (non-numeric or mixed alpha numeric)
Text [Clipboard]
The Text [Clipboard] format is unformatted text.
Unicode Text [Clipboard]
The Unicode Text [Clipboard] format is unformatted text from a Unicode source.
Show Import Options
When Unicode Text [Clipboard] or Text [Clipboard] is selected, the Show Import Options option is available. Check the box to open the Data Import Options dialog before importing the data.