Home

Autofill "Weekdays etc" not working (not in English)

%3CLINGO-SUB%20id%3D%22lingo-sub-787382%22%20slang%3D%22en-US%22%3EAutofill%20%22Weekdays%20etc%22%20not%20working%20(not%20in%20English)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787382%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20using%20US%20English%20as%20a%20default%20language%20in%20Office%20365%20and%20Windows%2010.%20However%2C%20keyboard%20input%2C%20date%20and%20time%20is%20Swedish.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere's%20some%20kind%20of%20conflict%20because%20I%20can't%20autofill%20English%20words%20such%20as%20%22Weekdays%22%20etc.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20tried%20to%20put%20everything%20in%20English%20'everywhere'.%20Any%20ideas%2C%20friends%3F%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-787382%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-787401%22%20slang%3D%22en-US%22%3ERe%3A%20Autofill%20%22Weekdays%20etc%22%20not%20working%20(not%20in%20English)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787401%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F387021%22%20target%3D%22_blank%22%3E%40aldrigoffice%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20source%20of%20the%20weekday's%20autofill%20feature%20is%20this%20window%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20764px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125540i75B9A49EC34EDED9%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Custom%20Lists.png%22%20title%3D%22Custom%20Lists.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20find%20it%2C%20go%20to%20Options%20%26gt%3B%26gt%3B%20Advanced%20%26gt%3B%26gt%3B%20General%20%26gt%3B%26gt%3B%20Edit%20Custom%20Lists%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20check%20it%20out%20and%20see%20how%20it%20looks%20like.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-787399%22%20slang%3D%22en-US%22%3ERe%3A%20Autofill%20%22Weekdays%20etc%22%20not%20working%20(not%20in%20English)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-787399%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F387021%22%20target%3D%22_blank%22%3E%40aldrigoffice%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%3C%2FP%3E%3CP%3EDate%20format%20and%20settings%20are%20controlled%20by%20the%20central%20settings%20of%20the%20Windows%20Operating%20System%3A%3C%2FP%3E%3CP%3EStart%20button%20(Windows%20Button)%20%26gt%3B%26gt%3B%20Settings%20Gear%20%26gt%3B%26gt%3BTime%20and%20Language%20%26gt%3B%26gt%3B%20Date%20%2C%20Time%20%26amp%3B%20Regional%20Formatting%20%26gt%3B%26gt%3B%20You%20make%20changes%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eon%20the%20Other%20hand%20%2C%20AutoFill%20Options%20are%20controlled%20by%20the%20%22%3CSTRONG%3ECustom%20Lists%3C%2FSTRONG%3E%22.%3C%2FP%3E%3CP%3EExcel%20comes%20by%20default%20with%204%20built%20in%20Custom%20Lists%20(Months%20%26amp%3B%20Weekdays%2C%20Full%20%26amp%3B%20Abbreviated).%20If%20because%20of%20the%20Language%20settings%2C%20you%20do%20not%20have%20the%20built-in%20Custom%20lists%2C%20then%2C%20You%20can%20Create%20them%20by%20going%20to%20the%20File%20Tab%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFile%20%26gt%3B%26gt%3B%20Excel%20Options%20%26gt%3B%26gt%3B%20Advanced%20(Shortcut%20ALT%2C%20F%2C%20T)%20%26gt%3B%26gt%3B%20%3CSTRONG%3EEdit%20Custom%20Lists%3C%2FSTRONG%3E%26gt%3B%26gt%3B%20here%20you%20can%20either%20type%20each%20list%26nbsp%3B%20under%20List%20Entries%20(each%20value%20on%20a%20different%20line)%20then%20hit%20%3CSTRONG%3EADD%3C%2FSTRONG%3Eor%20if%20you%20already%20have%20the%20Values%20in%20the%20Worksheet%20you%20can%20select%20them%20and%20hit%20%3CSTRONG%3EImport%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20498px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F125541i0AFF1F81A79D722C%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Custom%20List.png%22%20title%3D%22Custom%20List.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20Helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
aldrigoffice
New Contributor

Hi, 

I'm using US English as a default language in Office 365 and Windows 10. However, keyboard input, date and time is Swedish. 

 

There's some kind of conflict because I can't autofill English words such as "Weekdays" etc. 

 

I've tried to put everything in English 'everywhere'. Any ideas, friends?  

 

 

2 Replies

@aldrigoffice 

Hi

Date format and settings are controlled by the central settings of the Windows Operating System:

Start button (Windows Button) >> Settings Gear >>Time and Language >> Date , Time & Regional Formatting >> You make changes here.

 

on the Other hand , AutoFill Options are controlled by the "Custom Lists".

Excel comes by default with 4 built in Custom Lists (Months & Weekdays, Full & Abbreviated). If because of the Language settings, you do not have the built-in Custom lists, then, You can Create them by going to the File Tab:

 

File >> Excel Options >> Advanced (Shortcut ALT, F, T) >> Edit Custom Lists>> here you can either type each list  under List Entries (each value on a different line) then hit ADD or if you already have the Values in the Worksheet you can select them and hit Import

Custom List.png

 

Hope that Helps

Nabil Mourad

@aldrigoffice

 

Hi,

 

The source of the weekday's autofill feature is this window:

Custom Lists.png

 

To find it, go to Options >> Advanced >> General >> Edit Custom Lists

 

Please check it out and see how it looks like.

 

Regards

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies