How to solve "drag to fill not working" or enable fill handle and cell drag & drop in excel
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
/ excel10tutorial
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
https://goo.gl/uL8fqQ
Here goes the most recent video of the channel:
https://www.tubebuddy.com/quicknav/la...
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: / excel10tutorial
Twitter: / excel10tutorial
Blogger: https://excel10tutorial.blogspot.com
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: https://hubpages.com/@excel10tutorial Become a member and enjoy exclusive perks while supporting the channel you love!
/ @excel10tutorial
Watch video How to solve "drag to fill not working" or enable fill handle and cell drag & drop in excel online without registration, duration hours minute second in high quality. This video was added by user Excel 10 tutorial 20 March 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 465,758 once and liked it 4.8 thousand people.