Creating a calendar or schedule in Excel often requires typing the days of the week repeatedly. Manually entering Monday, Tuesday, and so on is slow and prone to errors. Excel’s AutoFill feature can generate this sequence for you automatically. This article explains how to use AutoFill to populate days quickly and how to customize the list for different calendar formats.
Key Takeaways: Auto-Filling Days in Excel
- Fill Handle drag: Enter one or two days, then drag the small square to fill the rest of the week or month.
- Home > Fill > Series: Use the ribbon command to fill a specific number of cells with weekdays only.
- Custom right-click fill: Drag with the right mouse button to open a menu for filling weekdays without weekends.
How Excel’s AutoFill Works for Dates and Text
AutoFill recognizes common sequences, including days of the week, months, and numbers. When you type a day name like “Monday” into a cell, Excel stores it as a recognizable pattern. Dragging the Fill Handle tells Excel to continue that sequence. The feature works with both full names (Monday) and abbreviations (Mon). You do not need any special formulas to start the process.
Excel can fill days in two main ways. The standard method fills all seven days in order. The weekday-only method fills Monday through Friday, skipping Saturday and Sunday. This is useful for business calendars. The feature is available in all modern versions of Excel for Windows and works the same in Excel for the web.
Prerequisites for Using AutoFill
Your Excel file does not need special settings enabled. The Fill Handle, the small square at the bottom-right corner of a selected cell, must be visible. If it is not, you can check it in File > Options > Advanced. Under the Editing options section, ensure “Enable fill handle and cell drag-and-drop” is checked. Your data should be in a standard cell, not part of a merged cell or a table with strict data validation that might block the action.
Steps to Auto-Fill Days Using the Fill Handle
The fastest method uses the mouse. Follow these steps to create a list of days.
- Enter the starting day
Click on a cell, for example A1. Type “Monday” and press Enter. You can also use “Mon” or start with any day like “Thursday”. - Select the cell and find the Fill Handle
Click on the cell containing “Monday” again to select it. Move your cursor to the small square in the cell’s bottom-right corner. The pointer will change from a white cross to a thin black cross. - Drag the Fill Handle to fill cells
Click and hold the left mouse button on the Fill Handle. Drag it down column A or across row 1. A tooltip will show the day that will populate each cell as you drag. - Release the mouse button
Let go of the mouse button when you have highlighted enough cells for your calendar. Excel will fill the sequence: Monday, Tuesday, Wednesday, and so on. It will repeat after Sunday.
Using the Series Dialog Box for Precise Control
For longer lists or to fill only weekdays, use the Series command from the ribbon.
- Enter the start day and select the range
Type “Monday” in your starting cell. Highlight that cell and all the empty cells below or to the right where you want the days to appear. - Open the Series dialog
Go to the Home tab on the ribbon. In the Editing group, click Fill. From the dropdown menu, select Series. - Configure the series options
In the Series dialog box, ensure “Columns” or “Rows” is selected based on your data direction. Under Type, select “AutoFill”. Click OK. Excel will fill the selected range with the day sequence.
Filling Only Weekdays (Monday to Friday)
To create a business calendar that excludes weekends, use the right-click drag method.
- Enter the start day and use right-click drag
Type “Monday” in a cell and select it. Hover over the Fill Handle until the cursor becomes a black cross. Click and hold the right mouse button, then drag down or across. - Choose the fill option from the menu
Release the right mouse button. A context menu will appear. Select “Fill Weekdays” from the list. Excel will populate the cells with Monday through Friday, then repeat the pattern, skipping Saturday and Sunday.
Common Mistakes and Formatting Issues
AutoFill Creates Numbers Instead of Day Names
If you type a day and Excel fills numbers like 1, 2, 3, the cell might be formatted as General or Number. Excel is trying to increment a number it thinks is in the cell. To fix this, select the filled cells. Go to the Home tab and find the Number group. Click the dropdown and select “Text” format before using AutoFill. Alternatively, type two days (like Monday and Tuesday) to give Excel a clearer text pattern.
Fill Handle Is Not Visible or Not Working
If you cannot see the Fill Handle, the drag-and-drop feature might be disabled. Go to File > Options > Advanced. Under Editing options, check the box for “Enable fill handle and cell drag-and-drop”. Click OK. Also, ensure you are not in cell edit mode, which is indicated by a blinking cursor in the cell. Press Escape to exit edit mode, then select the cell normally.
Days Are Not in the Correct Order
AutoFill follows the sequence you start. If you type “Wednesday” and then “Friday” in the next cell before dragging, Excel will increment by two days. Always start with one cell, or two adjacent cells with the correct pattern (like Monday, Tuesday). If the order is wrong, clear the filled cells. Start over by entering just the first day and use the standard drag method.
Standard Fill vs. Weekday-Only Fill: Key Differences
| Item | Standard AutoFill (Drag Left-Click) | Weekday Fill (Right-Click Drag) |
|---|---|---|
| Sequence produced | All 7 days in order, repeating | Monday to Friday only, skips weekends |
| Best use case | Full weekly calendars, schedules with weekends | Business work schedules, project timelines |
| Method to activate | Drag Fill Handle with left mouse button | Drag Fill Handle with right mouse button, choose menu option |
| Control over pattern | Basic, follows initial cell(s) pattern | Specific, forces weekday sequence regardless of start day |
You can now create calendar headers in seconds using AutoFill. For more control, use the Series dialog to fill a fixed number of cells. Try using the Ctrl key while dragging the Fill Handle to copy the same day instead of filling a sequence. This is useful for labeling every Monday in a monthly plan.