Excel Not Incrementing Cells When Dragged? How to Fix

Errors & fixes · Updated November 18, 2026

If Excel is not incrementing cells when you drag, it may be copying the selected value instead of extending a series. For a reliable fix, enter two example values, select both cells, and drag the fill handle; for a single starting number, use Home > Fill > Series or choose Fill Series from the Auto Fill Options button.

Quick fix: extend a pattern instead of copying

First check what is selected and where you are dragging. The fill handle is the small square at the lower-right corner of the selected cell or range. When the pointer is over it, drag down or across the cells you want to fill. If you drag the border of the selection instead, Excel may move the cells rather than fill them.

  1. For a simple count, type 1 in A1 and 2 in A2.
  2. Select A1:A2 together, not just A2.
  3. Drag the fill handle downward. The next cells should show 3, 4, 5, and so on.
  4. If Excel repeats a value, click the Auto Fill Options button that appears beside the filled range and choose Fill Series.

For a single numeric seed, such as 1, Excel can treat dragging as copying rather than counting. You can still select the range and use Home > Fill > Series to specify the pattern. These steps apply to Excel for Microsoft 365 on Windows. Excel for Mac has the same fill-handle concept, though the settings and menu labels can vary slightly by release.

How Excel decides what to fill

AutoFill looks at the selected cells and tries to infer your intention. A single value can be copied; a pair or group of values can provide a pattern. For example, selecting 4 and 6 gives Excel a step of 2, so dragging can continue with 8, 10, and 12. Selecting 10 and 20 instead suggests a step of 10.

Excel also recognizes many familiar sequences. A date may continue day by day, while month names such as January and February can continue as March and April. Formulas usually adjust their relative cell references as they are filled. However, Excel cannot always infer whether you want a copy, a sequence, or a particular step size from one cell alone. The result depends on both the contents and the selected range.

After a drag, the small Auto Fill Options button is a useful way to correct the result without starting over. Its available choices depend on the content and context, but may include Copy Cells, Fill Series, Fill Formatting Only, and Fill Without Formatting. Choose the option that matches the task rather than assuming the drag itself has only one meaning.

Copy Cells versus Fill Series

These two options solve different problems. Copy Cells repeats the original contents in every destination cell. Fill Series continues a sequence. If A1 contains 7, copying can produce 7, 7, 7; a series can produce 7, 8, 9. If A1 contains a formula, copying or filling may produce formulas whose references shift, so inspect the formula bar if the displayed results seem unexpected.

To choose explicitly, select the source cell or range and destination cells, then use Home > Fill > Series. In the Series dialog, choose whether to fill rows or columns, select a series type, and enter a step value or stop value where appropriate. For example, choose a linear series with a step value of 5 to produce 5, 10, 15 from a starting value of 5. This is more predictable than asking Excel to infer a pattern from a lone number.

Holding Ctrl while dragging a fill handle can change the copy-versus-series behavior for some numeric selections in Windows Excel, but the result can depend on the selected content. The Auto Fill Options button or the Series dialog is clearer when precision matters.

Make a custom number sequence

To count by a fixed amount, provide Excel with two starting values that show the interval. For example, enter 100 and 125 in adjacent cells, select both, and drag. Excel can infer that each next value should rise by 25. This method works for descending sequences too: entering 9 and 6 establishes a decrease of 3, so the continuation can be 3, 0, and -3.

For a sequence with a specific endpoint, use the Series dialog rather than dragging an unknown distance. Start with the first value, select the destination range, open Home > Fill > Series, and set the step and stop values. Check the direction and whether the dialog is filling rows or columns. A mismatch between the intended direction and the selected cells is a common reason a series appears not to work.

When the values are identifiers rather than quantities, consider whether counting is actually appropriate. Product codes, ZIP codes, and account numbers can look numeric but are often labels. Incrementing them may create invalid identifiers, and copying or storing them as text may be the right choice.

Dates, weekdays, and months

Excel stores real dates as serial numbers and displays them with a date format. Dragging a genuine date often continues the calendar sequence, but you can choose a different date pattern using the Auto Fill Options button. Depending on the selection, choices can include filling days, weekdays, months, or years. For example, a Monday date can be extended by weekdays if weekends should be skipped.

If you want a particular interval, show it with two dates. Enter 1 March and 8 March, select both, and drag to indicate a weekly pattern. If Excel repeats the same date or advances by the wrong interval, select Fill Series and use the date-series controls. The available date unit and step settings make it easier to specify days, weekdays, months, or years than relying on an ambiguous one-cell example.

A date that looks like a date but is stored as text may not behave like a real date. One clue is that changing the cell’s number format does not change how the value appears, or that the entry is aligned and handled differently than neighboring dates. Re-entering it in a format Excel recognizes, or converting the text to a real date, can restore date-series behavior. Confirm the workbook’s regional date conventions before converting ambiguous values such as 03/04/2026.

When formulas do not appear to increment

Filling a formula normally adjusts relative references; it does not necessarily change a constant inside the formula. If A1 contains a formula that refers to B1, filling it down usually changes the reference to B2, B3, and so on. But a reference with dollar signs is absolute and remains fixed. A mixed reference locks either the row or the column, so the pattern may look different when filled in a different direction.

For example, with a value in A1 and a starting value in B1, enter this in B2 to add one to the value directly above: =B1+1. Filling B2 downward produces references to B2, then B3, and so on; if B1 contains 1, the first result in B2 is 2. Check the formula bar to see whether the reference is relative or locked with dollar signs before changing the formula.

Another possibility is that the formula did fill correctly but its displayed result did not update. On Windows, check Formulas > Calculation Options > Automatic. Manual calculation can leave calculated values out of date until recalculation. This setting affects formula results, not whether the fill handle copies or extends a series, so diagnose those as separate issues.

Numbers stored as text and formatting clues

A number stored as text can behave differently from a numeric value. This can happen when data is imported, when an entry begins with an apostrophe, or when a column has been formatted as Text before the values were entered. Excel may copy text entries rather than interpret them as numbers for a numeric series. Look for a warning indicator, inconsistent alignment, or an apostrophe visible in the formula bar.

To check, select a cell and look at the formula bar and Number Format list on the Home tab. Changing the format to General after the value has already been stored as text may not convert it by itself. Depending on the data, use the warning menu’s conversion option, re-enter the value, or use Text to Columns to convert a text column. Make a copy before converting important imported data, and verify leading zeros: converting an identifier such as 0042 to a number can discard them.

Formatting can also make a successful fill look wrong. A destination cell may show the same rounded display even though its underlying value changed, or a custom number format may hide digits. Temporarily apply a suitable number format and inspect the formula bar or increase displayed decimal places before concluding that the values are identical.

Check the fill handle and worksheet restrictions

If dragging does nothing, confirm that the fill handle is enabled. In Excel for Microsoft 365 on Windows, go to File > Options > Advanced, then under Editing options select Enable fill handle and cell drag-and-drop. If the checkbox is off, turn it on and try again. On a Mac, look under Excel > Settings or Preferences > Edit for the fill-handle and cell-drag-and-drop setting; the wording can differ by version.

Also check whether the worksheet is protected. Protection can limit which cells can be changed, so a drag into locked cells may be blocked. Merged cells can interfere with filling a rectangular range, and filtered or hidden rows can make the visible result confusing. Try a small test in an ordinary, unmerged blank area of an unprotected sheet. If filling works there, the problem is likely a feature or restriction in the original range, not a global AutoFill failure.

In Excel for the web, dragging the fill handle is also available, but the browser interface and options can differ from the Windows desktop app. If a specific setting or dialog is missing, open the workbook in the desktop application and check the relevant options there.

A practical troubleshooting order

Use this sequence to isolate the cause without changing unrelated workbook settings:

  1. Click one source cell and confirm its actual contents in the formula bar.
  2. Check whether it is a number, text, date, or formula, and whether the cell format is misleading.
  3. For a numeric pattern, enter two seed values that demonstrate the desired step and select both.
  4. Drag the small square at the lower-right corner of the selection, then inspect Auto Fill Options.
  5. For an exact interval or endpoint, use Home > Fill > Series.
  6. If the handle is unavailable, check the fill-handle setting, sheet protection, merged cells, and the destination range.
  7. If formulas show stale outputs, check calculation mode separately.

Test the method on a few cells before filling a long column. This catches an incorrect step, date interpretation, or formula reference early. If a fill creates unwanted values, use Undo immediately or clear only the destination cells; avoid deleting the source data while diagnosing the behavior.

Frequently Asked Questions

Why does Excel repeat the same number when I drag? A single number can be treated as a value to copy. Enter two values that show the intended interval, select both, and drag, or choose Fill Series from Auto Fill Options.

How do I make Excel count by 10? Enter two starting values ten apart, such as 10 and 20, select both, and drag. For a specified range, use Home > Fill > Series and set the step value to 10.

Why does Excel repeat a date instead of moving to the next day? The selected cell may be copied, or the entry may be text rather than a real date. Use the Auto Fill Options button to choose a date fill behavior, or select Fill Series and specify a date unit.

Why does my formula show the same result after dragging? Check whether its references contain dollar signs, which lock a row or column, and whether calculation is set to Automatic. A fixed reference or a constant in the formula can make repeated results intentional.

Can I fill a series without dragging? Yes. Select the starting and destination cells, then choose Home > Fill > Series. You can specify the direction, series type, step, and stopping value in the dialog.

Why can I not see the fill handle? The fill handle may be disabled in Excel’s editing settings, or the current selection or protected worksheet may prevent the action. On Windows, check File > Options > Advanced > Enable fill handle and cell drag-and-drop.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

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

Spotted an error in this guide? Let us know.