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.

[@MJ-fm3jq]

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

[@pickupbrain]

Welcome dear 😊

[@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.

[@Mohammad_Ruhuul_Amin]

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

[@pickupbrain]

Welcome dear 😊

[@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!

[@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.

[@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*

[@Musicofrustlingleaves]

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

[@pickupbrain]

You are welcome!

[@vladmirffxi]

Thank you!!!

[@pickupbrain]

You're welcome!

[@user-fn7zt4fu2l]

Thank you soo muchh

[@pickupbrain]

Welcome dear 😊

[@waibazcomputer8532]

THANKS A LOTS BUDDY

[@pickupbrain]

Welcome 😊. Thanks for the comment.

[@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.

[@sriramraksha9789]

Thanks alot

[@pickupbrain]

Most welcome

[@GusiPhone-Gvoice]

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

[@canirmalayugandhar7333]

Much useful. Thank you

[@pickupbrain]

Glad to know that.

[@meshackechoto8936]

Thanks

[@pickupbrain]

Welcome 😊

[@iam.subhasissardar]

Thank you so much 😊

[@pickupbrain]

Welcome dear.

[@kotlavenkat]

thank u

[@pickupbrain]

You're welcome!

[@vijayg8115]

Thanks man

[@pickupbrain]

Welcome dear.

[@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 🖤

[@jeviesabejon9403]

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

[@felleepops]

Thank you

[@pickupbrain]

Welcome!

[@aamrak69]

Everything has checked but it does not work for me

[@pickupbrain]

Really sorry to hear that.

[@tommyharris5817]

Cheers mate

[@pickupbrain]

🥂

[@sanvikastudio3151]

Tq

[@pickupbrain]

Welcome dear 😊

[@Thirusrinivas987]

👍

[@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??

[@Mohammad_Ruhuul_Amin]

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

[@pickupbrain]

Glad it was helpful! ☺️

[@SaurabhKumar-i1b9k]

Thanks

[@Deyeafr]

Thankyou

[@pickupbrain]

You’re welcome 😊

[@anujgupta147]

Thanks

[@pickupbrain]

Welcome 😊

[@sonimatrisal5359]

Thanks

[@pickupbrain]

Welcome

[@pvpundkar]

Thanks

[@pickupbrain]

Welcome