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

by | Last Updated On Sep 6, 2013 | how to | 120 comments

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 Comments

  1. Kumar
    Kumar on September 5, 2013 at 8:08 PM

    Thanks a lot Ankur.
    This article helped.

  2. Aravind
    Aravind on September 3, 2013 at 6:45 PM

    Many thanks. you saved me a lot of time .

    Cheers,
    Aravind

  3. Sonaa
    Sonaa on September 3, 2013 at 3:19 PM

    Thank you very much!!! 🙂

  4. sonal
    sonal on August 22, 2013 at 4:08 PM

    hey Ankur… it works.. thanks .. i was really struglling for long… 🙂

  5. P Sureshmani
    P Sureshmani on August 20, 2013 at 2:06 PM

    Hi,

    Its really helpful. Thanks a lot for the simple explanation

  6. Raman
    Raman on August 19, 2013 at 6:36 PM

    Thanks for easy reference and help.. it worked.

  7. Adnan
    Adnan on August 17, 2013 at 3:56 PM

    Thanks a lot…

  8. Arvind
    Arvind on August 16, 2013 at 7:14 PM

    Thanks a lot it works

  9. Nilesh P. Gawas
    Nilesh P. Gawas on August 16, 2013 at 1:51 PM

    Thanks for reference

  10. Jayakumarnaik
    Jayakumarnaik on August 14, 2013 at 3:21 PM

    Very nice and easiest way expressed

  11. sitaram agarwal
    sitaram agarwal on August 9, 2013 at 5:06 PM

    thanks a lot, this information is very helpful. gr8 job..!!

  12. BRISH BHAN
    BRISH BHAN on August 9, 2013 at 7:49 AM

    Thanks for Help to Enable file handle and cell drag-and-drop.

  13. Shinju
    Shinju on August 8, 2013 at 3:02 PM

    Really helpful

  14. Anantha Padmanabhan
    Anantha Padmanabhan on August 8, 2013 at 12:56 PM

    Thanks for your update.

  15. Rohit Bhadait
    Rohit Bhadait on August 8, 2013 at 11:31 AM

    Thanks lot!!!!!! It’s Working…………. 🙂

  16. Kumar
    Kumar on August 7, 2013 at 12:55 PM

    Thanks a lot, it works

  17. Phani RAJ
    Phani RAJ on August 7, 2013 at 10:22 AM

    Very informative dude….
    Just I was struggling a lot with this small issue. No got relief 🙂

  18. Ashok
    Ashok on August 6, 2013 at 6:53 PM

    Very great !! Thank you so much! in fact i was very big headache for this problem not resolved

  19. Neeraj
    Neeraj on August 6, 2013 at 4:14 PM

    Thanks a lot….it does help.

  20. Selvin
    Selvin on August 5, 2013 at 12:20 PM

    Very much helpful… Thanks!

  21. Ankit
    Ankit on August 3, 2013 at 4:31 PM

    Wow. Thanks.

  22. Sunil
    Sunil on August 2, 2013 at 1:11 PM

    hey very thanks it is very usefull

  23. Mukesh
    Mukesh on July 31, 2013 at 2:47 PM

    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.. 🙂

  24. ANIL KUMAR
    ANIL KUMAR on July 30, 2013 at 8:55 PM

    THANKS ANKUR

  25. Prasad
    Prasad on July 30, 2013 at 7:54 PM

    Thanks a lot…the help is best served when needed!!!

  26. Yogesh
    Yogesh on July 30, 2013 at 6:56 PM

    Thanks for the help!

  27. sushil
    sushil on July 30, 2013 at 5:51 PM

    Thanks A Lot….really appreciate this….:-)

  28. Ravikumar
    Ravikumar on July 30, 2013 at 11:15 AM

    Super it worked 100%
    Thanks Mr.Laxmidhar Panigrahi

  29. Ashwin
    Ashwin on July 30, 2013 at 11:08 AM

    Thanks a Lot…. it works

  30. Himanshu Maheshwari
    Himanshu Maheshwari on July 29, 2013 at 11:05 AM

    thnx a lot…

  31. Vara Prasad
    Vara Prasad on July 26, 2013 at 5:00 PM

    Thanks a lot for sharing. It is very useful and easy

  32. vengadassalabady
    vengadassalabady on July 26, 2013 at 9:32 AM

    It worked, thanks a lot

  33. Mak
    Mak on July 23, 2013 at 2:03 PM

    Thanks for sharing such a simple tip

  34. Priyal
    Priyal on July 23, 2013 at 12:49 PM

    It worked.. Thanks 🙂

  35. Vicky
    Vicky on July 19, 2013 at 2:55 PM

    Dear Sir,

    Thanks a lot. It is very useful and easy.

    9502315463

  36. sachin
    sachin on July 18, 2013 at 4:51 PM

    Really thanks for the given info regarding excel 2010, it really works..

  37. Kamlesh
    Kamlesh on July 17, 2013 at 5:50 PM

    Thanks a lot, worked like a charm!!!

  38. Mohan
    Mohan on July 16, 2013 at 6:21 PM

    It really workd . Simple !!

  39. Mahesh
    Mahesh on July 16, 2013 at 5:05 PM

    Sir,

    Thanks a lot for helping

  40. Sruti
    Sruti on July 16, 2013 at 4:32 PM

    Thanks a lot!!!

    It was easy and helpful.. 🙂

  41. Anil
    Anil on July 16, 2013 at 2:19 PM

    Thanks.It made my work easier

  42. Vinit Sharma
    Vinit Sharma on July 16, 2013 at 10:46 AM

    Thanks it worked for me .. was so much in problem

  43. Sakthivel Krishnan
    Sakthivel Krishnan on July 11, 2013 at 11:47 AM

    Thank You. IT really works well

  44. Dr Manas
    Dr Manas on July 10, 2013 at 11:54 AM

    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..

  45. abhimanyusinghbhati
    abhimanyusinghbhati on July 3, 2013 at 3:29 PM

    Sweet and soft………so easy

  46. Kumar
    Kumar on July 3, 2013 at 7:19 AM

    Thank you for the info

  47. mranka
    mranka on June 13, 2013 at 3:47 PM

    Thanks for the help.

  48. prashant
    prashant on June 5, 2013 at 6:59 PM

    Thanks a lot……….

  49. Santosh
    Santosh on May 16, 2013 at 5:02 PM

    Thanks. it is really working……..

  50. Aamir
    Aamir on May 9, 2013 at 10:24 AM

    Thanks for the Info.

  51. Ganesh S
    Ganesh S on April 30, 2013 at 9:26 AM

    Thanks 🙂

  52. Ananta
    Ananta on April 26, 2013 at 5:38 PM

    Great!
    Nicely explained-crisp and concise.

    Many thanks

  53. Sudhakar
    Sudhakar on April 18, 2013 at 2:18 PM

    Thanks a lot it’s working now as expected 😀

  54. chetan
    chetan on April 7, 2013 at 12:16 PM

    thanks a lot for solving the problems

  55. manoj
    manoj on March 25, 2013 at 7:59 PM

    THANK YOU

  56. Riddhi
    Riddhi on March 22, 2013 at 4:51 PM

    Thanks very much.

  57. Indresh
    Indresh on March 22, 2013 at 2:56 PM

    Thanks….. 100% ok

  58. Prakash Shirodkar
    Prakash Shirodkar on March 21, 2013 at 11:23 AM

    thanks…..this was helpful.

  59. Gabbaar
    Gabbaar on March 11, 2013 at 2:36 PM

    thanks works the charm

  60. Shravan
    Shravan on March 11, 2013 at 1:39 PM

    Thanks a lot. This is exactly what i was looking for.

  61. Randhir Jha
    Randhir Jha on February 6, 2013 at 1:10 PM

    Great, very useful link to understand

  62. mahesh kumar
    mahesh kumar on January 30, 2013 at 9:09 AM

    Thanks for helpful solution .

  63. Amir Riaz
    Amir Riaz on January 30, 2013 at 3:36 AM

    @ 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.

  64. SANJAY BHATT
    SANJAY BHATT on January 16, 2013 at 9:45 PM

    THANK YOU VERY MUCH

  65. NIDHI
    NIDHI on January 4, 2013 at 3:19 PM

    THANK YOU SO MUCH.
    MY PROBLEM WAS SOLVED WITH YOUR HELP.

  66. Dr.Prasanna
    Dr.Prasanna on December 28, 2012 at 12:51 AM

    Thanks it works well

  67. Amit Thakur
    Amit Thakur on December 25, 2012 at 1:10 PM

    Thanks a lot. It was so easy and very helpful.

  68. Sharath Kumar
    Sharath Kumar on December 15, 2012 at 4:12 PM

    Thanks a lot for the solution. It helped me a lot.

  69. Imran Ahmed
    Imran Ahmed on November 27, 2012 at 10:52 AM

    Thanks a lot for this write up. Saved a lot of time….

  70. amol
    amol on October 31, 2012 at 12:24 PM

    Thanks a lottttttttttt…….

  71. Faisal
    Faisal on October 17, 2012 at 6:48 PM

    Its really work thanks a ton

  72. Mihir
    Mihir on October 16, 2012 at 4:11 PM

    Hi Ankur,
    Thank you very much. You really saved me a lot of time.

  73. TARA
    TARA on October 4, 2012 at 10:56 AM

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

  74. naveen
    naveen on September 28, 2012 at 1:36 PM

    Thank U!!!!!!!

  75. Ramkumar
    Ramkumar on September 19, 2012 at 5:35 PM

    Thank Now it work.

  76. son
    son on September 17, 2012 at 10:22 AM

    Thanksssssssssssss

  77. Vani
    Vani on September 4, 2012 at 2:33 PM

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

  78. Jyothi Bhat
    Jyothi Bhat on August 31, 2012 at 1:58 PM

    Thanks a lot! It helped 🙂

  79. mangesh
    mangesh on August 30, 2012 at 12:01 PM

    Mr. Laxmidhar Panigrahi thanks its really works

  80. Ashok biswal
    Ashok biswal on August 29, 2012 at 6:22 PM

    thanks boss your site is really helped me.

  81. Bhola
    Bhola on August 27, 2012 at 7:58 PM

    Thanks a lot friend

  82. Rohan
    Rohan on August 17, 2012 at 2:27 AM

    Thansk a lot

  83. Jay
    Jay on August 13, 2012 at 3:21 PM

    Thanks.. it really helps.. !!

  84. Tarsem Lal
    Tarsem Lal on August 13, 2012 at 3:12 PM

    Thanks a lot.

  85. Pandarinath
    Pandarinath on August 10, 2012 at 11:29 AM

    thanks cool!!!!!!!!!!!!

  86. P. Suresh Ganesh
    P. Suresh Ganesh on August 9, 2012 at 3:39 PM

    Thank you so much…this really worked 🙂

  87. DEBASHISH DAS
    DEBASHISH DAS on August 7, 2012 at 12:27 PM

    thank you so much….!!!

  88. Raja
    Raja on July 31, 2012 at 10:48 AM

    Thank you so much. It really helped for me

  89. kingshuk
    kingshuk on July 31, 2012 at 12:28 AM

    Hey,thanks Sir.I was facing a lot of problem…your site helped me..may God bless u..

  90. Muraaali
    Muraaali on July 13, 2012 at 10:23 AM

    Thank you so much. friend keep on update any tips n tricks.

  91. Karthikeyan
    Karthikeyan on July 10, 2012 at 5:12 PM

    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 🙂

  92. vinod sinha
    vinod sinha on July 9, 2012 at 10:41 AM

    thanks to help us.

  93. yogesh
    yogesh on July 4, 2012 at 4:57 PM

    Thanks very usefull information

  94. Yadav N B
    Yadav N B on July 3, 2012 at 6:17 PM

    Thanks for perfect solution.

  95. Srini
    Srini on June 27, 2012 at 6:27 PM

    Thanks was helpful

  96. Ram
    Ram on June 26, 2012 at 4:04 PM

    Thank you. It works and was very helpful

  97. Dimple
    Dimple on June 26, 2012 at 10:32 AM

    Thanks……….It Works…………

  98. Kastur
    Kastur on June 15, 2012 at 10:34 PM

    Its ROCKING!!

  99. Saqib
    Saqib on June 11, 2012 at 8:07 PM

    Thank you.

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

  100. arun
    arun on May 4, 2012 at 4:43 PM

    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 ?

  101. paula
    paula on May 3, 2012 at 1:45 PM

    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

    • Ankur Jain
      Ankur Jain on May 4, 2012 at 3:12 PM

      @paula: I’m not sure, once you check the box, see if closing and then opening Excel helps you. I did this on Win XP.

    • James
      James on August 1, 2013 at 4:42 PM

      thank you! great help and well explained

  102. Pandharinath G. Kerkar
    Pandharinath G. Kerkar on December 28, 2011 at 7:28 PM

    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.

  103. Nooram
    Nooram on September 21, 2011 at 12:26 PM

    Hey Thanks Mate ..

    this really helped 🙂

  104. Kedar
    Kedar on September 12, 2011 at 2:28 PM

    Hey.. Thank you so much…. It is working now…
    I was searching it for so many days..

    Thanks Again..

    Kedar

  105. Nandagopal R R
    Nandagopal R R on August 11, 2011 at 5:32 PM

    Really helpful… thanks or posting…

  106. Manjunath
    Manjunath on July 15, 2011 at 1:45 PM

    HI

    It is more helpful.

    Thanks
    Manjunath

  107. Laxmidhar Panigrahi
    Laxmidhar Panigrahi on June 15, 2011 at 11:54 AM

    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

    • Sunil Bankar
      Sunil Bankar on June 23, 2011 at 1:13 PM

      Hey Thanx a Lot…..Its Works..

    • Senthil
      Senthil on August 5, 2012 at 4:04 PM

      Thanks a lot, it was very helpful….

    • kumaravel
      kumaravel on August 24, 2013 at 12:03 PM

      thank you verymuch

  108. Shashikant
    Shashikant on June 14, 2011 at 4:34 PM

    Thanks a lot. its works

    • Ankur
      Ankur on August 6, 2010 at 2:13 PM

      @aimee – Thanks for the link. Bookmarked.

      • Thanks
        Thanks on August 13, 2012 at 3:52 PM

        Really thanks for this!

      • basavaraj
        basavaraj on August 16, 2013 at 12:35 PM

        thanks i got my need…..

        • Sagar
          Sagar on August 26, 2013 at 7:47 AM

          Thanks, its worked

          • abc
            abc on September 4, 2013 at 4:50 PM

            thanks

    • Joice
      Joice on September 6, 2013 at 2:47 PM

      Thanks it worked and excellently explained

Pin It on Pinterest

Share This