To drag a number sequence in Excel, enter the first two numbers in adjacent cells, select both cells, then drag the small fill handle at the selection’s bottom-right corner across the cells you want to fill. Excel continues the interval between the numbers. For a simple count such as 1, 2, 3, enter 1 and 2 first; entering only 1 may copy the same value instead of creating a sequence.
This works in Excel for Microsoft 365 on Windows and is also available in Excel for Mac and Excel for the web. You can make sequences that increase or decrease, count by a custom interval, or use Excel’s Fill Series command when you want a specific ending number.
What You’ll Need
- An Excel workbook with a blank area where the sequence can go.
- A starting number and, for a reliable pattern, a second number that shows the interval you want.
- A mouse or trackpad to drag the fill handle. If you cannot see it, check the troubleshooting section below.
Step-by-Step
- Choose the starting cell. Click the cell where the first number should appear, such as A1. Check that the cells beneath or beside it are available, because dragging will fill those cells. If the sequence belongs in a table or next to existing data, plan the destination range first so you do not overwrite anything.
- Enter the first number. Type the value you want the sequence to begin with, such as 1, 10, or 100, and press Enter. You can use a negative number or decimal as a starting point too. The number’s display may depend on the cell’s number format, but Excel uses its underlying numeric value when it extends the pattern.
- Enter a second number to define the interval. In the cell directly below the first number, type the next value. For a sequence counting by ones, enter 2 after 1. For a sequence counting by fives, enter 15 after 10. To count backward, enter a lower value second, such as 9 after 10. These first two values tell Excel the direction and step size.
- Select both starting cells. Drag across the two cells, or click the first and Shift-click the second, so both values are selected. Make sure the selection contains the actual numeric values in the order you want them repeated as a pattern. If you select only one cell, Excel may copy that number rather than infer the interval.
- Locate the fill handle. Look at the lower-right corner of the selected range. A small square appears there; this is the fill handle. Move the pointer over it until the pointer changes to a small black cross. Do not grab the border of the selection, which would move the cells rather than extend the series.
- Drag through the destination cells. Hold the mouse button down on the fill handle and drag down to fill a column, or to the right to fill a row. For example, selecting 1 and 2 in A1:A2 and dragging down to A8 fills the pattern through A8: 1, 2, 3, 4, 5, 6, 7, 8. Release the button when the outline reaches the last cell you want to fill.
- Check the result and choose a fill option if needed. Look at the last few numbers to confirm that the interval is right. After you release the mouse, Excel may show an Auto Fill Options button near the filled range. Click it if you want to switch between options such as filling a series or copying cells. Available options can vary depending on the selected cells and the kind of data.
- Use a single starting number only when appropriate. If you drag one cell containing 1, Excel may repeat 1 in each destination cell. If that happens, click the Auto Fill Options button and choose Fill Series, if offered. You can also undo the result with Ctrl+Z on Windows, enter the first two values, select them, and drag again. On Mac, use Command+Z to undo.
- Fill horizontally or in another direction. The same method works across a row: enter two numbers in neighboring cells, select both, and drag the handle to the right. You can also drag upward or leftward to extend a pattern in the opposite direction, provided the destination cells are available. Check the order at the end, especially when filling toward the beginning of a worksheet.
Here are a few useful starting pairs and the pattern Excel can infer: 3 and 4 continues 5, 6, 7; 20 and 30 continues 40, 50, 60; and 8 and 6 continues 4, 2, 0. A pair such as 2 and 5 establishes a step of 3, so the next values are 8, 11, and 14. Excel continues the numerical difference, not a label or meaning you have in mind, so choose the seed values carefully.
Common Mistakes
- Selecting just one number and expecting a series. With one numeric cell, Excel can interpret dragging as copying. Start with two values that show the intended pattern, or use the Fill Series option.
- Choosing the wrong second value. If you enter 1 and 3, Excel counts by twos. If you meant to count by ones, use 1 and 2. Review the first few filled cells before relying on a long sequence.
- Dragging the selection border instead of the handle. The border moves or copies selected cells; the small square in its lower-right corner extends the contents. Pause over the square until the pointer changes to the fill cross.
- Filling over existing information. Excel replaces contents in the destination cells when you fill into them. Check the whole route of the drag first, and undo immediately if you overwrite something unintentionally.
- Entering numbers stored as text. A number with a leading apostrophe, or a value imported as text, may not behave as a numeric seed. If Excel copies the text or produces an unexpected result, convert the entries to numbers and try again.
- Assuming formatting determines the step. Currency, decimal, or date-like formatting affects how a value looks, but it does not necessarily define the interval. The numeric values in the selected cells determine the pattern.
Tips
- Use a deliberate pair for custom intervals. For example, enter 100 and 125 to make values rise by 25. To make a descending sequence by tens, use 50 and 40. The difference between the first two cells is the key.
- Set a stopping point when you know the final value. If you need exact control over the endpoint or do not want to drag a long way, use the Series dialog instead. Select a range that includes the starting cell, then choose Home > Fill > Series. In the dialog, choose Rows or Columns, select Linear, and enter a Step value and Stop value. Confirm that the selection direction and stop value match your goal before clicking OK.
- Use the Auto Fill Options button to change the result. If Excel copies rather than extends, or extends when you wanted copies, the button that appears after filling can offer the alternative. The choices depend on whether you filled numbers, dates, or other content.
- Keep identifiers separate from quantities. If you are creating IDs such as Item-001 or codes with leading zeroes, Excel may interpret the entries as text or remove zeros. Check the result before using the series in labels or records. For fixed-width codes, format the destination cells as Text before entering the values, or use a method designed to preserve the required pattern.
- Remember the platform differences. The fill-handle gesture works in Excel for Mac as well as Windows. Excel for the web also supports dragging a fill handle, although browser window size and touch controls can make the small handle harder to grab. On a Mac, Command+Z undoes a fill; on Windows, use Ctrl+Z. Touchscreen users can drag the handle with a finger if the app displays it clearly.
Troubleshooting
The fill handle is missing: In Excel for Microsoft 365 on Windows, open File > Options > Advanced. Under the editing options, confirm that Enable fill handle and cell drag-and-drop is checked, then select OK. On a Mac, check Excel’s settings or preferences for the editing option that enables fill-handle dragging; wording and location can differ by release. In Excel for the web, make sure the workbook is open in Edit mode rather than a view-only state.
The same number appears in every cell: Undo with Ctrl+Z on Windows or Command+Z on Mac. Enter two seed numbers that show the desired step, select both, and drag again. If the cells are already filled, use the Auto Fill Options button and select Fill Series when that option is available.
The numbers skip or move in the wrong direction: Inspect the first two selected values. Excel uses their difference: 4 followed by 7 means an increase of 3; 7 followed by 4 means a decrease of 3. Correct one of the seed values and repeat the fill. Also check that you selected the cells in the intended order and dragged in the intended direction.
The fill changes existing data or stops too soon: Undo immediately if you overwrote cells. For a long sequence, use Home > Fill > Series and enter a step and stop value, or drag only after confirming the destination range is empty. If a worksheet is protected, or you have read-only access, you may need permission to edit the relevant cells before filling.
Excel treats a value as text: Click the seed cell and look for a leading apostrophe in the formula bar, or check whether the cell is formatted as Text. Change the cell format to General or Number, then re-enter the value so Excel recognizes it as numeric. Changing the format alone may not convert a value that is already stored as text.
Frequently Asked Questions
Why does Excel repeat the number instead of continuing the sequence?
When you drag one numeric cell, Excel can treat the action as copying. Enter two numbers that define the interval, select both, and drag the fill handle. Alternatively, choose Fill Series from the Auto Fill Options button if it appears.
How do I make Excel count by 5 or 10?
Enter two values with that difference. For counting by fives, start with 5 and 10; for tens, use 10 and 20. Select both cells and drag. Excel continues the interval it detects from the pair.
Can I drag a number sequence across a row?
Yes. Put the first two values in adjacent cells horizontally, select them, then drag the fill handle to the right. The method also works when filling down a column.
Can I create a sequence that counts backward?
Yes. Enter the larger number first and a smaller number second, such as 12 and 10. Drag the fill handle to continue the descending pattern by two. Confirm the first few results before filling a large range.
How do I stop the sequence at an exact number?
Use Home > Fill > Series, choose the correct direction and Linear type, and enter the step and stop values. This is often easier than estimating how far to drag, particularly for a long series.
Does this work in Excel for Mac or the web?
Yes. The basic method—enter two values, select them, and drag the fill handle—is available in Excel for Mac and Excel for the web. Menu locations and some interface details vary, but Windows shortcuts such as Ctrl+Z become Command+Z on Mac.
Related
- How to Delete Blank Cells in Excel Without Losing Data
- How to Delete an Excel File from a SharePoint Site
- How to Delete Blank Cells in Excel Safely
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Auto Round Off? What Really Happens to ValuesExcel does not normally change a number just because it displays fewer decimal places: formatting rounds the appearance,…
- Filter Excel Table Without a Header: What WorksExcel filtering needs a header row: if you apply Filter to a headerless range, Excel treats its first…
- INDIRECT Excel Function: Examples, Uses, and LimitsIn Excel, INDIRECT converts text into a live cell or range reference; if A2 contains B5, =INDIRECT(A2) returns…
- LEFT Excel String Formula: Extract Text from the LeftIn Excel, use the LEFT function to return a chosen number of characters from the beginning of a…
- Google Translate Formula in Excel: Why It Fails and FixesIf a Google Translate formula is not working in Excel, the main issue is that Excel does not…
- NetSuite Saved Search Formula Examples and TipsNetSuite saved search formulas let you calculate, classify, format, and filter search results with SQL-style expressions, usually using…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.