Where is my Autofill Options button?

%3CLINGO-SUB%20id%3D%22lingo-sub-1515484%22%20slang%3D%22en-US%22%3EWhere%20is%20my%20Autofill%20Options%20button%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1515484%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%20I%20have%20called%20support%20and%20they%20lead%20me%20here.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20I%20write%20a%20formula%20in%20a%20cell%2C%20then%20I%20drag%20down%20to%20autofill%20the%20next%20couple%20of%20cells%2C%20when%20I%20release%2C%20I%20do%20not%20get%20the%20%22Autofill%20Options%22.%20What%20I%20am%20trying%20to%20do%20is%20fill%20without%20formatting.%20I%20instead%20get%20this%20option.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help!%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22IMG_20200710_132019.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F204688i9B15633D0CD9B874%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22IMG_20200710_132019.jpg%22%20alt%3D%22IMG_20200710_132019.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1515484%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1515493%22%20slang%3D%22de-DE%22%3ESubject%3A%20Where%20is%20my%20Autofill%20Options%20button%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1515493%22%20slang%3D%22de-DE%22%3EGo%20to%20File%2C%20Options%2C%20Advanced%2C%20Click%20on%20Fill%20Box%20and%20Activate%20Drag%20and%20Drop%20of%20Cells%2C%20Ok%20...%20and%20now%20you%20have%20it%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20enjoy%20Excel%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1515497%22%20slang%3D%22en-US%22%3EBetreff%3A%20Where%20is%20my%20Autofill%20Options%20button%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1515497%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3BThat%20is%20already%20enabled.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1515507%22%20slang%3D%22en-US%22%3EBetreff%3A%20Where%20is%20my%20Autofill%20Options%20button%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1515507%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3BI%20can%20autofill%2C%20that%20is%20working.%20It%20is%20when%20I%20am%20done%20dragging%2C%20the%20menu%20is%20different.%20How%20do%20I%20change%20the%20quick%20menu%20button%20to%20this%20referenced%20picture%3F%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22autofill-options2.png%22%20style%3D%22width%3A%20287px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F204691i1190E7FDA9B90E7C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22autofill-options2.png%22%20alt%3D%22autofill-options2.png%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1515510%22%20slang%3D%22de-DE%22%3ESubject%3A%20Where%20is%20my%20Autofill%20Options%20button%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1515510%22%20slang%3D%22de-DE%22%3EBelieve%20that%20can%20help%20you%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fwww.ablebits.com%2Foffice-addins-blog%2F2014%2F05%2F30%2Fhowto-use-autofill-excel%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.ablebits.com%2Foffice-addins-blog%2F2014%2F05%2F30%2Fhowto-use-autofill-excel%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1515530%22%20slang%3D%22en-US%22%3EBetreff%3A%20Where%20is%20my%20Autofill%20Options%20button%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1515530%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3BYOU%20ARE%20THE%20BEST!%20I%20figured%20it%20out!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFile%20%26gt%3B%20Options%20%26gt%3B%20Advanced%20%26gt%3B%20Under%20Cut%2C%20Copy%20and%20Paste%2C%20enable%20Show%20Paste%20Button%20Options%20when%20content%20is%20pasted.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!!%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1515973%22%20slang%3D%22en-US%22%3EBetreff%3A%20Where%20is%20my%20Autofill%20Options%20button%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1515973%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F725274%22%20target%3D%22_blank%22%3E%40conwayamyc%3C%2FA%3E%26nbsp%3B%2C%20I'm%20not%20sure%20how%20to%20enable%20that%20option%2C%20but%20you%20can%20get%20a%20similar%20set%20of%20options%20when%20you%20drag%20the%20mouse%20while%20holding%20the%20right%20mouse%20button%20instead%20of%20the%20left%20mouse%20button.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1516190%22%20slang%3D%22de-DE%22%3ESubject%3A%20Where%20is%20my%20Autofill%20Options%20button%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1516190%22%20slang%3D%22de-DE%22%3EThanks%20for%20the%20feedback%20...%20a%20like%20wouldn't%20hurt%20either%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Have%20a%20nice%20day%2C%20%3CBR%20%2F%3E%3CBR%20%2F%3E%20Nikolino%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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!IMG_20200710_132019.jpg

7 Replies
Highlighted
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
Highlighted

@Nikolino That is already enabled. 

Highlighted

@Nikolino 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?autofill-options2.png 

Highlighted
Highlighted

@Nikolino YOU ARE THE BEST! I figured it out!

 

File > Options > Advanced > Under Cut, Copy and Paste, enable Show Paste Button Options when content is pasted. 

 

Thank you!! 

 

Highlighted

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

Highlighted
Thanks for the feedback ... a like wouldn't hurt either

Have a nice day,

Nikolino