Using Paste Special

When you copy a cell, you can paste a certain part of the cell contents. It can be you specify via the Paste Special dialog box is accessed via the button Paste, Paste Special on the Home tab Clipboard group.

In the Paste Special dialog box are jerked group options how to paste the object. The first is "Paste" to determine what is pasted on the objects that have been copied. Both "Operation" is to determine how the value of the copied object is calculated by the value of objects that exist in a cell at the destination location. The third group of options Skip Blank and Transpose. Being the fourth is Paste Link.

All	All components of the copied cell or range that will participate in the paste. Component by default it consists of values, formulas, formatting, notes and borders as well as the reference. This option has the same effect with the command Edit, Paste.
formulas	which is pasted only formula alone.
Values	which is pasted only the value of the cell was just so that when the value it occupies its new location, it will use the format that was applicable at the new location of the cell.
Formats	which is pasted only format that applies to cells in the copy, where the format of the component consists of font formatting (font name, size, font color, style, bold / italic / underlined, borders, shading, the format of the form of writing numbers, and alignment).
Comment	which is pasted only notes (95) or comment (97/2003) which is inserted in the cell source.
All Except Borders	were pasted all of the components are similar in all options, only without including borders and shading.
None	copied object is pasted to the destination location without any operation, just put it. If the destination location has no content, then it will be over-write the alias stacked with new data.
Add	copied objects are added value to the value of the destination cell.
Substract	copied objects are subtracted value by the value of the destination cell.
Multiply	the copied object value multiplied by the value of the destination cell.
Divide	the copied object value divided by the value of the destination cell.
Skip Blanks	if the range is copied cells are empty, then when pasted to the destination cells that had been empty it will be left empty, meaning that it does not accumulate data on the destination cell.
Transpose	Paste the copied object in a different order. If originally in the form of columns Paste Special, Transpose will be poured in the form of lines, and vice versa.
Paste Link	Paste the copied object while providing a link relationship with cell source. If the source cell value is changed, then the cells become correspondentnya will also change.