Dragging and dropping cells with the keyboard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there anyway to drag and drop cells using keyboard shortcuts
For example in Word you can highlight text, press F2 and then move the cursor to the desired locatiion and press enter
I know you can copy/cut and paste but dragging and dropping cells with formulas maintains cell references without having to input '$' holding signs. This would be particularly helpful for large ranges

Thank you for your time
Tom
 
You can cut (Ctrl+X), then use the arrow keys to another cell, and paste
(Ctrl+V). The original references are maintained.

Or, select a cell, and press the F2 key to enter Edit mode.
Press Shift+Ctrl+Home, to select the formula
Press Ctrl+C to copy
Move to another cell, then paste.
 
Back
Top