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

[aldrigoffice]

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]

@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

Hope that Helps

Nabil Mourad

[#3]

@aldrigoffice

Hi,

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

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

Please check it out and see how it looks like.

Regards

[#4]

I had the same problem. To confirm, this worked. Thanks