Copy, Copy Data in Excel

This article provides a clear overview of Copy, Copy Data in Excel, with the main facts, useful context, and practical details organized for easy reading.

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.

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

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

Then release the mouse cursor.

2. Use the Right Mouse Button.

Step 1: Select the data area to be copied.

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

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

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

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:

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

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

Step 3: Press Ctrl + C to copy data.

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