Autofill Numbers in Excel: Create a Series

How-to basics · Updated November 18, 2026

To autofill numbers in Excel, enter the first two values of the pattern, select both cells, then drag the fill handle—the small square at the selection’s bottom-right corner—down or across. Excel continues the pattern. If you start with one number, Excel may copy it instead; use Home > Fill > Series to set an exact step and stopping value.

What You’ll Need

  • A workbook open in Microsoft Excel for Microsoft 365 on Windows. The basic fill-handle method also works in Excel for Mac and Excel for the web, though some ribbon commands may be arranged differently.
  • A starting value, and preferably a second value if you want Excel to detect the number pattern automatically. For an exact interval or endpoint, you can use the Series dialog instead.
  • An empty destination range, or a clear idea of which existing cells you are willing to replace. Autofill writes into the cells it reaches.

Step-by-Step

  1. Choose the pattern you want. Decide whether the values should increase or decrease, how much they should change each time, and how many cells to fill. For example, a list might count by 1 (1, 2, 3), by 5 (5, 10, 15), or by 0.25 (0.25, 0.5, 0.75). Knowing the intended pattern first helps you check Excel’s result.
  2. Enter the first value in a cell. Click the starting cell and type the first number. For a simple count, enter 1. For a sequence counting by 5, enter 5. Press Enter to commit the value. Avoid typing an apostrophe before the number, because that can make Excel store it as text rather than as a numeric value.
  3. Enter a second value that shows the interval. In the cell directly below the first, type the next number. For a sequence beginning 5, 10, 15, enter 5 in A1 and 10 in A2. For a descending sequence, such as 20, 17, 14, enter 20 and 17. The difference between the two starting numbers tells Excel what change to continue.
  4. Select both starting cells. Drag across the two cells or click the first, then hold Shift and click the second. Confirm that the selection contains both values in the correct order. If the pattern runs across columns instead of down rows, place the two starting values side by side and select them both.
  5. Locate the fill handle. Move the pointer to the tiny square at the bottom-right corner of the selected range. When the pointer changes to a small black plus sign, you are over the fill handle. This is different from the large white plus-shaped selection cursor; if the pointer does not change, move it carefully to the corner.
  6. Drag to the last cell you want to fill. For a vertical sequence, drag the handle down the column. For a horizontal sequence, drag it to the right. Excel displays an outline of the destination range as you drag. Release the mouse button when the outline reaches the desired final cell.
  7. Check the results and the fill options. Look at the last few entries to make sure the step is correct. If the Auto Fill Options button appears next to the filled range, click it to review available choices, such as filling the series or copying the cells. The options shown can depend on the selected data and Excel version.
  8. Use the Series dialog when you need exact control. If you need a specific interval or endpoint, select the cell where the series should begin and the blank cells you want to fill. On Windows, choose Home > Editing > Fill > Series. In the dialog, choose Rows or Columns to match the direction, choose Linear for a constant difference, and enter the Step value. Enter a Stop value if you want Excel to stop at a particular number, then select OK. For example, starting at 5 with a step of 5 and a stop value of 30 fills 5, 10, 15, 20, 25, and 30, provided the selected range is large enough.
  9. Extend a sequence when you already have values. If a column contains a correct sequence and you want to continue it, select the last two or more cells that show its pattern, then drag their fill handle farther down. Selecting two values is generally enough for a simple constant step; selecting more can make the intended pattern clearer if the sequence is more involved.
  10. Fill a long range without dragging the handle a long way. Enter the starting values, then select them along with the blank destination cells. On Windows, press Ctrl+D to fill down from the top row of the selection. This is useful for copying the top cell’s contents and formatting, but it is not always the best way to create a numerical series. For a deliberate increment, use the fill handle with the starting pair or choose Home > Editing > Fill > Series.

For the 5, 10 example, the selection needs to begin with those two values and include the destination cells. When Excel extends the pattern, the next entries are 15, 20, and 25: each value is 5 greater than the one before it. If you see 5, 10, 5, 10 instead, Excel copied the starting cells rather than extending their pattern; undo the fill and try dragging from the selection’s actual fill handle.

Common Mistakes

  • Dragging from only one number and expecting a sequence. Excel commonly copies one numeric value when you drag its handle. Start with two values that define the interval, or use the Series dialog to specify a step.
  • Selecting the wrong starting cells. If you select only the second value, or include an unrelated cell, Excel may repeat a value or infer an unexpected pattern. Select the intended starting pair and check the selection before dragging.
  • Using the wrong direction. A vertical selection is naturally extended down a column, while a horizontal selection extends across a row. If you need the other direction, arrange the starting values in that direction first.
  • Filling farther than intended. Dragging too far can overwrite existing content. Check the destination cells before you start, watch the outline while dragging, and use Undo immediately if the result replaces data you needed.
  • Confusing a copied sequence with a continued sequence. Repeated groups, such as 5, 10, 5, 10, indicate that Excel copied the selected cells. A continuing series would be 5, 10, 15, 20. Use the Auto Fill Options button when available or undo and use Series.
  • Typing numbers as text. Values stored as text may not behave like numbers during a fill. A leading apostrophe, spaces, or an imported text format can cause this. Check whether the entries align differently from other numbers or show a warning indicator, and convert them to numeric values if necessary.

Tips

  • Use two seeds to define the interval. Enter 2 and 4 to count by 2, or 100 and 90 to count down by 10. The first pair is a compact way to show Excel the pattern.
  • Use the Series dialog for nonstandard steps. It is more precise than dragging when you need a particular step value or stopping value. You can also choose a growth pattern in the dialog, but verify the results carefully if the sequence is not a simple linear count.
  • Keep the starting values in the same row or column. This makes the intended direction clear and avoids accidentally filling an adjacent range.
  • Use Undo as a quick safety net. Ctrl+Z on Windows reverses an unwanted fill. On Mac, use Command+Z. Undo promptly, before making other changes that you want to keep.
  • Distinguish a number series from a list of labels. Excel has built-in patterns for some familiar labels, but for a custom numerical interval the most reliable method is to supply two starting numbers or set the step in Series.
  • On Mac, use the fill handle or the Series command. The handle works in Excel for Mac. Ribbon names and layout can vary slightly by release; look for the Fill command on the Home tab if you need the Series dialog. The Windows Ctrl+Z shortcut is Command+Z on Mac.
  • In Excel for the web, use the handle for routine fills. Enter the seed values, select them, and drag the fill handle as in the desktop version. If you need settings that are not available in the browser’s interface, open the workbook in the desktop app and use its Series command.

Troubleshooting

Excel repeats the same number. Undo the fill, then check whether you selected two distinct starting numbers. If you need to start from just one value, use Home > Editing > Fill > Series and enter the step and stop values. If you are working with a single cell and the handle copies it, that is expected behavior rather than an error.

The values increase by the wrong amount. Look at the difference between your seed cells. If you enter 3 and 8, Excel can infer a step of 5, so the next number is 13. Replace the second seed with the value that gives the desired interval, or use Series to enter the exact step.

The fill handle is not visible or does not work. Make sure you have selected a cell or range, then move the pointer precisely to the lower-right corner of the selection. If dragging still does not work in desktop Excel, check that fill-handle dragging is enabled: choose File > Options > Advanced, then under Editing options check Enable fill handle and cell drag-and-drop. The setting and path may differ on Mac or in the web app.

The result contains blanks or stops early. Check whether the selected destination range includes all the cells you meant to fill. If you used a stop value in the Series dialog, check that the starting number and step can reach that endpoint. For example, starting at 2 and stepping by 3 will not land exactly on 10; the sequence goes 2, 5, 8, 11.

The series is right, but the appearance is wrong. Autofill can also carry formatting from the starting cells. If the numbers have an unwanted color, border, or number format, use the Auto Fill Options button and choose Fill Without Formatting when that option is offered. You can also apply the desired formatting afterward from the Home tab.

Frequently Asked Questions

Why does Excel copy one number instead of counting up?
With a single numeric starting cell, Excel may copy that value into each destination cell. Enter a second value that establishes the interval, select both, and drag the handle, or use the Series dialog to enter a step.

How do I autofill numbers by 5?
Enter 5 and 10 in adjacent cells, select both, and drag the fill handle. Excel continues 15, 20, 25, and so on. Alternatively, set the Series dialog’s Step value to 5.

Can I autofill numbers across a row instead of down a column?
Yes. Put the starting values in neighboring cells in the same row, select them, and drag the fill handle to the right. To use the Series dialog, choose Rows.

How do I make Excel count backward?
Enter two values in descending order, such as 20 and 17, select both, and drag the handle to continue 14, 11, 8. For an exact decrement, use a negative Step value in the Series dialog.

Can I stop a series at a particular number?
Yes. In the Series dialog, enter a Stop value as well as the Step value. Make sure the selected range is big enough to include the endpoint and that the step reaches it; a series may pass over a stop value that does not fit its interval.

Does autofill work in Excel for Mac and Excel for the web?
Yes, the fill handle is available in both. Menu placement and available Series options can vary, so use the desktop app if you cannot find a particular dialog or setting in the browser.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.