If the Clipboard doesn’t contain whole rows or columns, these shortcuts always replace the selected cells.
To paste whole rows or columns |
Keyboard shortcut |
|---|---|
By replacing selected rows or columns |
esc t p r |
Before current selection (above top selected row or to left of leftmost selected column) |
esc t p b |
After current selection (below bottom selected row or to right of rightmost selected column) |
esc t p a |