How to Fill Weekday Names in Excel Using a Keyboard Shortcut
Question details
The user needs to fill a series of weekday names in Excel without dragging the mouse, specifically using a keyboard shortcut to invoke the Fill Series command.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Entering a sequential list of days (e.g., Monday, Tuesday) down a column and wanting to automatically fill the remaining selected cells using only the keyboard.
- Observed behavior
- The user is looking for the exact keyboard combination to trigger the Fill option for continuing weekday sequences without relying on the mouse drag-and-fill handle.
Ensure you have typed at least one weekday name (such as 'Monday') in the starting cell so the application knows which pattern to begin filling.
Use the Alt Key Sequence for Fill Series
This keyboard shortcut directly navigates the Excel ribbon to open the Series dialog and fill your selected weekday pattern.
By utilizing Excel's ribbon shortcut keys, you can trigger the Fill Series command accurately without needing the mouse. This is especially helpful for large data sets or users who prefer keyboard navigation.
Highlight the cell containing your starting weekday name, hold down the Shift key, and press the Down Arrow key to select the empty cells you wish to fill.
Press the Alt key, followed by H, F, I, and S in sequence. This will navigate through the Home tab to the Fill menu and open the Series dialog box.
Press Shift + Tab to navigate to the Fill options. Ensure the type is set correctly for your data pattern, and press Enter to apply the sequence.

AutoFill Weekdays Instantly with WPS Spreadsheet
WPS Office provides a powerful, free spreadsheet tool that fully supports standard keyboard shortcuts, AutoFill patterns, and advanced data series options to boost your daily productivity.
- 1. Enter the starting day: Open your WPS Spreadsheet document and type 'Monday' or your desired starting weekday into a cell.
- 2. Select the cells: Press Shift + Down Arrow to highlight the starting cell along with the empty cells below it.
- 3. Apply AutoFill: Go to the Home tab, locate the Fill icon, click on Series, select AutoFill, and press OK to instantly populate the list.

Frequently Asked Questions
Why does Excel just copy the word 'Monday' instead of filling the weekdays?
This occurs if the AutoFill setting defaults to 'Copy Cells' rather than 'Fill Series'. After filling the data, click the small AutoFill Options icon that appears at the bottom right of the selection and choose 'Fill Series' to correct the pattern.
Can I use a keyboard shortcut to fill weekday names across a row instead of a column?
Yes. Instead of using Shift + Down Arrow, hold Shift and press the Right Arrow key to highlight cells horizontally across the row, then use the same Alt + H + F + I + S shortcut.
How can I exclude weekends and only fill Monday through Friday?
When you open the Series dialog box using the keyboard shortcut, look under the 'Date unit' section and select 'Weekday'. This ensures that Saturdays and Sundays are skipped in your data sequence.
Are abbreviated days like 'Mon' and 'Tue' recognized by the Fill Series command?
Yes, both Microsoft Excel and WPS Spreadsheet recognize standard three-letter abbreviations. Typing 'Mon' and using the Fill command will correctly populate 'Tue', 'Wed', 'Thu', and so on.




