Select a paste special format in the Paste Special
dialog. This example shows options after copying
Voxler worksheet data and using paste special.
The Edit | Paste Special command in the worksheet specifies the format for the pasted contents. Clicking the Edit | Paste Special command opens the Paste Special dialog.
When data are copied to the clipboard, special formatting information is also copied. The Paste Special dialog determines the format in which the contents are pasted into the worksheet. The Paste Special command can also be used to remove text formatting or correctly import data with different regional formatting.
Select a paste special format in the Paste
Special
dialog. This example shows options after copying
Voxler worksheet data and using
paste special.
The clipboard formats displayed may vary depending the original location of the information being copied. For example, data copied from the Voxler 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.
Unicode Text [Clipboard Text]
The Unicode Text [Clipboard] format is unformatted text.
Text [Clipboard Text]
The Text [Clipboard] format is unformatted text.
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.
See Also