Forum Discussion
Paste and Paste Special
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.
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 ☺.