The Paste Special dialog allows end-users to specify additional paste options after cutting or copying data to the Clipboard.

An end-user can specify the format of the pasted data using one of the following options available in the Paste Special dialog:
Option |
Description |
All |
Pastes all cell content and formatting. |
Formulas |
Pastes formulas as entered in the Formula Bar. Note that the relative cell references within the formula will be adjusted automatically to reflect the new location. |
Values |
Pastes cell values only (including the formula results, but not the formulas themselves). |
Formats |
Pastes cell formatting only. |
Comments |
Pastes only the comments added to cells. |
All except borders |
Pastes cell content and formatting without cell borders. |
Column widths |
Applies the column widths of the copied cells to another range of columns. |
Formulas and number formats |
Pastes only the formulas and number formatting options from the copied cells. |
Values and number formats |
Pastes only the values and number formatting options from the copied cells. |
Skip blanks |
Pastes the values of all cells except for empty cells. |
To provide end-users with the capability to invoke the Paste Special dialog, add the Clipboard Ribbon page group to the SpreadsheetControl. For an example on how to create a Ribbon UI, refer to the Getting Started topic.

To programmatically specify the part of the data to be pasted in the target cells, use the CellRange.CopyFrom method, which accepts a value of the PasteSpecial enumeration as a parameter. For details, refer to the How to: Copy Cell Data Only, Cell Style Only, or Cell Data with Style and How to: Copy a Row or Column examples.