Forum Discussion
Solved
Paste and Paste Special
Hi, I'm curious what is a differences between Paste All (CTRL+V) and Paste Special - Paste all using sourcing theme? I tried with a few things e.g. copy cells, copy chart it gave me exactly the same ...
Paste Special provides advanced pasting feature, such as cell content, formulas, values, formatting. It only works with the Copy command but it wouldn't work after using the Cut commands.
The Paste Special perform the following:
- Pastes only the values in cells but not the formulas & formatting.
- Pastes only the formulas in cells not the formatting.
- Transpose data.
- Transform a range of numeric data by adding, subtracting, dividing, or multiplying each number in the range by a given constant.
M1931 Well, I guess the link below says it all. It's the first hit I get when Googling for "Paste special Excel", and there are plenty more resources out there.