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
Смотрите видео How to solve "drag to fill not working" or enable fill handle and cell drag & drop in excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Excel 10 tutorial 20 Март 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 465,758 раз и оно понравилось 4.8 тысяч людям.