Excel 2016 Series fill not properly working

%3CLINGO-SUB%20id%3D%22lingo-sub-178885%22%20slang%3D%22en-US%22%3EExcel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-178885%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%2C%20in%20excel%202016%20when%20i%20try%20autofill%20in%20series%20the%20two%20numbers%20i%20enter%20to%20create%20a%20pattern%20keeps%20repeating.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-178885%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285346%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285346%22%20slang%3D%22en-US%22%3E%3CP%3ENice!%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285213%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285213%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Jan%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAlphabetical%20is%20not%20the%20default%20list%20for%20Fill%20Series%2C%20you%20need%20to%20add%20it%20first%20at%20File-%26gt%3BOptions-%26gt%3BAdvanced-%26gt%3BGeneral.%20See%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fexcelribbon.tips.net%2FT007803_AutoFilling_with_the_Alphabet%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexcelribbon.tips.net%2FT007803_AutoFilling_with_the_Alphabet%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-285154%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-285154%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20the%20same%20problem%20with%20Office%202016.%20Whatever%20letters%20I%20put%20in%20keep%20repeating.%20Fill%20Series%20does%20not%20appear%20as%20a%20choice%20on%20my%20dropdown%20menu.%20See%20picture.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-183054%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-183054%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Bashir%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfter%20you%20drag%20down%20check%2Fchange%20autofill%20option%20expanding%20the%20icon%20at%20right%20bottom%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20272px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F32292i7B04908FF37E4AE9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Ffill-data-automatically-in-worksheet-cells-74e31bdd-d993-45da-aa82-35a236c5b5db%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Ffill-data-automatically-in-worksheet-cells-74e31bdd-d993-45da-aa82-35a236c5b5db%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-178928%22%20slang%3D%22en-US%22%3ERE%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-178928%22%20slang%3D%22en-US%22%3Eyes%20i%20tried%20holding%20down%20ctrl%20and%20still%20the%20same%20issue%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-178920%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-178920%22%20slang%3D%22en-US%22%3E%3CP%3EHave%20you%20tried%20holding%20down%20ctrl%20when%20dragging%20the%20fill%20handle%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1137047%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1137047%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20I%20have%20a%20similar%20problem%20just%20in%20my%20case%20the%20selection%20of%20prefill%20options%20is%20not%20even%20there.%20It%20always%20used%20to%20work%20but%20suddenly%20a%20couple%20of%20days%20ago%20ist%20started%20showing%20the%20quick%20data%20analysis%20instead.%20See%20attached%20screenshots.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167879i0D2512E38AA22767%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThis%20is%20what%20happens%20when%20I%20drag%20the%20corner%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167880i1D4AF5A3AF92090E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_1.png%22%20title%3D%22clipboard_image_1.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EAnd%20these%20are%20then%20my%20options%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F167881iCB3C0CD69BE631D0%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_2.png%22%20title%3D%22clipboard_image_2.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20had%20any%20idea%20how%20to%20fix%20it%20it%20would%20be%20greatly%20appreciated..%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1154772%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1154772%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Solved.PNG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F169330iD3DF9C0415481FD8%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Solved.PNG%22%20alt%3D%22Solved.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83Make%20sure%20these%20options%20were%20selected%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1271570%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1271570%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F546998%22%20target%3D%22_blank%22%3E%40Vu_Tran%3C%2FA%3E%26nbsp%3BI%20have%20this%20same%20problem%20with%20Excel%20365.%26nbsp%3B%20The%20answer%20did%20not%20solve%20my%20issue.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1271613%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1271613%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20case%20you%20need%20to%20get%20Excel%20AutoFill%20not%20working%2C%20you%20can%20switch%20it%20off%20by%20doing%20the%20following%3A%3CBR%20%2F%3EClick%20on%20File%20in%20Excel%202010-2013%20or%20on%20the%20Office%20button%20in%20version%202007.%3CBR%20%2F%3EGo%20to%20Options%20-%26gt%3B%20Advanced%20and%20untick%20the%20checkbox%20Enable%20fill%20handle%20and%20cell%20drag-and-drop.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1275851%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1275851%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F546998%22%20target%3D%22_blank%22%3E%40Vu_Tran%3C%2FA%3E%26nbsp%3BThanks%20for%20the%20advice.%20It%20was%20all%20correct%20in%20the%20settings%20but%20eventually%20I%20found%20out%20that%20the%20different%20pre-fill%20options%20are%20not%20available%20when%20one%20uses%20filters%20(when%20some%20of%20the%20rows%20are%20hidden).%20So%20I%20guess%20it%20had%20nothing%20to%20do%20with%20the%20settings%2C%20just%20the%20fact%20that%20this%20is%20for%20some%20reason%20not%20possible%20with%20filters%20on..%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1434791%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1434791%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F537105%22%20target%3D%22_blank%22%3E%40adaso16%3C%2FA%3E%20for%20your%20comment.%20You%20saved%20me%20a%20lot%20of%20time%20searching%20for%20a%20solution.%20It%20sure%20would%20be%20nice%20if%20Microsoft%20would%20add%20this%20%22exception%22%20to%20the%20fill%20handle%20instructions%20in%20their%20support.microsoft.com%20website.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1437533%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1437533%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20are%20most%20welcome%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F687125%22%20target%3D%22_blank%22%3E%40balboamom%3C%2FA%3E%26nbsp%3B%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3EI%20completely%20agree%2C%20it%20would%20have%20saved%20me%20a%20lot%20of%20trouble%20and%20time%20too%20had%20that%20been%20the%20case...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1452197%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1452197%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F537105%22%20target%3D%22_blank%22%3E%40adaso16%3C%2FA%3E%26nbsp%3B%20After%20about%20a%20hour%20of%20trying%20different%20solution%2C%20your%20answer%20was%20spot%20on%20for%20me.%26nbsp%3B%20Thanks%20so%20much%20for%20putting%20it%20out%20there.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1511464%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1511464%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F537105%22%20target%3D%22_blank%22%3E%40adaso16%3C%2FA%3EThanks%20for%20your%20suggestion%20because%20I%20was%20facing%20same%20problem%20but%20when%20i%20switched%20Filter%20then%20it%20works%20normally.%20Thank%20you%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1521131%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1521131%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3BHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3BI%20have%20and%20issue%20but%20with%20the%20numbers%20with%20autofill.%20Say%20I%20type%205%2C%20followed%20by%2010.If%20I%20select%205%20and%20then%2010(with%20control%20button%20pressed%20)%20then%20I%20am%20supposed%20to%20get%20a%20black%20plus%20sign%20on%20bottom%20right%20corner%20%2C%20which%20I%20am%20not.%20No%20filters%20are%20active%20in%20this%20case.%26nbsp%3B%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1521180%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1521180%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F728212%22%20target%3D%22_blank%22%3E%40sujit36%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYes%2C%20selecting%20them%20you%20have%20only%20Quick%20Analysis%20button.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20127px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F205191iF26FCD8448A702DA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EBut%20after%20you%20drag%20selection%20down%20you%20shall%20see%20black%20%22plus%22%20(not%20visible%20on%20screenshot)%20and%20autofill%20icon%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20111px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F205192i5F2FA9B836A61E3A%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EIs%20that%20something%20different%20in%20your%20case%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1521183%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1521183%22%20slang%3D%22en-US%22%3E%3CP%3E-ERR%3AREF-NOT-FOUND-%40Sergei%20Baklan%2C%3C%2FP%3E%3CP%3EI%20am%20not%20getting%20the%20Quick%20analysis%20button%2Cinstead%20a%20white%20cross%20shows%20upon%20the%20bottom%20right%20corner%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1521809%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1521809%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F728212%22%20target%3D%22_blank%22%3E%40sujit36%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAfter%20you%20drag%20down%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1522539%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1522539%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%20Yes%20sir%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1521355%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1521355%22%20slang%3D%22en-US%22%3E%3CP%3ESorry%20%2C%20I%20am%20getting%20neither%20the%20white%20cross%20or%20the%20dark%20plussign%2C%20just%20the%20quick%20analysis%20button.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1541205%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Excel%202016%20Series%20fill%20not%20properly%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1541205%22%20slang%3D%22en-US%22%3EThank%20you!%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

hi, in excel 2016 when i try autofill in series the two numbers i enter to create a pattern keeps repeating.

 

22 Replies
Highlighted

Have you tried holding down ctrl when dragging the fill handle?

Highlighted
yes i tried holding down ctrl and still the same issue
Highlighted

Hi Bashir,

 

After you drag down check/change autofill option expanding the icon at right bottom

image.png

https://support.office.com/en-us/article/fill-data-automatically-in-worksheet-cells-74e31bdd-d993-45...

 

 

Highlighted

I have the same problem with Office 2016. Whatever letters I put in keep repeating. Fill Series does not appear as a choice on my dropdown menu. See picture.

Highlighted

Hi Jan,

 

Alphabetical is not the default list for Fill Series, you need to add it first at File->Options->Advanced->General. See https://excelribbon.tips.net/T007803_AutoFilling_with_the_Alphabet

Highlighted

Nice! Thanks.

Highlighted

@Sergei Baklan 

 

Hi, I have a similar problem just in my case the selection of prefill options is not even there. It always used to work but suddenly a couple of days ago ist started showing the quick data analysis instead. See attached screenshots.

clipboard_image_0.png

This is what happens when I drag the corner:

clipboard_image_1.png

And these are then my options:

clipboard_image_2.png

 

If you had any idea how to fix it it would be greatly appreciated..

Highlighted

Solved.PNG

 Make sure these options were selected

Highlighted

@Vu_Tran I have this same problem with Excel 365.  The answer did not solve my issue.

Highlighted

In case you need to get Excel AutoFill not working, you can switch it off by doing the following:
Click on File in Excel 2010-2013 or on the Office button in version 2007.
Go to Options -> Advanced and untick the checkbox Enable fill handle and cell drag-and-drop.

Highlighted

@Vu_Tran Thanks for the advice. It was all correct in the settings but eventually I found out that the different pre-fill options are not available when one uses filters (when some of the rows are hidden). So I guess it had nothing to do with the settings, just the fact that this is for some reason not possible with filters on..

Highlighted

Thank you@adaso16 for your comment. You saved me a lot of time searching for a solution. It sure would be nice if Microsoft would add this "exception" to the fill handle instructions in their support.microsoft.com website.

Highlighted

You are most welcome @balboamom 

I completely agree, it would have saved me a lot of trouble and time too had that been the case...

Highlighted

@adaso16  After about a hour of trying different solution, your answer was spot on for me.  Thanks so much for putting it out there. 

Highlighted

@adaso16Thanks for your suggestion because I was facing same problem but when i switched Filter then it works normally. Thank you

Highlighted

 Hello @Sergei Baklan,

 I have and issue but with the numbers with autofill. Say I type 5, followed by 10.If I select 5 and then 10(with control button pressed ) then I am supposed to get a black plus sign on bottom right corner , which I am not. No filters are active in this case.    

Highlighted

@sujit36 

Yes, selecting them you have only Quick Analysis button.

image.png

But after you drag selection down you shall see black "plus" (not visible on screenshot) and autofill icon

image.png

Is that something different in your case?

Highlighted

@Sergei Baklan,

I am not getting the Quick analysis button,instead a white cross shows upon the bottom right corner 

Highlighted

Sorry , I am getting neither the white cross or the dark plussign, just the quick analysis button.