Dragging and dropping cells with the keyboard

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
 
D

Debra Dalgleish

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

drag and drop editing 3
Drag and drop using only the keyboard. 1
EXCEL - I can not drag a cell with text to another cell, 2
Fixed/Locked cell referencing 6
Not able to drag formula to successive cells 2
Keyboard shortcut for name box 4
Operating fill handle and moving entire cells with keyboard 2
Re: Cut and "insert cut cells" in Excel 2007 doesn't work. 9

Top