Where to find Allow Cell Drag and Drop option in Excel 2010?

Share This Article:

Sometime back while working on excel 2010, it seems by mistake I disabled the option to use “cell drag and drop”. This feature allows you to drag the mouse and copy cells. If this option is disabled, your mouse pointer will never change to move pointer on selecting a particular cell.

Ok, here is what I mean. In the illustration shown below, mouse pointer is getting changed to move pointer as soon as I bring it to the edge of a cell.

excel2010

There is some info available on the net for Excel 2003 and the earlier versions ie  by going to Tools > Options > Edit and checking “Allow cell drag and drop”, you can enable this option but there is no information regarding the same for Excel 2007 and Excel 2010. So how can you enable this option in 2010?

  1. Go to File > Options > Advanced > Enable file handle and cell drag-and-drop
  2. Check this box.
  3. Click OK and you’re done

I wish there was some “mapping file” available from Microsoft for mapping excel 2003 and earlier versions navigation to excel 2007/2010. It could save us a lot of time.

120 thoughts on “Where to find Allow Cell Drag and Drop option in Excel 2010?”

  1. you can enable this option but there is no information regarding the same for Excel 2007

    Follow the Below steps
    1. Click on Office Button which is at Left top corner of Excel sheet
    2. Click on ‘Excel Option’ >> Advanced
    3. Check the ‘Enable fill handle and cell drag-and-drop’ checkbox
    4. Press OK

  2. Sir,
    Thanks a lot.

    I would request your kind self to provide us the tips of shorthand key commands in excel 2007/2010 against shorthand key commands used in excel 2003, as I am very much used to shorthand key commands in excel 2003. Microsoft company should have maintained same sequence of tools, commands, utilities in excel 2007/2010 (when introducing new features in excel 2007/2010) as time consumed will be lesser and will be helpful for excel 2003 users.

    Regards,
    P.G. Kerkar

    Hope you will take the matter into consideration.

  3. Dear Ankur,

    I’m working with Excel 10 and have checked the box ‘Enable fill handle and cell drag and drop’ but still the feature doesn’t work, and it’s so handy if it does. Do you have any idea why it wouldn’t work. Does it matter I work with Windows 7?

    regards,
    Paula

  4. fantastic, its really help me , i bit worried it looks some thing corropted.. Thanks.. God bless.. once question :: can we use shortcuts in 2007 excel which we were using in 2003 ?

  5. Thank you.

    In my excel, it was never enabled to start with.
    And there was me cursing the gayness of microsoft excel.

  6. Thanks a lot. I was searching for this info for past couple of days and even i repaired the Office setup. :( . You saved me from resinstalling the Office :)

  7. The Solutions works perfectly. I was struggling to figure why i am not able to drag and drop in excel. Thank you so much .

  8. MANY MANY THANKS…….
    I GOT MY ANSWER………….
    AGAIN THANKS AND THANK U SO MUCH……………………
    993766311/8978907383

  9. @ Paula,

    Some users, like you, may find that even after checking the box ‘enable fill handle and cell drag and drop’ they are unable to use the feature. In this case, just check if you are using the filter function, remove filter temporarily and the ‘drag for progressive numbering’ will work. I just hope it works for you.

  10. Thanks
    I feel by default “drag and drop” is disabled in office 2007 and 2010.
    I followed the procedure as given by you.
    It worked for excel 2007.
    thanks again..

  11. Thanks… :) now its working fine and given the below steps:
    Go to File > Options > Advanced > Enable file handle and cell drag-and-drop
    Check this box.
    Click OK and you’re done

    Again Thanks.. :)

Comments are closed.