Forum Discussion
Where is my Autofill Options button?
Hi! I have called support and they lead me here.
After I write a formula in a cell, then I drag down to autofill the next couple of cells, when I release, I do not get the "Autofill Options". What I am trying to do is fill without formatting. I instead get this option.
Please help!
11 Replies
- Go to File, Options, Advanced, Click on Fill Box and Activate Drag and Drop of Cells, Ok ... and now you have it 🙂
enjoy Excel 🙂
Nikolino- don't worry i gave you a like because it did really help
- lol...It was just a joke with the like, you need to give me or anyone here something.
I and most of the others here, give without embarrassing anything.
The best thing to do is to pass on what you have learned without embarrassing anything .
.. this will keep happiness in the chain 🙂
Enjay your Office
Nikolino
NikolinoDE I can autofill, that is working. It is when I am done dragging, the menu is different. How do I change the quick menu button to this referenced picture?
conwayamyc , I'm not sure how to enable that option, but you can get a similar set of options when you drag the mouse while holding the right mouse button instead of the left mouse button.
NikolinoDE That is already enabled.
- Believe that can help you
https://www.ablebits.com/office-addins-blog/2014/05/30/howto-use-autofill-excel/
