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.

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?

- Go to
**File > Options > Advanced > Enable file handle and cell drag-and-drop** - Check this box.
- 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.

Heya

I know that there’s a mapping app, from Microsoft, for telling people used to 2203 how to get to Office features in 2007.

The Excel one lives here: http://office.microsoft.com/en-us/excel-help/interactive-excel-2003-to-excel-2007-command-reference-guide-HA010149151.aspx

@aimee – Thanks for the link. Bookmarked.

Really thanks for this!

thanks i got my need…..

Thanks, its worked

thanks

Thanks it worked and excellently explained

Thanks a lot. its works

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

Hey Thanx a Lot…..Its Works..

Thanks a lot, it was very helpful….

thank you verymuch

HI

It is more helpful.

Thanks

Manjunath

Really helpful… thanks or posting…

Hey.. Thank you so much…. It is working now…

I was searching it for so many days..

Thanks Again..

Kedar

Hey Thanks Mate ..

this really helped 🙂

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.

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

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

thank you! great help and well explained

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 ?

Thank you.

In my excel, it was never enabled to start with.

And there was me cursing the gayness of microsoft excel.

Its ROCKING!!

Thanks……….It Works…………

Thank you. It works and was very helpful

Thanks was helpful

Thanks for perfect solution.

Thanks very usefull information

thanks to help us.

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 🙂

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

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

Thank you so much. It really helped for me

thank you so much….!!!

Thank you so much…this really worked 🙂

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

Thanks a lot.

Thanks.. it really helps.. !!

Thansk a lot

Thanks a lot friend

thanks boss your site is really helped me.

Mr. Laxmidhar Panigrahi thanks its really works

Thanks a lot! It helped 🙂

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

Thanksssssssssssss

Thank Now it work.

Thank U!!!!!!!

MANY MANY THANKS…….

I GOT MY ANSWER………….

AGAIN THANKS AND THANK U SO MUCH……………………

993766311/8978907383

Hi Ankur,

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

Its really work thanks a ton

Thanks a lottttttttttt…….

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

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

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

Thanks it works well

THANK YOU SO MUCH.

MY PROBLEM WAS SOLVED WITH YOUR HELP.

THANK YOU VERY MUCH

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

Thanks for helpful solution .

Great, very useful link to understand

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

thanks works the charm

thanks…..this was helpful.

Thanks….. 100% ok

Thanks very much.

THANK YOU

thanks a lot for solving the problems

Thanks a lot it’s working now as expected 😀

Great!

Nicely explained-crisp and concise.

Many thanks

Thanks 🙂

Thanks for the Info.

Thanks. it is really working……..

Thanks a lot……….

Thanks for the help.

Thank you for the info

Sweet and soft………so easy

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

Thank You. IT really works well

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

Thanks.It made my work easier

Thanks a lot!!!

It was easy and helpful.. 🙂

Sir,

Thanks a lot for helping

It really workd . Simple !!

Thanks a lot, worked like a charm!!!

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

Dear Sir,

Thanks a lot. It is very useful and easy.

9502315463

It worked.. Thanks 🙂

Thanks for sharing such a simple tip

It worked, thanks a lot

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

thnx a lot…

Thanks a Lot…. it works

Super it worked 100%

Thanks Mr.Laxmidhar Panigrahi

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

Thanks for the help!

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

THANKS ANKUR

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

hey very thanks it is very usefull

Wow. Thanks.

Very much helpful… Thanks!

Thanks a lot….it does help.

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

Very informative dude….

Just I was struggling a lot with this small issue. No got relief 🙂

Thanks a lot, it works

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

Thanks for your update.

Really helpful

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

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

Very nice and easiest way expressed

Thanks for reference

Thanks a lot it works

Thanks a lot…

Thanks for easy reference and help.. it worked.

Hi,

Its really helpful. Thanks a lot for the simple explanation

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

Thank you very much!!! 🙂

Many thanks. you saved me a lot of time .

Cheers,

Aravind

Thanks a lot Ankur.

This article helped.