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.
Our Blog: www.pickupbrai...
You can also visit our website for more exciting Ms Word and Excel Tips and Tricks: www.pickupbrai...

[@jonathanglockler4483]

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.

[@pickupbrain]

😊Thanks dear for the complement and taking effort to comment from personal phone.

[@ChrisKeta-tl6pn]

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

[@pickupbrain]

Glad to know it was helpful.

[@MJ-fm3jq]

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

[@pickupbrain]

Welcome dear 😊

[@tyagi.sachin1777]

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.

[@pickupbrain]

Most welcome 😊 Glad to know it was helpful.

[@pjdavo]

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

[@pickupbrain]

Welcome dear ☺️. Glad to know it helped.

[@Larissa-n2k]

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

[@pickupbrain]

You're welcome!

[@Mohammad_Ruhuul_Amin]

Thank you very much for choose a very helpful content for sharing..

[@pickupbrain]

Welcome dear 😊

[@meethunghosh1892]

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

[@irenapavlinska1570]

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.

[@Musicofrustlingleaves]

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

[@pickupbrain]

You are welcome!

[@GusiPhone-Gvoice]

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

[@Mohammad_Ruhuul_Amin]

Thank you very much for choose a very helpful content for sharing..

[@pickupbrain]

Glad it was helpful! ☺️

[@vladmirffxi]

Thank you!!!

[@pickupbrain]

You're welcome!

[@JenaSasmita-i5u]

Thank you soo muchh

[@pickupbrain]

Welcome dear 😊

[@canirmalayugandhar7333]

Much useful. Thank you

[@pickupbrain]

Glad to know that.

[@waibazcomputer8532]

THANKS A LOTS BUDDY

[@pickupbrain]

Welcome 😊. Thanks for the comment.

[@jeviesabejon9403]

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

[@ikos_hederal]

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

[@pickupbrain]

Welcome dear ☺️. I always wait for your comment and feedback. I made some video on ppt as per your request. However it is in que for publication.

[@ikos_hederal]

@@pickupbrain my honour 😍😍okiessss. God bless you 🖤

[@iam.subhasissardar]

Thank you so much 😊

[@pickupbrain]

Welcome dear.

[@meshackechoto8936]

Thanks

[@pickupbrain]

Welcome 😊

[@vijayg8115]

Thanks man

[@pickupbrain]

Welcome dear.

[@aamrak69]

Everything has checked but it does not work for me

[@pickupbrain]

Really sorry to hear that.

[@kotlavenkat]

thank u

[@pickupbrain]

You're welcome!

[@sriramraksha9789]

Thanks alot

[@pickupbrain]

Most welcome

[@felleepops]

Thank you

[@pickupbrain]

Welcome!

[@Deyeafr]

Thankyou

[@pickupbrain]

You’re welcome 😊

[@SaurabhKumar-i1b9k]

Thanks

[@pickupbrain]

Welcome

[@anujgupta147]

Thanks

[@pickupbrain]

Welcome 😊

[@sonimatrisal5359]

Thanks

[@pickupbrain]

Welcome

[@pvpundkar]

Thanks

[@pickupbrain]

Welcome

[@tommyharris5817]

Cheers mate

[@pickupbrain]

🥂

[@zeeshanshaikh3662]

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

[@chippantzev]

me also cant use double clicking. can i know how to do this??

[@sanvikastudio3151]

Tq

[@pickupbrain]

Welcome dear 😊

[@Thirusrinivas987]

👍

[@pickupbrain]

😊