4

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.

Xtreme
  • 161
  • 1
  • 1
  • 3
  • 4
    **Why?** Please elaborate what you are trying to accomplish as this will help with a solution – Eric F Oct 03 '14 at 13:20

2 Answers2

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,251
  • 12
  • 58
  • 77
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,169
  • 7
  • 11
  • 1
    [This question](http://superuser.com/questions/611854/prevent-excel-from-clearing-copied-data-for-pasting-after-certain-operations-w) is **very relevant** to what you've said here. – Raystafarian Oct 03 '14 at 13:44
  • "The official reason is that Excel doesn't really have cut and paste, it has move and copy" -- so for this question, the answer is "Sure, you're never using cut anyway!" LOL – Nick Russo Oct 03 '14 at 13:57