Allow Cell Drag and Drop Option in Excel 2003, 2007 and 2010
Hi Friends,
Before I go and explain you how to enable or disable drag and drop option in Excel, let me explain you what is Drag and Drop Option in Excel.
What is Drag and Drop Option in Excel ? When you select a Cell in Excel and roll your mouse to the RightBottom Corner, one Plus Sign ( + ) will be appearing. On Clicking on that you can drag towards Column or Row in any Direction like Left, Right, Above or down. After dragging you can copy the Cells data in all the Cells till you dragged.
While working on Excel, you suddenly find that you are unable to Drag and Drop a Cell. Without this working with Excel seems difficult because you are not able to drag a Series or Formula. Then you start looking for option to make this function enabled. Here is the stepbystep solution for that. It differs in Excel 2003 and 2007 or 2010. I will show, how to Enable/Disable this property in Excel 2003 and 2007. In Excel 2007 and 2010, it is same.
How to Enable or Disable Cell Drag and Drop Option in Excel 2003
Follow the below Steps:
Step 1. Go to Tools –> Options
Step 2. Select the Edit Tab. Here you have that highlighted Checkbox to enable and disable drag and drop in Excel 2003.
How to Enable or Disable Cell Drag and Drop Option in Excel 2007
Follow the below Steps:
Step 1. Click on the Excel Button at the Top Left Corner of Excel 2007 or 2010.
Step 2. Go to Advanced Tab
Step 3. Here in right hand side, you find the Checkbox to enable and disable this property as shown below in the picture:
My name is Vishwamitra Mishra. Friends Call me Vishwa. This blog is authored by me. I am an Excel Geek. Well, this blog talks a lot about my passion in Excels & Macros so I’ll not talk about it :) I am very much passionate about traveling & quite recently discovered that I am a good photographer too..:P

SUBSCRIBEAND GET A FREE!EBOOK FOR EXCEL VBA BEGINNERSDON'T MISS ANY NEW ARTICLE ! 
Get your FREE! EBook & Have Every New Article Delivered Straight To Your EmailBox 
Thanks Brother…
Thank you, Vishwamitra.
You have solved my problem.
Thanks a ton. It was really helpful to complete my Bau.
Thank u simple and easy for amateurs like me. so quickly understood.
Thanks
Thanks a lot
Great help
Thank you.
Thanks for the help. Now its working properly.
Thanks bro….thanks a lot
Thanks for your great help.
Regards,
basuki
yess very helpfull
Solution works perfect. Thanks a lot
Thank you. it is very useful to us.
Thank you. it is very useful to us.
Its very useful
Thank You Sir
thaanx a lot brother ..
much appreciated…
This solution helped me. Thank u
thanks, it is very helpful……………
The solution was perfect and 100% assisted me in fixing the issue in excel 2007.
Thank you …So Much appreciated !!!
This information really helps me to find the solution for 2007 software
Thanks, this was helpfule
Big Thanks !
thanks………
it was really help full to me
The solution was perfect and 100% assisted me in fixing the issue in excel 2007.
Thank you …So Much appreciated !!!
Praveen John
Thanks Praveen !!