vert line

Paste Special allows you to take data from the Pasteboard and paste it in - with a twist!

Paste Special is most commonly used to paste just data (i.e. no formatting information) or conversely just formatting information (i.e. no data) from another cell on the worksheet.

Paste Values lets you paste the values from the cell range that was cut or copied into the pasteboard to another range without affecting its format or content. Note that the values in the pasted range will be frozen and formulas will be converted to their calculated values.

Paste Format lets you paste the format of the cell range that was cut or copied into the pasteboard to a specified location on a worksheet without pasting any included values.

Move lets you paste the contents of the cell range that was cut or copied into the pasteboard to a specified location on a worksheet. If the original range was copied to the pasteboard, this command clears the original range as it moves the data to the new one. Any references within the range to cells outside of the range still point to the same place.

You cannot Move ranges from one worksheet to another. To move a range from one worksheet to another, select the range in the first worksheet, Edit -> Cut it, and Edit -> Paste it into the second worksheet.

The Move operation is different from a Cut and Paste operation. If you Cut and Paste a range of cells, formulas that referred to the old location of the range continue to refer that location. If you Copy and Paste Special ->Move the cells, formulas elsewhere in your worksheet are updated to reflect the new location of the range.

Transpose places a copy of the cells on the clipboard at the current location on the worksheet, but transposes the rows and columns of the range. The cell in the second row and first column in the original range is placed in the first row and second column, etc.

Add adds the value in each cell on the pasteboard to the values in each cell of the selected range.

Subtract subtracts the value in each cell on the pasteboard from the values in each cell of the selected range.

Multiply multiplies the values in the selected range by the value of each cell on the pasteboard.

Divide divides values in each cell of the selected range by the value on the pasteboard.

See also

 

Also go to:

Index help

Contents help