1.
Simple Paste Even CTRL+V serves the same purpose
(1 and CTRL+V’s logos are same). Even any comments in the cell is also carried.
Rather everything carried.
After copying if you hit Enter after selecting the destination it will do
the same.
2.
Data and formula will be copied (No format).
Even comments will not be carried to the new destination.
3.
Format will be pasted along with number
formatting.
4.
Same as 1 & Ctrl+V
5.
Other than the border everything will be
carried.
6.
This is
just a replica of the source. Even source column width is to be maintained.
7.
Transpose
option. Row & column perspective is to be changed. Other thing will
remain the same.
8.
Only values will be shifted. Formatting,
borders, colours, comments nothing will be shifted.
9.
Mostly same as 8
10.
All values and formatting, comments, except
formula, is to be carried to the new destination.
Paste Special leads to different window.
Where
some more options will be found.
Interestingly the ‘Formats’ option only carries the formats, say
colour, border etc. No data.
Comments option carries the comments in the cell only to the
destination.
Other options are mostly discussed above.
Other options are mostly discussed above.
Let’s see how Add, Subtract, Multiply, Divide works. Most of the time we will use none.
What about Cut Paste (Ctrl+x keyboard shortcut)?
When you cut and paste only option is Ctrl+V that is pasting entire thing.