Forum Discussion
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 result every time. But I assumed I should expect some differences, can anyone give me the obvious examples of these 2 options?
Thank you so much!
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.
7 Replies
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.
- Thank you for your reply, I afraid the link below doesn't contain what I'm looking for. I have searched on Google, believed me. I found descriptions on many website but none of them really show the differences between Paste All VS. All using Source theme. I tested it myself, also can't see the difference between them, I'm looking for someone who able to point out differences between these two. Can you provide differences between the 2 specifics above? Thank you so much!
I guess that's duplication of this Understanding the specific. Differences between Paste All and Paste all using sourcing theme - Microsoft Tech Community thread, isn't it?
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.
Rajesh_Sinha thank you for your reply, however, I'm looking for a specific example for Paste All VS. All using Source theme. Others types of specials, I didn't have a hard time understanding it. Can you provide differences between the 2 specifics above? Thank you so much!
Check this Dialogue box has all possible Paste Special options including ALL using source theme, the option ALL uses everything including Paste Theme from the source, otherwise each option has specif task as listed.
Glad to help you,, please keep asking ☺.
