You can edit pasted data when pasting it from the clipboard. To enable the option, select the Paste Special item in the cell's context menu.
The Paste Special dialog box opens during paste from the clipboard:
Set the parameters:
Paste from Clipboard. Determine parameters of paste special:
Cell Values. The checkbox is selected by default, and cell values are pasted. When the checkbox is deselected, cell values are not pasted.
Cell Formulas. The checkbox is selected by default, and formulas from the cells are pasted. When the checkbox is deselected, cell formulas are not pasted.
Cell Formatting. The checkbox is selected by default, and cell formatting is pasted. When the checkbox is deselected, the format specified for cells, to which data was pasted, will be be used.
Comments. The checkbox is selected by default, and cell comments are pasted. When the checkbox is deselected, cell comments are not pasted.
Skip Empty Cells. If the pasted data contains empty values, on selecting the checkbox the data is not pasted. Old data remains in the cells, to which empty values should have been inserted.
Transpose Data. When the checkbox is selected, inserted data is transposed, that is, rows are shown in columns and vice versa.
To restore the standard data paste mode from the clipboard, select again the Paste Special item in the cell's context menu.
See also: