If Excel repeats a number instead of counting up when you drag the fill handle, select the starting number and choose Auto Fill Options > Fill Series, or select the first two numbers to establish the pattern before dragging. For example, enter 1 and 2 in adjacent cells, select both, then drag the small square at the selection’s lower-right corner to continue 3, 4, 5.
Why Excel repeats a number
Excel’s fill handle can either copy cell contents or extend a series. When you drag from a single numeric cell, Excel may copy that value into the other cells rather than infer that you want to count. This is useful when you want the same value repeated, but surprising when you expected a sequence.
A second issue is that Excel needs clues about the pattern. Starting with two values gives it a step size: 1 and 2 imply an increase of 1; 5 and 10 imply an increase of 5. After selecting those two cells and dragging, Excel continues the pattern as 15, 20, and so on. It can extend other regular patterns too, such as 10, 8, 6 becoming 4, 2.
The fill handle is the tiny square at the bottom-right corner of a selected cell or range. Dragging the cell border instead moves the selection, and dragging a different corner or edge may select cells rather than fill them. Watch for the small black plus pointer over the fill handle before you drag.
Try these fixes first
For a simple count, use one of these approaches. The first is usually quickest when you have already started filling a column; the second is helpful when you know the intended interval.
- Choose Fill Series after dragging. Drag the fill handle, click the Auto Fill Options button that appears near the filled range, and select Fill Series. If you want duplicates instead, choose Copy Cells.
- Seed the pattern with two cells. Enter 1 in A1 and 2 in A2, select A1:A2, and drag the fill handle down. Excel uses the difference between the values as the increment.
- Use the Fill command. Enter a starting number in the first cell and select the range to fill. On Excel for Microsoft 365 for Windows, choose Home > Fill > Series, set the series direction and step value, then select OK.
- Check what you selected. If you select several cells that all contain 1, Excel may treat them as a repeated pattern. For a count, make sure the selected seed cells contain distinct values such as 1 and 2.
For the Series dialog, choose Columns when filling downward or Rows when filling to the right. A step value of 1 produces consecutive integers. A step value of 2 produces values such as 1, 3, 5. If you enter a stop value, Excel stops the series at that limit; without one, it fills the selected range.
How Excel decides what to fill
Excel looks at the selected starting cells and attempts to continue their pattern. A single value does not always communicate whether you mean “copy this” or “add one each time,” so the one-cell result can be a copy. Two values make the intended interval clearer. The same principle applies to dates, times, and many number patterns.
For example, select cells containing 3 and 6, then drag: Excel can continue 9, 12, 15. Select January 1 and January 2, then drag to extend daily dates. If you want the same date copied rather than advanced, use the Auto Fill Options menu to choose the appropriate behavior. Excel may also recognize patterns such as weekdays or months, depending on the seed values and fill choice.
Auto Fill Options appears after a fill operation and offers choices appropriate to the content. The button can be easy to miss; it appears close to the lower-right area of the filled selection. If it disappears, undo with Ctrl+Z on Windows and repeat the drag, or use the Home tab’s Fill command instead. On Mac, the equivalent of Windows Ctrl+Z is Command+Z.
When numbers are stored as text
A cell can look like it contains 1 while actually containing text, especially if the value was imported, pasted from a website, or entered with a leading apostrophe. Text values can behave differently from numeric values during filling and arithmetic. A green triangle in the cell’s corner may indicate that a number is stored as text, though that indicator can be turned off.
Click a suspect cell and inspect the formula bar. If Excel shows a leading apostrophe before the number, or if the value is left-aligned while nearby numbers are right-aligned, it may be text; alignment alone is not definitive because formatting can change it. If a warning icon appears, select it and choose Convert to Number.
For a column of imported numeric text, another option is to select the cells and use Data > Text to Columns, then choose Finish if the default settings are suitable. Make a copy first if the column contains mixed data, because conversion can affect how values are interpreted. Once Excel recognizes the cells as numbers, try the fill again with two seed values.
Use a formula for a predictable sequence
If you need a reliable count and do not want to depend on Auto Fill’s interpretation, use a formula that adds the desired increment. With the starting value 1 in A1, enter =A1+1 in A2 and fill A2 downward; the first result is 2, followed by 3, 4, and so on. Excel adjusts the relative reference as the formula is filled down.
For a different interval, change the amount added. With 10 in A1, enter =A1+5 in A2 and fill down; the results are 15, 20, 25. This method is especially useful when the increment needs to be explicit or when the fill handle keeps copying a value. If the starting value changes, the later results update based on the formulas.
For a numbered list that should begin with the row number, you can also use a row-based formula, but a simple add-one formula is easier to understand for most short sequences. Remember that formulas create calculated values rather than fixed numbers. If you later need to keep only the results, copy the range and use Paste Special > Values.
Check display formatting and the selected range
Sometimes Excel is increasing the underlying values, but the cells look identical. A number format with zero decimal places can make values such as 1.1 and 1.4 both display as 1. A narrow column can show number signs instead of values, and a custom number format may hide digits or display a fixed label. Click a filled cell and inspect the formula bar, or temporarily choose Home > Number Format and select General to check the underlying result.
Also verify that the cells you intended to fill are actually included in the selection. If the fill stops early, a blank row, an adjacent data boundary, or an accidental short drag may be the cause. Double-clicking the fill handle can fill down alongside neighboring data, but it uses that adjacent column to estimate how far to go. If that column has gaps or ends sooner than your target, select the exact destination range and use Home > Fill > Down instead.
Fill handle settings and workbook restrictions
If the small fill handle is missing or dragging it does nothing, check whether the feature is enabled. In Excel for Microsoft 365 on Windows, open File > Options > Advanced. Under Editing options, make sure Enable fill handle and cell drag-and-drop is selected. Select OK to apply the setting.
Excel for Mac has its own preferences and the wording or location can differ by release. Look in Excel’s Settings or Preferences, then its editing options for the fill-handle or cell-dragging setting. Excel for the web has a different interface from the Windows desktop app; if an option is not available where expected, use the two-cell pattern or enter a formula and fill the range through the available Home tab commands.
A protected worksheet may prevent changes to locked cells, including filling a series. If Excel displays a protection message, check Review > Unprotect Sheet if you have permission and the password, or ask the workbook owner. Merged cells and unusual selections can also interfere with filling. Try a small, unmerged test range in a blank part of the sheet to determine whether the issue is the data, the selection, or a workbook restriction.
Choosing between dragging, Series, and formulas
Dragging is quickest for a short, obvious pattern. Selecting two seed cells is a good choice when the sequence has a simple interval, and Auto Fill Options lets you switch between copying and extending after the fact. The Series dialog is more precise when you need to specify a step and stopping point, especially for longer ranges.
Formulas are preferable when later numbers should respond to changes in earlier cells. For a fixed list that will not change, the fill handle or Series command is simpler. If your task involves a complicated pattern, first write down several expected results and check that Excel’s output matches them; filling a large range quickly does not guarantee that the inferred pattern is the one you intended.
Frequently Asked Questions
Why does Excel copy the same number when I drag?
When you drag from one numeric cell, Excel may interpret the action as copying that value. Select two consecutive values to show the increment, or drag and choose Auto Fill Options > Fill Series.
How do I make Excel count by 10 instead of 1?
Enter two seed values 10 and 20, select both, and drag to continue the pattern. Alternatively, use Home > Fill > Series and set the step value to 10.
Can I drag a number down without changing it?
Yes. Drag the fill handle and choose Copy Cells from Auto Fill Options. You can also copy the original cell and paste it into the destination range when you want exact duplicates.
Why does Excel show the same number even though the values changed?
The number format may be rounding the display or hiding differences. Select a filled cell and check the formula bar, or temporarily change its number format to General or show more decimal places.
Why can’t I see or use the fill handle?
On Windows, check File > Options > Advanced and enable Enable fill handle and cell drag-and-drop. Sheet protection, merged cells, or a restricted selection can also prevent filling.
Related
- Excel Budget Spreadsheet Free? Find Templates and Tips
- Excel Accounting Format: How It Works and When to Use It Properly
- Excel Accounting Format: Show Negative Numbers in Brackets
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- IFERROR Not Working in Excel? Find and Fix the CauseIf IFERROR is not working in Excel, first check that the formula is written as =IFERROR(your_formula, value_to_show_if_an_error_occurs) and…
- Excel Cell Drop-Down Options: Create, Edit, and FixTo add Excel cell drop-down options in Microsoft 365 for Windows, select the cell, choose Data > Data…
- SUBSTITUTE Formula Not Working in Excel? Fix ItIf Excel’s SUBSTITUTE formula is not working, first check that the text to change and the text to…
- Which One Is Not an Aggregate Function? SQL GuideA scalar function such as UPPER() is not an aggregate function: it transforms a value in an individual…
- Excel File Open in Another Application Error: FixesIf Excel says a file is open in another application, first close the workbook everywhere it may be…
- Excel Page Break Won’t Move? Fix the Common CausesIf an Excel page break will not move, switch to View > Page Break Preview and drag the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.