Is it possible to move the contents of a cell (eg from A1 to B4) in Excel using the keyboard (the arrows) without using cut and paste? Something similar when using the mouse and drag in the edge of a cell, but with the keyboard.
Asked
Active
Viewed 3.0k times
2 Answers
1
Looking at the Keyboard shortcuts in Excel page, it doesn't look like there is a specific keyboard shortcut to do this so your best bet would probably simply be Ctrl + x, arrow keys then Ctrl + v.
pelms
- 9,361
1
When cell dragging is recorded as a macro, the resulting VB code uses select, cut, copy and paste, depening on whether ctrl is used to duplicate, and whether alt is used to move to another sheet. Also, dragging a cell clears the paste buffer. Both of these seem to indicate that cell dragging really uses cut-copy-paste behind-the-scenes, so it's unlikely you can move the contents of a cell without using cut and paste, even if you use the mouse.
Nick Russo
- 1,219