When copy and pasting, Paste Special gives you more options regarding how data is pasted. To access the Paste Special Menu, select the cell to be pasted into, right click on the cell and click Paste Special or press Ctrl + Alt + V. Some of the features within Paste Special are the Values, Transpose and Paste Link.

• Values option allows the pasting of a value calculated by a formula, as just pasting into a cell will paste the formula. To get the actual value calculated by the formula, select Values. Values and number formats can also be used if the original cell has been formatted.
• Transpose option allows for pasting a column as a row or vice versa. For example, if there is a list of items in a column that are to become row headings, copy the list, select the first cell to be pasted into and tick the box Transpose. This will paste across the row rather than into a column.
• Paste Link button will paste a link back to the original data rather than the formula or value. Any changes made to the original data will be updated here also.

Paste Special can be run multiple times on the same cell with different features selected without re-copying the previous cell, i.e. first paste the value, then the format, then any comments from the previous cell copied.