1. Precisely Control Pasting
Excel allows precise control over what to paste when pasting cell data, enabling users to choose to paste values, formulas, formats, or other specific elements. This section will explore the role and applicable scenarios of each paste option in detail.
2. Paste All
"Paste All" pastes all content of the copied cells, including values, formulas, formats, comments, and more.
Note: The references of pasted formulas are based on the new content's references.
This is the default paste behavior.
Note: The references of pasted formulas are based on the new content's references.
This is the default paste behavior.
3. Paste Values
Only pastes the currently displayed values, excluding formulas or formats.
Note: The content of formulas will be pasted as the values calculated from the formulas.
Suitable for when you need to copy values to other parts of the worksheet without formulas or visual styles.
Note: The content of formulas will be pasted as the values calculated from the formulas.
Suitable for when you need to copy values to other parts of the worksheet without formulas or visual styles.
4. Paste Formulas
Only pastes formulas, excluding values or formats, and formulas will adjust references according to the new location.
Suitable for when you need to copy calculation logic to other parts of the worksheet without the current values or visual styles.
Suitable for when you need to copy calculation logic to other parts of the worksheet without the current values or visual styles.
5. Transpose Paste
Swaps rows and columns when pasting.
Suitable for when you need to convert rows to columns or vice versa, for example, converting a horizontal list to a vertical list.
Suitable for when you need to convert rows to columns or vice versa, for example, converting a horizontal list to a vertical list.
6. Paste Formats
Only pastes formats, excluding values or formulas.
Suitable for when you need to copy the visual styles of cells to other parts of the worksheet without values or formulas.
Suitable for when you need to copy the visual styles of cells to other parts of the worksheet without values or formulas.
7. Paste Link
Pastes a link to the source data, where the target cells update as the source data changes.
Suitable for when you need to create data associations within the worksheet.
Suitable for when you need to create data associations within the worksheet.
8. Paste Special
Paste Special options provide more control over paste options, such as pasting values, formulas, formats, comments, and more.
Suitable for when you need to control the pasted content more finely.
Suitable for when you need to control the pasted content more finely.
9. 🎉 Finish! 🎉
Author's Note: I hope you can feel the effort I put into these tutorials. I hope to create a series of very easy-to-understand Excel tutorials.If it is useful, help me share these tutorials, thank you!
Follow me:
Related Tutorials