How to Fix Excel Weekday Autofill Using English Instead of Dutch
Question details
Excel autofills weekday names in English even when the application language and formulas are configured for Dutch.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Dragging the fill handle to automatically populate a sequence of weekdays in an Excel spreadsheet.
- Observed behavior
- The autofilled weekday sequence outputs English names (e.g., Monday, Tuesday) instead of the expected Dutch equivalents.
Make sure you know the exact spelling and chronological order of the Dutch weekday names (maandag, dinsdag, woensdag, etc.) before modifying the application settings.
Create a Custom List for Dutch Weekdays
Manually add a localized custom list to Excel to override the default English autofill sequence.
Excel relies on pre-defined custom lists to determine how autofill sequences behave. Even if your display language is Dutch, the internal custom list might still be defaulting to English. You can manually add the Dutch sequence to ensure the fill handle outputs the correct language.
Launch Microsoft Excel, click on the 'File' tab in the top-left corner, and select 'Options'. In the Excel Options dialog box, click on 'Advanced' in the left pane.
Scroll down the Advanced options to the 'General' section and click on the 'Edit Custom Lists...' button.
Select 'NEW LIST' in the Custom lists box. In the List entries box, type the Dutch weekdays in order, separated by commas or enters (e.g., maandag, dinsdag, woensdag, donderdag, vrijdag, zaterdag, zondag). Click 'Add', then click 'OK'.
Return to your worksheet, type 'maandag' into an empty cell, select that cell, and drag the fill handle at the bottom-right corner to verify it now populates the Dutch days.

Manage Custom Autofill Lists Easily in WPS Spreadsheet
WPS Office Spreadsheet offers full support for custom data sequences and local languages. You can quickly set up your own autofill lists while enjoying a fast, lightweight, and highly compatible spreadsheet experience.
- 1. Open WPS Options: Launch WPS Spreadsheet, click 'Menu' in the top-left corner, and choose 'Options'.
- 2. Access Custom Lists: Select 'Custom Lists' from the left-hand navigation menu.
- 3. Create a New Sequence: Click 'New List', type your localized weekday names into the 'List entries' box, click 'Add', and then 'OK' to save your new autofill sequence.

Frequently Asked Questions
Why does Excel default to English weekdays?
Excel autofill relies on custom lists stored within the application's configuration. If the localized (Dutch) list was not installed or generated properly during your initial software setup, Excel falls back to the default English sequence.
Can I import a custom list directly from my spreadsheet cells?
Yes. In the 'Edit Custom Lists' menu, you can select a range of cells that already contain your desired weekday names and click 'Import', saving you from typing them manually.
Will this custom list setting apply to all my future workbooks?
Yes, custom lists are saved at the application level rather than the workbook level. Once you add the Dutch weekdays, the autofill sequence will work in both your current and any newly created workbooks on that computer.




