![]() |
#1
|
|||
|
|||
![]()
I found in several places on the web, the solution to my inability to drag & drop cells in Excel 2010. The steps to take seemed easy enough to follow:
_Go to Excel Options _Click Advanced _Check the box to the left of "Enable fill handle and cell drag and drop" and below it, check the box to the left of "Alert before Overwriting Cells." _Click OK _Close and Restart Excel I then attempt to move a cell that I've clicked onto by moving my cursor to the corner of the cell until it changes to a small thin cross. I've gone through these steps several times, but to no avail. The cell doesn't move to where I attempt to drag and drop it to. It simply duplicates itself in the cell immediately below where the original cell is. What can I do to drag and drop a cell to another spot on the worksheet? ![]() |
#2
|
||||
|
||||
![]()
Try unchecking the 'After pressing Enter, move selection' option.
PS: There should be no need to re-start Excel for either option to take effect.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
Hi Paul,
Thanks for your speedy response. I followed your advice. In doing so, I discovered what the real problem was......................ME! I was moving the cursor to the border of the cell until the wide cross became a small thin cross. Then, I tried in vain to drag and drop the cell. I learned by accident that in order to execute the drag and drop, I must move the cursor to the border of the cell as before, but don't start dragging till I see 4 arrows pointing up, down, left & right. Then, it works! In all of the web explanations that I'd read, I never spotted this little difference! Thanks again for jumping on this. |
#4
|
||||
|
||||
![]()
Glad you got it sorted!
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
||||
|
||||
![]() Quote:
![]()
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
![]() |
Tags |
cell, drag, drop |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
masterton | Word | 7 | 12-02-2013 12:05 PM |
Excel 2010 drag-and-drop enabled but not working | BobBridges | Excel | 1 | 05-28-2013 09:23 AM |
Drop and drag macro | Jamtart | PowerPoint | 3 | 04-15-2012 11:05 PM |
Drag and drop rows in Excel | fireman0174 | Excel | 0 | 11-14-2011 05:26 AM |
Drag and drop contacts | christer | Office | 0 | 10-03-2011 09:54 AM |