SOLVED

autofill doesn't work

%3CLINGO-SUB%20id%3D%22lingo-sub-3002142%22%20slang%3D%22en-US%22%3Eautofill%20doesn't%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3002142%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20a%20problem%20with%20the%20autofill%2C%20instead%20of%20filling%20the%20boxes%2C%20g7%2C%20h7%2C%20i7%2C%20j7%2C%20k7%20with%20the%20months%20February%2C%20March%2C%20April%20May%2C%20June%2C%20the%20boxes%20are%20filled%20only%20with%20January.%20How%20can%20I%20solve%20the%20problem%3F%20See%20screenshoot.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22c1.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F329187iF14CD524B3E24988%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22c1.PNG%22%20alt%3D%22c1.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3002142%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3003366%22%20slang%3D%22en-US%22%3ERe%3A%20autofill%20doesn't%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3003366%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1228382%22%20target%3D%22_blank%22%3E%40Bn_Rg%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethat's%20very%20easy.%20Just%20fill%20in%20a%20second%20value%2C%20in%20this%20case%20february%2C%20mark%20both%20and%20then%20try%20to%20autocomplete.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3CBR%20%2F%3ESchnittlauch%3C%2FP%3E%3CP%3E%22First%2C%20No%20system%20is%20safe.%20Second%2C%20Aim%20for%20the%20impossible.%20Third%2C%20no%20Backup%2C%20no%20Mercy%22%20-%20Schnittlauch%3C%2FP%3E%3CP%3EMy%20answer%20helped%20you%3F%20Don't%20forget%20to%20leave%20a%20like.%20Also%20mark%20the%20answer%20as%20solved%20when%20your%20problem%20is%20solved.%20%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%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi, I have a problem with the autofill, instead of filling the boxes, g7, h7, i7, j7, k7 with the months February, March, April May, June, the boxes are filled only with January. How can I solve the problem? See screenshoot.

c1.PNG

3 Replies

Hi @Bn_Rg,

 

that's very easy. Just fill in a second value, in this case february, mark both and then try to autocomplete.

 

Best regards,
Schnittlauch

"First, No system is safe. Second, Aim for the impossible. Third, no Backup, no Mercy" - Schnittlauch

My answer helped you? Don't forget to leave a like. Also mark the answer as solved when your problem is solved.

best response confirmed by Bn_Rg (Occasional Contributor)
Solution

@Schnittlauch 

Hi garlic,

 

On an English language version of Excel, the names of the months (and of the days of the week) should autofill automatically. Those lists are built in and cannot be deleted:

S0930.png

If starting with January doesn't autofill, I doubt that starting with January, February will work.

Perhaps Office needs to be repaired...

thank you, i fix the problem.