You are here LEARN EXCEL & VBA Excel Tips Excel General Copying, Cutting and Pasting (Moving)

Copying, Cutting and Pasting (Moving)

Using keyboard shortcuts

To copy, press Ctrl+C.
To cut, press Ctrl+X.
To paste, with the option of repeating the operation (if copying), press Ctrl+V.
To paste, without the option of repeating the operation (if copying), press Enter.

Using the mouse

To copy a cell(s), row(s), column(s), or sheet:

1. Select a cell(s), row(s), column(s), or sheet tab.
Press Ctrl and hold the mouse over the selection border, while left-clicking and moving the object to a new location, Release both the Ctrl key and the mouse.
OR: Press F8 to lock the Ctrl key (the letters EXT appear in the Status Bar), now left-clicking and moving the object to a new location.
Release the mouse and press F8 again to unlock the Ctrl key.

To move (cut and paste) a cell(s), row(s), column(s), or sheet:

1. Select the object.
2. Hold the mouse over the selection border, left click and move the object to a new location.
3. Release the mouse.