You are here KNOWLEDGE Excel Tips Excel General Copying, Cutting and Pasting (Moving)

Query, Share and Manage Excel workbooks on LAN, Internet

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.