To paste, use Control + V on Windows and Command + V on the Mac.
Note that when formulas are copied, relative cell references will update automatically.
Use cut when you want to actually move data or formulas from one location to another.
The shortcut is Control + X on Windows, and Command + X on the Mac.
When you use cut, relative cell references will not change.
The contents of the cells are moved from one location to another.
As with Cut, cell references in formulas won’t change.
When you release the selection, you’ll have a copy of cell contents.
Just like a normal copy, relative cell references will change.
Drag and drop also allows you to insert cells.
Just hold down the shift key and then drag the selection.
You’ll need to watch the cursor carefully to understand where the inserted cells will go.
This is a great way to quickly reorganize smaller sets of data without copying and pasting.
This lets you drag a selection directly from one sheet to another.
Use the control key to copy the selection.
