How to use the Copy Paste feature in Excel effectively?

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.

How to use the Copy Paste feature in Excel effectively? Picture 1

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.

How to use the Copy Paste feature in Excel effectively? Picture 2

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 .

How to use the Copy Paste feature in Excel effectively? Picture 3

Or you choose Home -> copy icon in the Clipboard section

How to use the Copy Paste feature in Excel effectively? Picture 4

Step 3 : Select the cell to paste data.

How to use the Copy Paste feature in Excel effectively? Picture 5

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.

How to use the Copy Paste feature in Excel effectively? Picture 6

The meaning of the data paste types is as follows:

How to use the Copy Paste feature in Excel effectively? Picture 7

How to use the Copy Paste feature in Excel effectively? Picture 8

Or you choose the tab Home -> Paste -> Paste Special to open the Paste Special dialog box .

How to use the Copy Paste feature in Excel effectively? Picture 9

On the Paste Special dialog box with paste options, the meaning of the paste options is as follows:

The 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 .

How to use the Copy Paste feature in Excel effectively? Picture 10

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!