Excel Not Dragging Down Numbers? Fix the Fill Handle

If Excel repeats a number instead of counting up, select the first two numbers in the pattern and drag the fill handle down; Excel can use them to infer the series. If you have already dragged one number and it copied instead, open Auto Fill Options and choose Fill Series.

First, check what Excel is filling

Excel treats copying a value and extending a number series as different actions. When you drag from a single cell containing a number, Excel often copies that number into the cells below. For example, dragging a cell containing 5 may produce 5, 5, 5, 5. That is not necessarily a malfunction: Excel has only one value to go on, so it cannot know whether you meant 6, 7, 8 or a repeated 5.

To show the intended pattern, enter the first two values before dragging. Put 5 in A1 and 6 in A2, select both cells, then drag the small square at the bottom-right corner of the selection down. Excel continues with 7, 8, 9. The same idea works for other regular steps: starting with 10 and 20 produces 30, 40, 50 when extended.

This distinction also explains a common misconception: dragging down does not always mean “add one.” The result depends on the selected starting values and the fill option Excel uses. A repeated value is a copy; a sequence is a series.

Use the fill handle correctly

The fill handle is the small square on the lower-right edge of a selected cell or range. Move the pointer over it until the cursor becomes a thin black plus sign, then drag down over the destination cells. If you drag from the cell border instead, Excel may move the cell or selection rather than fill it.

Enter at least two starting numbers in consecutive cells, such as 1 and 2.
Select both cells, not just the last one.
Point at the selection’s bottom-right fill handle until the pointer changes.
Drag through the cells you want to populate, then release.
Check the final values before using them in calculations or reports.

For a pattern with a different interval, enter two values that show the interval. For example, 3 and 8 establish a step of 5, so the next values are 13 and 18. A pattern with an alternating rule may need more starting values: entering 1, 2, 1, 2 and selecting all four gives Excel more evidence than selecting only 1 and 2.

Choose Fill Series after dragging

If you dragged a single number and got repeats, you may not need to undo and start again. After the drag, Excel displays the Auto Fill Options button beside the filled cells. Select it and choose Fill Series to turn the copied values into a sequence. Choose Copy Cells when you want the original value repeated. The available choices can vary with the type of data being filled.

If the Auto Fill Options button is not visible, select the filled range and use the ribbon instead. In Excel for Microsoft 365 on Windows, go to Home > Editing > Fill > Series. In the Series dialog, choose whether the series should run in rows or columns, select Linear for a constant step, and set a step value if needed. For a simple count upward by one, a step value of 1 is appropriate. Confirm the dialog to fill the selected range.

Fill Series is useful when a column needs a long count or a specific interval and you want to avoid relying on a drag gesture. Make sure the selected range starts at the intended first cell. A fill command writes into the selected destination cells, so selecting the wrong range can replace existing entries.

Fill down without dragging

Dragging is not the only way to copy or extend data. To copy the top cell’s content into the cells below, select the source cell and the destination cells, then use Home > Fill > Down. On Windows, Ctrl+D is the shortcut for Fill Down; on Mac, the equivalent is Command+D. This copies the top cell’s contents and formatting downward. It does not automatically turn one number into a counting series.

For a sequence, select the cells to be filled and use Home > Fill > Series, or enter two seed values and use the fill handle. This distinction matters when filling formulas too: Fill Down copies the formula pattern, while a series fill creates values according to the series settings. If you need the same formula adjusted for each row, Fill Down is often the right tool; if you need consecutive labels, use a number series.

Another option is to type the required values directly, especially for a short list or a sequence with exceptions. This is slower for hundreds of rows but can be safer when the pattern is irregular or when identifiers must be checked carefully.

Use a formula when the sequence needs to stay connected

A formula can create a count that updates from the value above it. With 1 in A1 and a formula entered in A2, the formula =A1+1 returns 2. Fill that formula down and the relative reference adjusts, giving 3 in A3, 4 in A4, and so on. This is useful when a sequence should respond if its starting value changes.

Formulas can also explain why a filled column appears to repeat. If every row contains a reference that is locked to the same cell with dollar signs, each formula can return the same value. For a changing reference, the row reference should usually remain relative. Select a suspicious cell and inspect the formula bar to see whether the reference changes as expected.

Calculation settings are another possibility when formulas do not show updated results. In Excel for Windows, check Formulas > Calculation Options and select Automatic if the workbook is set to Manual. This setting affects recalculation; it does not change the basic behavior of the fill handle. Do not switch calculation modes casually in a workbook used for important financial models, because manual calculation can leave other formulas displaying old results too.

Troubleshoot a fill handle that does nothing

If dragging does not fill cells at all, check the setting that enables the fill handle. 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. If it is off, Excel will not show or use the handle as expected.

Also check the mechanics of the selection. Confirm that you selected the cell or seed range, not an entire row by mistake, and that you are dragging the square at the lower-right corner rather than the border. If the worksheet is protected, editing may be restricted. Merged cells in the target area can also interfere with filling a regular column range; unmerge them if appropriate, keeping in mind that unmerging does not restore any values that may have been removed during the merge.

It copies one number: Select two seed numbers or use Auto Fill Options > Fill Series.
The handle is missing: Check the fill-handle setting in Excel Options.
The values look identical: Check the formula bar and number format; the underlying values may differ even if the display does not.
It changes the wrong cells: Undo immediately with Ctrl+Z on Windows or Command+Z on Mac, then reselect the intended range.

Check formats, formulas, and number-like text

Sometimes Excel has filled the cells correctly, but the display makes it look as if nothing changed. A custom number format can hide digits or show values in a rounded form. Select a few cells and inspect the formula bar, or temporarily choose a more informative number format from Home > Number. For example, values 1.1 and 1.4 may both appear as 1 if the cells display zero decimal places, even though they are different underneath.

Look at the formula bar when a column contains formulas. A displayed result can repeat because the formulas point to the same source or because the calculation has not updated. If the cells contain plain values, check whether they are stored as text. Codes such as 001, product IDs, and postal codes may need to retain leading zeros, so Excel may treat them as text rather than as numbers. Filling text often copies it rather than incrementing it, and converting codes to numeric values can remove meaningful zeros.

For dates, enter two dates if you want to make the interval clear, such as consecutive days or the same date in consecutive months. Excel recognizes many date patterns, but a single date can be copied depending on the chosen fill option. Review the result before relying on it, especially when the intended pattern skips weekends or uses a business calendar.

Excel for Mac and Excel for the web

The fill-handle concept is similar across Excel platforms, but settings and menus can differ. In Excel for Mac, check Excel > Settings (or Preferences in some releases) > Edit for the option to allow the fill handle and cell drag-and-drop. The exact wording and placement can vary by release. Command+D is the Mac shortcut for Fill Down; Windows uses Ctrl+D.

Excel for the web also supports filling cells by dragging the fill handle, and the Home ribbon provides fill commands. If a workbook behaves differently in a browser, open it in the desktop app to check whether a platform-specific setting or workbook restriction is involved. Avoid assuming a missing desktop option is broken: some settings and dialog choices are arranged differently in the web interface.

Frequently Asked Questions

Why does Excel repeat the same number when I drag down?
When you drag from one numeric cell, Excel may copy that value because one starting point does not establish a counting pattern. Select two values that show the intended interval, or use Auto Fill Options and choose Fill Series.

How do I make Excel count by one?
Enter 1 and 2 in adjacent cells, select both, and drag the fill handle down. Excel should continue with 3, 4, and 5. You can also use Home > Fill > Series and set a linear step of 1.

Why is there no small square to drag?
The fill handle may be disabled. In Windows Excel, go to File > Options > Advanced and turn on Enable fill handle and cell drag-and-drop. On Mac, look in Excel > Settings or Preferences > Edit.

Does Ctrl+D make a number series?
No. Ctrl+D on Windows fills down by copying the top cell’s content into the selected cells. On Mac, use Command+D. To extend a numeric series, use two seed values, the fill handle, or the Series command.

Can I fill a sequence that skips numbers?
Yes. Enter two values that establish the interval, such as 10 and 15, select both, and drag down to continue 20, 25, 30. For a pattern that changes intervals or alternates, provide enough starting values to make the intended pattern clear, then verify the results.

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.