Function Problems

Make Excel AutoFill Create a Number Series Instead of Copying Cells

Muhammad TalhaMuhammad Talha Nov 13, 2026 869 views

Question details

The user wants Excel AutoFill to create a number sequence rather than repeat a single value.

Make Excel AutoFill Create a Number Series Instead of Copying Cells
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the starting cell

Click the cell containing the first number in your series.

2
Drag with Ctrl held

Hold Ctrl and drag the fill handle from the cell's lower-right corner across or down the cells you want to fill.

3
Check the sequence

Release the mouse button, then release Ctrl. Check that the filled cells contain consecutive numbers rather than copies.

Hold Ctrl While Dragging the Excel Fill Handle
Shortcut availability: The Ctrl shortcut applies to Excel for Windows. If it does not work in your version, use two starting numbers to define the series.
Create number series in WPS

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. 1. Open a spreadsheet: Open WPS Spreadsheet and create a workbook or open an existing Excel file.
  2. 2. Enter starting values: Enter the first two numbers in adjacent cells, such as 1 and 2.
  3. 3. Select both cells: Drag across the two starting cells to select them.
  4. 4. Fill the series: Drag the fill handle at the selection's lower-right corner across or down the cells you want to populate.
Create consecutive or custom-increment number seriesOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interfaceWork with a free Office suite
QA img-9

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.