Copy, copy data in Excel

With similar data or formats, instead of having to enter them all in turn, copying (copying) data in Excel is very necessary. Using the methods of copying data, you can quickly copy data, formulas, formatting ...

With similar data or formats, instead of having to enter them all in turn, copying (copying) data in Excel is very necessary. Using the methods of copying data, you can quickly copy data, formulas, formatting .

The article shows some ways to copy data in Excel, you can refer.

Data copy

In addition to copying data cells in Excel, use the Copy command (Ctrl + C) and the Paste command (Ctrl + V). You can use the mouse to copy data cells quickly.

1. Use the left mouse button.

Step 1: Select the data area to be copied.

Copy, copy data in Excel Picture 1Copy, copy data in Excel Picture 1

Step 2: Move the cursor to the bottom right corner of the selected data area, there appears a + sign .

Copy, copy data in Excel Picture 2Copy, copy data in Excel Picture 2

Step 3: Hold down the left mouse button and drag them to the locations to copy.

Copy, copy data in Excel Picture 3Copy, copy data in Excel Picture 3

Then release the mouse cursor.

Copy, copy data in Excel Picture 4Copy, copy data in Excel Picture 4

2. Use the right mouse button.

Step 1: Select the data area to be copied.

Copy, copy data in Excel Picture 5Copy, copy data in Excel Picture 5

Step 2: Move the mouse pointer to the bottom right corner of the selected data area so that the cursor becomes a + sign .

Copy, copy data in Excel Picture 6Copy, copy data in Excel Picture 6

Step 3: Hold down the right mouse button and drag the mouse to the position to copy then release the mouse cursor.

Copy, copy data in Excel Picture 7Copy, copy data in Excel Picture 7

Step 4: After releasing the mouse cursor, a dialog box will appear giving you the option to copy.

Copy, copy data in Excel Picture 8Copy, copy data in Excel Picture 8

Copy cells: copy data cells (data and format).

Fill Series: increase the order of numeric data contained in the data series in the copied cell.

Fill Formatting Only: only copy the format of the cell.

Fill Without Formatting: copy data without copying the format.

Copy the formula

To copy the formula you use the most common way is to select the formula to copy and press Copy and then paste (Ctrl + P).

You can also use the mouse to copy the formula, the formula will be changed arguments according to the position you paste. For example:

Copy, copy data in Excel Picture 9Copy, copy data in Excel Picture 9

After using the mouse to copy the formula, you will get the same formulas and the arguments in the formula will be changed accordingly.

Copy, copy data in Excel Picture 10Copy, copy data in Excel Picture 10

Copy the data being displayed

For example, you have hidden data ranges from row 6 to row 9, you just want to copy the data shown in the Sheet Sheet and hidden data does not copy. You do the following:

Step 1: Select the data area being displayed to be copied.

Copy, copy data in Excel Picture 11Copy, copy data in Excel Picture 11

Step 2: Press the key combination Alt + ; (Alt key and semicolon).

Copy, copy data in Excel Picture 12Copy, copy data in Excel Picture 12

Step 3: Press Ctrl + C to copy data.

Copy, copy data in Excel Picture 13Copy, copy data in Excel Picture 13

Step 4: Select the mouse where you want to paste the data and press Ctrl + P to paste the data, so only the displayed data is copied.

Copy, copy data in Excel Picture 14Copy, copy data in Excel Picture 14

Hopefully the above data copying methods will be useful to you, with the requirements you can apply how to copy the data accordingly. Good luck!

5 ★ | 1 Vote