Forum Discussion
Autofill "Weekdays etc" not working (not in English)
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? 🙂
3 Replies
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
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
- I had the same problem. To confirm, this worked. Thanks
