Option to deactivate ctrl+↓ type shortcuts.
Option to deactivate ctrl+↓ type shortcuts. There are more times were you are just Ctrl+v, ↓, Ctrl+v, ↓, etc. than the times you need to go to the end of the dataset. And obviously, even if activated, check whether the rest of the column is blank, so it does not take you 1048576 rows down.
Kenneth Barber commented
Instead of pasting cell by cell, select all of the cells that will be pasted into, and then paste just once.