Make Excel AutoFill Create a Number Series Instead of Copying Cells
Question details
The user wants Excel AutoFill to create a number sequence rather than repeat a single value.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Dragging the fill handle from a cell containing one number to populate adjacent cells.
- Observed behavior
- Excel copies the selected number instead of incrementing it.
Enter a starting number in a cell and locate the fill handle at the cell's lower-right corner. Decide whether the sequence should increase by one or use a different increment.
Hold Ctrl While Dragging the Excel Fill Handle
Use this shortcut to create a series starting from a single numeric cell in Excel for Windows.
Click the cell containing the first number in your series.
Hold Ctrl and drag the fill handle from the cell's lower-right corner across or down the cells you want to fill.
Release the mouse button, then release Ctrl. Check that the filled cells contain consecutive numbers rather than copies.

Select Two Starting Numbers Before Using AutoFill
Use two values to tell Excel the increment you want, such as 1, 2 or 10, 20.
Fill a Number Series in WPS Spreadsheet
Use two starting values and the fill handle in WPS Spreadsheet to extend a number sequence with the increment you choose.
- 1. Open a spreadsheet: Open WPS Spreadsheet and create a workbook or open an existing Excel file.
- 2. Enter starting values: Enter the first two numbers in adjacent cells, such as 1 and 2.
- 3. Select both cells: Drag across the two starting cells to select them.
- 4. Fill the series: Drag the fill handle at the selection's lower-right corner across or down the cells you want to populate.

Frequently Asked Questions
Why does Excel copy my number when I drag the fill handle?
When only one numeric cell is selected, Excel normally copies its value. Select two starting numbers before dragging, or hold Ctrl while dragging in Excel for Windows.
How do I fill a series that increases by more than one?
Enter two values that show the desired increment, such as 10 and 20. Select both cells and drag the fill handle to continue the series.
How can I create a decreasing number series?
Enter two descending values, such as 10 and 9, in adjacent cells. Select both cells and drag the fill handle to extend the pattern.
Does Excel automatically recognize dates as a series?
Excel normally recognizes dates and text ending in a number as series when you drag the fill handle. For plain numbers, use two starting values or the Ctrl shortcut in Excel for Windows.




