How to enable drag option in Excel | Solved Fill Handle not showing [2022]

Fill handle feature of Excel provides an easy way for applying a formula of current cell to other cells just by dragging. However, because of some reason, this fill handle doesn't show up. The following steps will help you bring back the fill handle in Excel.

Steps to Enable Fill Handle and Drag and Drop functionality in Excel

1. Go to Files → Options
2. In "Advance" Category, under "Editing Options", check box against "Enable fill handle and cell drag-and-drop" and click ok.

[ChrisKeta-tlpn]

My friend you are a savior, i had to reinstall office thinking it had an issue

[jonathanglockler]

This was great and solved my problem. I am not signed into youtube on my corporate machine, so it would not let me "like" the video and comment. Doing this from my personal phone. Thanks for the great tutorial.

[MJ-fmjq]

Much appreciated for the quick way around. At times, you somehow forget the very basics. Thanks again!

[tyagi.sachin]

Thank you so much dear for quick help. I was struggling with this since long. Thought some issue is in my laptop only. As soon as I search this, 1st video came up and solved my issues. Thanks again. You made my day.

[pjdavo]

YES!!! I've been struggling with this for days! Thanks so much!

[jcjrghb]

saved my life, thanks so much for the quick explanation!

[Musicofrustlingleaves]

Thanks a lot. In the last four years, I haven't had this option on my PC.

[meethunghosh]

*Hi is their any option of dragging excel cell to left and upwards, similar to dragging excel cell down or to right, Many Thanks*

[nhelqpe]

Cool - To bad it drags the formatting with it - Like highlighting and borders for example

[irenapavlinska]

Thank you for this video, unfortunately, it didn´t help in my case. I have Autofilll options available but there is no Fill series option within them. And that is the one I would need to use.

[aamrak]

Everything has checked but it does not work for me

[ikos_hederal]

Got it sir 👍 it's really helpful..😃

[jeviesabejon]

How about in Cellphones? is there a way to do that as well?

[zeeshanshaikh]

When i am dragging it works fine but when i am double clicking its not working plz give me solution