It’s a favorite feature of every Excel user. Simply select a series of cells with incremental values and drag the cell corner down to complete the rest of the series. Most common usage scenario is when people try to complete the serial # column.
This feature is turned on by default but for some reason disappeared from my system. It took few days for me to figure out where the toggle button is. Let me share it for the benefit of my blog readers.
In Excel 2010
- Click on File on top left corner
- Click Options again on the left hand side (above the Exit ) button
- It brings up the Excel Options dialog box and select the Advanced section on left.
- The relevant settings are highlighted in the image below
Useful post . Thanks for sharing this .
I was updating the predictability matrix and for some unknown reason, autoincrement/ auto fill got disabled. I had thousands of rows to update and it was impossible to do it manually. This post helped my enabled the auto fill mode.
Thanks a million !
Amey
Tks broo… realy helpful
It helped me lot, thanks for detailed information.
-Lakshman
Really good. Thanks so much
Thank for giving the help.
It’s a good idea.
Thanks for your solution.
It was very helpful. Thank you again.. 🙂
did you ever find out how it was turned off in the first place? I had the same thing happen, but I know I didn’t turn it off.
@JK> I have no idea how it got turned off.
Thanks it worked.
But the option is available in the tools menu and not the File menu
@ttttttt I’m using Excel 2010 and there is no Tools menu
Thanks man.
Thanks Buddy I was searching for this info from a long time. How did it turned off. I don’t know
Simple and excellent post…….Its working….:)
thanks man…mine had disappeared suddenly
i was breaking my head to figure out why this feature work on other machines and not mine. Finally got it today from your post ! Good stuff.. Keep sharing !
excellent buddy…wasted a lot of time figuring this…now works…
This problem was driving me mad!
Thanks a ton for the solution!
Thanks a lot. It works in Excel 2007 also. 🙂
I am unable to drag formula in Excel 2003 as cursor does not does not appear
Awesome..tks a lot for sharing the info 🙂
wow, its very good better to remember
ITS GOOOD… its excel options button in excel 2003 at last of recent document..
NICE POST
thanks, it helped me finish my report in time! any idea how it turned off in the first place?
Very useful , it helped me at the right time..
Thank you . I was struggling to find this out…
thank u buddy. useful in 2007 too.
Thanks
Thanks for this
Thank you so much !!!!!!! 🙂
Thanks, helped a lot when this feature was disabled in my system! 🙂 But I am wondering whether it got disabled when I played with Macros settings when filling my IT returns..! 😮
i think you are right. this problem started happening to me exactly since i filed my IT return. that xls was having macros.. that may be the issue.
thanks a lots…….i was becoming mad in manually entering the value..
Thank you very much man.. I was unaware of this option.
Thanx pal, saved me a lot of tension. I was about to reload the touchpad driver but you have spared me the trouble.
wow… u r grate.
Thanks a lot. It saved my time.
Thanks a Bunch Buddy
Thanks….
Thanks a lot dear, Also works in Excel 2007
I was using it extensivly but suddenly one day, I can’t drag column.
Thanks for sharing this post, Now i can do it .
Not sure how it got turned off in my machine… Got it back, thanks to this article!
Glad to have found it!
Thanks … this was quick !!!
excellent buddy…turning off was very iritatting.. not seems to be perfectly fine
Thanks for sharing – a real useful tip.
Debasish
Thanks a lot it really helps…
Helped tons! Thanks for saving me from headache since a week…
Thanks for the post. It was really helpful.
Thanks!!! Though a simple step but very important n useful…
Thanks for this post… It really helped..
It works. Thanks
Very useful… Thanks!
Thanks for the post…. very useful
Thanks a ton.
Thankx
many thanks for this small thing but very useful function, Cheers
Thank you, It worked for me
thanks Buddy…and I thought this feature was not available in 2010….really helpful..dont really know why was it turned off…
click on MS Office Butten left side upper circle, excel option>Advanced> enable fill handle and cell drag
Thank you for this post. Very useful.
thanks for ur help
Thank you. I was struggling for a while.
Thanks! got it done.
Cool! got nice work pal !
Thanks it works
Thanks a lot….I was releived to find this info 🙂
thanks it’s really usefull
thanx boss!
It works. Thanks for the post
Thanks for Post, Its work ! Keep it up
Afterr dis setting also it not working it ia nt ahowing the increment value while dragging.
thank you very much
Thanks you
yeah!! Ravi,
really this blog is help full ….
thanks.
Thanks a lot mate
thanks dude …….
thanks a lot
Thanks alot god bless you..
Thanks bro!
Thanks a Lot!!!
THANKS MAN, FOR THIS USEFUL TIP
Thanks !!! really great !!! unable to solve this since a long !!!
Extremely useful post!
Thanks for quick help
Thank you…
Thanks a lot
Very Useful…Thanks a ton…
That helped. Thanks buddy.
Thanks
Thanks
Thank you so much for sharing the solution.
Thanks dear,
This was very helpful and I was able get the drag optiob back which which very important for excel dependent work
Thanks Worked!!!!!!!!!!!
Thanks a lot , it solved my problem
Thanks it works now 🙂
Awesome!!!
Really helpful
Very helpful, thanks.
Just a note – if the Auto filter is on, Excel 2010 (sometimes) still won’t let you auto-increment by dragging. Turn filter off then drag to increment.
Thanks buddy:) It helps me lot
Thank you
Hi, Tnx for the Post, it helped me a lot….
Thanks so much, I just to have it but it disappeared, it was diving me CRAZY!!!!
woww simply gr88
woww simply gr88
Thanks very much saved lot of time
It works on 2007. thanks you saved my time.
Thank you so much.. It turns off by itself, now I know how to undo it.
Thanks a Lot mate:-)
Thank you very much dude. It helped a lot.
Not useful for me. Just in one sheet, it doesn’t work (anymore). So this option was not even turned off, but as a test, turning it off and on again… it still does not work. In the other sheets… it works fine.
Thanks from PPC(PROGRAMMING) group.
I can say only one thing that most help full
Thanks sooooooo much
very helpful..thanks.
Thank you, it helped me a lot…
Thanks buddy, you really saved me a lot of searching time! I successfully restored the drag option!
Just some additional information. I use MS Office Excel 2003 and this option is available under TOOLS > OPTIONS > Edit (tab)!
Maybe you can update this in your blog. Cheers and Thanks again!!
Thought i was the only one having this problem. It works now. Thank you
Thanks a lot Ravi, I was looking for this info for ages
Thanks dear
Useful post thank you
Issue resolve. Thank you for this useful post.
very useful. Thanks!
Thanks Ravi
got solution !!!
Thanks. Works Well
very usefull input , thanks for sharing , save my day in Excel
Struggled with this during the whole of mba 1st year. never googled. repasted every time. ther eis a day for everything!
thanks a ton
Am using excel 2007 how to do for that?
thanks..
Thanks
Well, it was working all morning, until 30 minutes ago, then it simply stopped working. I think it has something to do with the format of the item in the cell (mine is ### A). Now it simply copies the cells (ie. 1a 2a 3a 1a 2a 3a 1a 2a 3a etc. instead of 1a 2a 3a 4a 5a 6a 7a 8a 9a etc.)
thanks
Excellent stuff… Thanks man…
thanks bro, this info really helped me
Thanks a ton… 🙂
thank you a lot
many thanks dude!
Very helpful… Thanks Ravi..
Thank you.
After enabling macros for another workbook I realized that my drag-fill setting was toggled off. I think Excel has a bug where a developer forgot to retain this setting after enabling macros.
Thank you very much
Actually I prepared to format my laptop for this option only. Really It helped me a lot.
Hi, I have the options checked as shown, but I still cannot use the auto complete function, I can see the + at the corner.
Thank you very much for the post. It helped me a lot when urgently required.
I confirm that the option is disabled as soon as you open the ITR excel utility. Try it yourself 🙂
ITR Excel Utility has a disableCut Macro which turns this setting off.
thanks…… its a useful tip..
Very useful post. thanks for sharing it.
Thanks you so much for your this post. It saved lot of trouble for me.
Thanks allllllot boss i have been suffering from fever as i lost this option. you made me soooo happy with your tip
Thanks Dude . You made my day!!!…
Thank you so much dude.. it worked.. 🙂
thanks dude, its working fine
Thanks a lot.. I was struggling to find this option..
Thnx
thank you friend ,solve my problem
thanks
Thanks a Lot, it really helped me to fix my issue.
Thanks for given solution .. lots of time spend but now working
It worked thanks.
thank .. anup
Really helpful. thanks a lot
Thanks a lot.
Thank you very much. You saved a lot of time for us. we were striking our head how it got disabled 😉
thank you
Hi thanks. This was awesome. Was suffering for a few weeks and this helped sort it out in a few seconds.
Thank you very much. This was a very quick help.
How this got turned off is not known
Thanks for sharing the Function.
Thanks alot!
thanks a lot..
Thanks a lot😊
Thanks a lot
Thank you very much
Thanks a lot Bro.. God Bless you.. 🙂
Thanks sir, great help.
It really helped me a lot. Thanks a ton
thanks a lot ravi… it helped me…. 🙂 8008166118
Thanks for the assistance
Thanks it works
Thanks.
thanks. it worked
Thank you..at least i can get back to work now..
Thanks a lot. It really helped
Nice Information.
Thanks 🙂
Dude! you’re the man, this situation was driving me crazy! thanks a lot!
That’s simply superb, Made my day! Thanks a Ton Ravi Sankar!
Thank you loads. I was wondering what went wrong suddenly. Thank you again.
Amazing! Thank you!
Nice…!!! But wondering without changing any options. How possible automatically my cells behaves like this. Anyways found error. Thank you for guide. Really working now after changing the options.
THANK YOU VERY MUCH. THIS WAS OF GREAT HELP
Thanks!
thaaaanx a lof,, help me a lot 🙂
Thank you so much! its really helpful mostly in work.
God bless!
great works thanks,
Useful post. Thanks.
thanks a lot.
Thanks really help full, It worked…
Man thanks, worked at once !
very good post, thanks for sharing, i was facing this problem since a day, but solved within a minute with the help of your post. Thanks again.
Thanks buddy for this post!! Helped me out.
Thanks! this helped me with the issue I was facing around.
Thank You so much it was so simple
THANKS A LOT FRIEND
Simple and excellent post…….Its working….:)
Thanks. Really helping me to resolve my problem
thanks it works.
Thanks
Thnx man
Thank you…. that was so helpful.
It helped today.Thanx for the write-up.
it helped me a lot Thanks
Thanks it really helped me
Thanks
Thanks…. very helpful.
Thanks for article.
Thank you so much
Thanks you Ravi
Thank you so much
Thank ypu
7.5 years later, you’re still helping us noobs figure this out… option randomly disabled it self and I had no idea this was even an option to turn on/off.
fixed, thanks!
Thanks a lot. Its really helpful.
Thanks
Thanks… Simple fix.. Not sure how that check box got unchecked..
Thank you – just suddently wouldn’t work. you saved me.
Thank You Sir! much frustration alleviated! 🙂
Thanks for the tip, which is working now!