Office Settings & Configuration

Fix WPS Office Excel AutoFill Copying Dates Instead of Creating a Sequence

Huma Ashraf Ch Nov 13, 2026 870 views

Question details

The user needs to make Excel AutoFill extend dates into a sequence instead of copying the same date.

Fix WPS Office Excel AutoFill Copying Dates Instead of Creating a Sequence

Product: WPS Office Excel
Device & OS: not provided
Scenario: The user enters one or more dates and drags the fill handle expecting a date series.
Observed behavior: AutoFill copies the same date, increments only part of the text, or does not create a sequence.

Before you start

Before changing settings, select the affected cells and check whether the formula bar shows real dates or text. If the dates are text or use a nonstandard format, clear the cells and apply General or Date formatting first.

Solution 1Recommended

Enter Recognized Real Dates and Use AutoFill to Create a Date Sequence

Use this when cells contain text dates, nonstandard date formats, or only the year is incrementing.

Excel creates a date series only when it recognizes the cell entries as real dates. Text values or nonstandard date formats may cause AutoFill to copy the cell or increment only a numeric portion.

Clear and format the date cells

Select the affected cells, click Home > Number Format, and choose General or Date.

Enter the first two real dates

Type the first date in a recognized format such as 10/5/24 or 2024-10-05, then type the next expected date in the cell directly below.

Drag the fill handle

Select both date cells, move the pointer over the fill handle in the lower-right corner, and drag it down or across the range.

Confirm Fill Series if needed

If the Auto Fill Options icon appears after dragging, click it and select Fill Series instead of Copy Cells.

Enter Recognized Real Dates and Use AutoFill to Create a Date Sequence

AutoFill now creates a date series: With real dates in recognized formats, WPS Office Excel automatically extends the sequence by the interval between the first two selected dates.

Solution 2

Enable the Fill Handle and Cell Drag-and-Drop in WPS Office Excel

Use this when dragging the fill handle does not work or when AutoFill copies instead of filling a series because the option is disabled.

Solution 3

Display Weekday Names Without Breaking the Date Sequence

Use this when you want the series to show weekday names such as Friday, 10/5/24 while keeping real date values.

Create an AutoFill Date Sequence in WPS Office Excel

Use WPS Office Excel to enter recognized real dates, enable the fill handle, and drag the fill handle to create a date series. It keeps Microsoft Excel .xlsx files fully compatible while providing the same familiar ribbon tools.

1. Open the workbook in WPS Office Excel: Launch WPS Office, open the Excel file, and select the worksheet containing the date cells.
2. Format the date cells correctly: Select the affected cells, then click Home > Number Format and choose General or Date so text or nonstandard entries are cleared for real dates.
3. Enter two real dates: Type the first date in a recognized format such as 10/5/24 or 2024-10-05, and enter the next expected date in the cell below.
4. Drag the fill handle to fill the series: Select both cells, drag the fill handle over the target range, and choose Fill Series from the Auto Fill Options icon if it appears.
5. Apply weekday formatting if needed: Right-click the date range, choose Format Cells > Custom, enter dddd, d/m/yy, and click OK.

Creates date sequences reliably from real dates instead of textFull compatibility with Microsoft Excel .xlsx and .xls filesFamiliar ribbon interface makes switching from Microsoft Excel easyFree to use with no subscription for date formatting and AutoFill toolsSupports custom number formats such as dddd, d/m/yy

microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel AutoFill copy the same date instead of creating a sequence?

AutoFill copies the date when the cells contain text, the date format is not recognized, or the fill handle is disabled. Enter real dates in a recognized format such as m/d/yy or yyyy-mm-dd and confirm File > Options > Advanced > Enable fill handle and cell drag-and-drop is enabled.

How do I enable the fill handle in WPS Office Excel?

Click File > Options > Advanced, go to Editing options, and check Enable fill handle and cell drag-and-drop. Then click OK.

What date format should I use for AutoFill to create a sequence?

Use a recognized format such as m/d/yy, for example 10/5/24, or yyyy-mm-dd, for example 2024-10-05. Avoid text values or formats Excel does not recognize as dates.

How can I show weekday names while still having a date series?

Keep the underlying values as real dates. Right-click the cells, choose Format Cells > Custom, enter dddd, d/m/yy, and click OK.

Why does AutoFill only increment the year in my date?

This usually happens with a nonstandard format such as 15-02-2024. Clear the cells, apply General or Date formatting, and re-enter the dates in a recognized format like m/d/yy or yyyy-mm-dd.

Office App Problems