Home / Computers / Microsoft Excel

Moving and Copying Data (Continued)

You can also use Excel's drag and drop functionality to copy cells; simply hold down the Ctrl key on your keyboard as you drag. Alternatively, you can use the Copy and Paste functions:

1.      Select the cell whose contents you want to copy.

2.      From the Edit menu, select Copy. Or, right-click the cell and select Copy from the shortcut menu. (You can also use the Ctrl+c keyboard shortcut.)

A blinking dashed border appears around the cell.

3.      Select the cell where you want the data to be copied.

4.      From the Edit menu, select Paste. Or, right-click the new cell and select Paste from the shortcut menu. (You can also use the Ctrl+v keyboard shortcut.)

5.      The data is pasted into the new cell.

You can continue to paste the same data into as many cells as you like.

Tip:

If you're only copying the data to one cell, you can press Enter as soon as you select the new cell. Excel will automatically paste the data.

6.      To finish pasting and remove the dashed outline from the original cell, press Enter.