Paste Special - Worksheet

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.

 

Paste Special Dialog

Click the Home | Clipboard | Paste | Paste Special command in the worksheet to open the Paste Special dialog.

 

Select a paste special format in the Paste Special dialog. This example shows options after copying Surfer 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 Surfer 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 Text] format is unformatted text.

 

Text [Clipboard Text]

The Text [Clipboard Text] format is unformatted text.

 

Show Import Options

When Unicode Text [Clipboard Text] or Text [Clipboard Text] is selected, the Show Import Options option is available. Check the box to open the Data Import Options dialog before importing the data. The Data Import Options dialog is useful when pasting data with comma, period, semicolon, or other column delimiters; fixed-width column data; ambiguous date/time formatted data; and data from different locales.

 

 

See Also

Removing Text Formatting

Paste Special - Plot Document

Selecting Cells

Delete - Worksheet

Clear

Insert

SLYK Spreadsheet File Description