How to solve /”drag to fill not working/” or enable fill handle and cell drag & drop in excel?
In this excel tutorial for beginners I am about to solve drag to fill not working issue in excel. There are times we need to auto-fill formula to a column but we can’t find the fill handle if we hover at the corner of a cell. In this tutorial we are about to resolve excel fill handle not working issue.
To solve fill series not working in excel you need to check two things in excel. First one is the Calculation Options if you are using formulas and need the fill handle. The second one is the place where you can enable fill handle and cell drag & drop in excel.
So, lets solve the first one; excel drag formula not working.
Step 1: Click on the “Formula Tab”
Step 2: Click on “Calculation Option”
Step 3: Select “Automatic”
If you already enable fill handle and cell drag & drop but still excel auto-fill option is not showing then this would resolve the problem. If the series fill not properly working then you should follow below procedure also.
Enable fill handle and cell drag & drop in excel
Step 1: Click on the “File” Menu
Step 2: Click on “Options”
Step 3: Click on “Advanced”
Step 4: Check-mark on or “Enable fill handle and cell drag & drop”
Done. Now your fill handle not working in excel problem should be solved.
From now on you can auto fill formulas, numbers, text and everything excel supports.
This is the best solution for Excel auto-fill drag not working issue.
#FillHandle #Enable
Thanks for watching.
————————————————————————————————————-
Support the channel with as low as $5
https://www.patreon.com/excel10tutorial
————————————————————————————————————-
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ

Here goes the most recent video of the channel:
https://www.tubebuddy.com/quicknav/latest/UCvYWtCPVbIDYLyNqB4lRIaw

Playlists:
Advance Excel Tutorial: https://goo.gl/ExYy7v
Excel Tutorial for Beginners: https://goo.gl/UDrDcA
Excel Case: https://goo.gl/xiP3tv
Combine Workbook & Worksheets: https://bit.ly/2Tpf7DB
Excel VBA Programming Course: http://bit.ly/excelvbacourse

Social media:
Facebook: https://facebook.com/excel10tutorial
Twitter: https://twitter.com/excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: https://excel10tutorial.tumblr.com
Instagram: https://www.instagram.com/excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial *Become a member and enjoy exclusive perks while supporting the channel you love!*
https://www.youtube.com/@Excel10tutorial/join

Please take the opportunity to connect and share this video with your friends and family if you find it useful.