Copy (copy), paste (paste data) feature is familiar and useful when you use Excel. But if you are familiar with using Ctrl + C and Ctrl + V to copy and paste data in Excel, you have missed many special Paste Special data paste features. So how to use the Copy and Paste feature in Excel effectively? Thuthuatphanmem.vn invites you to refer to the article below.
Here's how to use the Copy Paste feature in Excel effectively, please follow along.
Step 1: First you need to select the cells to copy data.
Step 2: Copy the selected data area.
There are 3 ways you can copy data in Excel: quickly press the keyboard shortcut Ctrl + C, or right-click the selected data area and select Copy .
Or you choose Home -> copy icon in the Clipboard section
Step 3 : Select the cell to paste data.
Step 4: Right-click, you will see in the Paste Options and Paste Special section there are many special types of data paste that you can use to paste the data most effectively.
The meaning of the data paste types is as follows:
Or you choose the tab Home -> Paste -> Paste Special to open the Paste Special dialog box .
On the Paste Special dialog box with paste options, the meaning of the paste options is as follows:
AllThe default option when you press Ctrl + V, paste all that was copied.
Formulas
Paste formulas (copy formulas)
Values
Paste values and results of formulas, do not copy formulas (copy values)
Formats
Paste formatting only (copy format)
Comments
Paste only the comments of the cells (copy the comment)
Validation
Paste only the data validation rules for the Data Validation target area.
All using source theme
Paste into everything and use the format template from the source area
All except borders
Paste everything except borders
Column widths
Only paste in the column width specification information (copy the column width).
Formulas and number formats
Pasting formulas and number formats, other formats are removed (copying formulas and number formats).
Values and number formats
Paste into values, results of formulas and original formats of numbers (copy values and number formats)
None
This is the default option, when you do not need to use the options Add, Subtract, Multiply, Divide, then select None.
Add
Add the values of the data range that you have copied into the corresponding cells in the data paste area.
Subtract
Subtract the values of the data range that you copied into the corresponding cells in the data paste area.
Multiply
Multiply the values of the data range that you copied into the corresponding cells in the data paste area.
Divide
Divide the values of the data range that you have copied into the corresponding cells in the data paste area. (The copy number is the divisor, the number in the box is the dividend).
Skip blanks
Do not paste empty cells in the source area into the values in the destination area (omitting blank cells).
Transpose
Paste in and invert the line into columns or vice versa
Paste Link
Paste in and reference the destination cell to the source cell
So you just need to choose the type of paste corresponding to the purpose, specific requirements, for example, paste the Formatting format .
So above, the article has shared with you the Paste Special data paste features and how to use the Copy and Paste feature in Excel most effectively. Hopefully after you learn this article, you will use the most appropriate Copy and Paste feature to help the process of working with Excel effectively. Good luck!