Thread: Paste Shortcut - When Copying Or Cutting Cell

After you select a cell to copy or cut, navigate to the cell you want to paste into and instead of doing a Ctrl-V, or right-clicking and choosing paste, just hit the enter key.

This not only pastes the cell, it also automatically de-selects the cell you copied from, preventing you from having to hit the esc key to de-select the copied cell.

Spence

Great tip! Such a small step that saves a lot of time and bother. Be aware though that you can't do multiple enters with the same data. You can however fill multiple adjacent cells with a single enter.