Excel Autofill Not Working? Fix Common Fill Handle Issues

If Excel Autofill is not working, first enable the fill handle under File > Options > Advanced, then check the pattern and cells you are filling. In Microsoft 365 for Windows, make sure Enable fill handle and cell drag-and-drop is checked, select the starting cell, and drag its small bottom-right corner across the destination range.

What Excel Autofill does—and what it does not

Autofill is the feature that extends data, formulas, dates, or formatting into nearby cells. Its small fill handle appears at the lower-right corner of a selected cell or range. Dragging it can copy a value, continue a recognizable sequence, or adjust cell references in a copied formula. Excel chooses what to do based on the selected cells and the pattern it can detect.

Autofill is not the same as Flash Fill. Autofill extends a series or copies cell contents; Flash Fill recognizes a text pattern from examples, such as extracting first names from full names. If the task is splitting or rearranging text, use Data > Flash Fill rather than expecting the fill handle to infer the transformation.

It is also different from typing a formula and expecting Excel to calculate it. If a formula copied correctly but its displayed result has not changed, the issue may be calculation settings rather than Autofill itself.

Check whether the fill handle is enabled

The most common reason the handle is missing or cannot be dragged is that its setting is turned off. In Excel for Microsoft 365 on Windows:

Choose File > Options.
Select Advanced.
Under Editing options, check Enable fill handle and cell drag-and-drop.
Choose OK, select a cell, and look for the small square at its lower-right corner.

This setting also controls cell dragging, so changing it affects more than series filling. If the box was already checked, click it off and back on, confirm the dialog, and check the selection again. The handle can be difficult to see at high zoom levels or when the active cell border blends into the worksheet, so inspect the exact lower-right corner of the selection.

On Excel for Mac, open Excel > Preferences (called Settings in some versions) > Edit and check the fill-handle and cell-dragging option. The wording or placement can vary slightly by release. Excel for the web has a fill handle when editing a worksheet, but it does not offer the full Windows desktop Options dialog; if you cannot find the relevant control, open the workbook in the desktop app.

Make sure the selection and drag direction are right

To fill downward, select a starting cell or range and drag the handle down; to fill across a row, drag it sideways. The handle belongs to the whole selection, not just the active cell within it. If you select a range of several cells, Excel may repeat that entire range, so check that the selection contains exactly the example or pattern you intend to extend.

It is easy to grab the cell border instead of the fill handle. When the pointer is over the correct corner, it changes to a small black plus sign in the Windows desktop app. If you see a four-headed arrow or the selection moves, you are dragging the cell or range, not filling it. Move to the precise lower-right corner and try again.

Also check whether the worksheet is protected. Protection can prevent edits to locked cells, including filling into the destination range. If Excel reports that the cell or chart is protected, ask the workbook owner for permission or use Review > Unprotect Sheet if you are authorized and have any required password. Do not assume the fill handle is broken when the real problem is that the destination cannot be edited.

Choose whether Excel should copy or continue a series

A frequent Autofill surprise is that Excel repeats a number instead of counting. If you drag a single cell containing 5, Excel normally copies 5 into the other cells. To establish a numeric step, enter at least two starting values, select both, and drag the handle. For example, selecting 4 and 6 before filling downward indicates a step of 2, so the next values are 8, 10, and 12.

Dates, weekdays, and months are often recognized as series. A single date may continue day by day; selecting two dates can establish a different interval. If Excel copies instead of continuing, or continues when you wanted a copy, use the Auto Fill Options button that appears by the filled range and choose the appropriate available option, such as Copy Cells or Fill Series. Options depend on the type of data and the fill operation.

For a reliable result, provide enough examples for Excel to infer the intended pattern:

For a sequence such as 10, 20, 30, enter the first two values and select both.
For a repeating label, select the label and fill; choose Copy Cells if Excel offers a different series behavior.
For alternating values such as Yes, No, Yes, No, select the complete two-cell pattern before dragging.
For dates that should advance by a week, enter two dates seven days apart, select them, then fill.

Autofill follows a pattern; it does not know the business meaning behind your data. Review the first few results before using a long filled range in a report or calculation.

Fix formulas that fill incorrectly

When you drag a formula, Excel normally adjusts relative references to match the new row or column. For instance, a formula that refers to the cell immediately to its left will generally keep referring to the cell immediately to its left as it is filled across. This is useful for repeated calculations, but it can look like Autofill has changed a formula unexpectedly.

Dollar signs make a reference absolute or partly absolute. In a formula, A1 is relative, $A$1 locks both the column and row, and $A1 or A$1 locks only one part. If every copied formula should use one fixed tax rate or lookup value, lock that reference before filling. Conversely, remove an unnecessary dollar sign if the reference should shift. Click a filled cell and inspect the formula bar to see whether the references changed as intended.

If the formulas are present but the displayed answers seem old, check Formulas > Calculation Options > Automatic. In Manual calculation mode, Excel may not recalculate results immediately after edits. Changing the calculation setting addresses stale results; it does not change whether the fill operation copied the formula.

Understand double-click filling and blank rows

Double-clicking the fill handle can quickly copy a formula or value down a column. Excel uses neighboring data to estimate how far to fill, so it is especially useful when a column beside the formula contains a continuous list of records. The fill commonly stops at the end of that adjacent data block. A blank row, an empty neighboring column, or gaps in the reference data can make the result stop sooner than expected.

If double-clicking fills only part of the intended range, drag the handle to the exact last row instead. You can also select the source cell and destination range and use Home > Fill > Down. On Windows, Ctrl+D fills the selected range downward, and Ctrl+R fills it to the right. In Excel for Mac, Control+D and Control+R are the corresponding fill shortcuts in many keyboard configurations; keyboard mappings can vary with macOS settings. These commands copy the top row or leftmost column through the selection rather than asking Excel to infer a series, so they are useful when you want a deliberate copy.

Check tables, filters, merged cells, and workbook limits

Some worksheet layouts complicate filling. Merged cells can make a rectangular destination range incompatible with the source selection, and a protected sheet may block changes. Try the operation in a small, ordinary unmerged range to determine whether the issue is the worksheet layout rather than the handle setting.

Filtered lists and hidden rows deserve extra care. A fill across a range can affect cells you do not currently see, depending on how the range is selected and the operation used. Check the destination and filter state before filling important data. If the task is to update only visible records, do not assume an ordinary drag will target only those visible rows; verify the selection behavior or use a method specifically suited to visible cells.

Excel tables can automatically propagate a formula through a calculated column, but that behavior is distinct from dragging the handle. If a formula does not appear throughout a table, confirm that the cells are actually part of the table and that the intended formula is entered in its data column. Avoid repeatedly dragging over a range before checking whether Excel already filled it, since that can overwrite existing values.

Use an alternative when dragging is inconvenient

The fill handle is only one way to populate cells. If it is hard to drag precisely, select the source and destination cells and choose Home > Fill > Down or Home > Fill > Right. The Windows shortcuts Ctrl+D and Ctrl+R are often faster for rectangular selections. For a sequence, enter enough starting values to establish the pattern, then use the handle or the Fill Series options available for that selection.

For text transformations, use Data > Flash Fill and provide an example in the adjacent column. For example, if full names are in column A and you type the first person’s first name in column B, Flash Fill may recognize the pattern and complete the remaining entries. Review its results because pattern detection can be wrong when names or formats are inconsistent. Flash Fill is a separate tool and does not replace formulas when you need results to update automatically as source data changes.

Frequently Asked Questions

Why is the fill handle missing in Excel?

Check File > Options > Advanced > Editing options and enable Enable fill handle and cell drag-and-drop. If it is already checked, confirm that a normal worksheet cell is selected and that the sheet is not protected. On Mac, look under Excel > Preferences or Settings > Edit.

Why does Excel copy the same number instead of counting?

A single numeric starting cell is usually copied. Enter two values that show the step you want, select both, and then drag the handle. For example, select 3 and 6 to continue in steps of 3. Use Auto Fill Options to switch between copying and filling a series when that choice is available.

Why does Autofill stop before the last row?

Double-click filling estimates its destination from adjacent data and may stop at a blank row or the end of a neighboring data block. Drag to the exact row or select the full destination range and use Home > Fill > Down.

Can Excel Autofill formulas automatically?

Yes. Dragging a formula’s fill handle copies it and normally adjusts relative references. Use dollar signs to lock references that should remain fixed, and check the formula bar in a filled cell to confirm the result. If results appear stale, check that calculation is set to Automatic.

Is Autofill the same as Flash Fill?

No. Autofill copies cells or extends a sequence, while Flash Fill detects a pattern in text examples, such as separating a first name from a full name. Use Data > Flash Fill for pattern-based text changes, and inspect the completed entries before relying on them.

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.