If an Excel formula will not fill down, first check whether Excel is treating it as a formula, whether the fill handle is enabled, and whether calculation is set to Automatic. You can also select the formula cell and the cells below it, then use Home > Fill > Down; on Windows, Ctrl+D does the same.
What Fill Down Should Do
Filling down copies a formula into the cells below it and normally adjusts relative references for each row. For example, if a formula in B2 refers to A2, a copy in B3 will usually refer to A3. This behavior is called relative referencing, and it is why one formula can calculate a result for every row in a list.
With quantities in A2:A4, a rate of 2 in E1, and the formula entered in B2, Excel can calculate each quantity multiplied by the fixed rate. The formula is:
=A2*$E$1
If A2 contains 10, the result in B2 is 20. When filled into B3, A2 changes to A3, while $E$1 stays fixed; if A3 contains 15, B3 returns 30. Dollar signs make a reference absolute, so it does not shift when copied. Knowing this distinction helps tell a genuine filling problem from a formula that copied correctly but now points to an unexpected cell.
Fill down is different from dragging a value or using Flash Fill. It copies cell contents and can adjust formulas, formats, or other cell properties depending on the operation. Flash Fill, found under Data > Flash Fill, recognizes patterns in text and is not a substitute for copying a formula.
Use the Reliable Fill Down Commands
When dragging the small square at the lower-right corner of a selected cell does nothing, use a command instead. Select the cell containing the working formula and the destination cells beneath it. Choose Home > Fill > Down, or press Ctrl+D in Excel for Microsoft 365 on Windows. The top cell is the source; Excel copies it into the remaining selected cells.
On a Mac, select the source and destination range and use Home > Fill > Down. The keyboard shortcut is Control+D on many Mac keyboards, though function and modifier keys can vary by keyboard settings. If the shortcut does not work, the ribbon command avoids shortcut conflicts. Excel for the web also offers Fill Down from the Home tab; if a command is not visible, use the ribbon search box to find it.
- To fill one column, select the formula cell and the cells below it in that column.
- To fill several columns, select the source row of formulas and the destination range below it, then use Fill Down.
- To copy only a formula without its formatting, use the Paste Options menu after copying, or choose the appropriate paste option from Home > Paste.
Check the last filled row before relying on the results. A command can fill farther than intended if the selection includes extra rows, while selecting only the formula cell leaves nowhere for Excel to copy it.
When the Fill Handle Is Missing or Inactive
The fill handle is the small square at the bottom-right corner of the active cell or selected range. If it is absent, or dragging it selects cells instead of filling them, the option may be disabled. In Excel for Microsoft 365 on Windows, open File > Options > Advanced. Under Editing options, turn on Enable fill handle and cell drag-and-drop, then select OK.
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. Menu wording can vary with the release. If the setting is already enabled, try the Home > Fill > Down command to determine whether the issue is specifically dragging or filling itself.
Dragging may also seem unreliable when the worksheet is zoomed far in or out, when the selection is very small, or when the pointer is not over the handle. Move the pointer to the square at the cell corner and wait for the fill cursor before dragging. If you want to fill down through neighboring data, double-clicking the handle can extend the formula to the adjacent data region, but it may stop at a blank row or follow a neighboring column with a different length. Select a precise destination range when the endpoint matters.
Check Whether the Formula Is Stored as Text
A formula that appears literally in a cell, such as =A2+B2, may be stored as text instead of being calculated. This commonly happens if the cell was formatted as Text before the formula was entered, or if an apostrophe was typed before the equals sign. Filling a text entry down copies text; it does not turn it into a working formula.
To fix one affected cell, change its number format to General using Home > Number Format > General, then edit the cell and press Enter. A practical way to re-enter it is to select the cell, press F2, and then press Enter on Windows. On a Mac, use the equivalent edit-cell key for the keyboard configuration, or click the formula bar, confirm the formula begins with an equals sign, and press Return. Merely changing Text to General may not recalculate content that was already entered as text; re-entering the cell is important.
If formulas appear instead of results throughout the worksheet, check whether Show Formulas is on. On Windows, Ctrl+` toggles formula display; the grave-accent key is often near the number 1 key. You can also check Formulas > Show Formulas. On a Mac, use the Show Formulas command on the Formulas tab if the shortcut differs on your keyboard. This setting changes what is displayed, not the formulas themselves.
Verify Calculation and Formula References
Sometimes the formula has filled down correctly but the displayed results have not updated. In Excel for Windows, choose Formulas > Calculation Options > Automatic. If calculation is set to Manual, edits may not trigger an immediate recalculation. Press F9 to recalculate open workbooks; on a Mac, the relevant function-key shortcut may require the Fn key, depending on system settings. Calculation options apply to the Excel session and can affect other open workbooks too.
Next, inspect a formula in the middle and at the bottom of the filled range. Relative references should usually move with the row, while absolute references marked with dollar signs remain fixed. A mixed reference, such as $A2 or A$2, locks only the column or row. If a copied formula returns the same result on every row, that may be correct when it uses a fixed reference; if it should use a different row, review the dollar signs and the original formula.
Also check for errors such as #REF!, which indicates a reference is invalid, or #DIV/0!, which can occur when a formula divides by zero or a blank cell. Filling down does not repair bad source logic. Compare the formula with the intended calculation and inspect the referenced cells rather than repeatedly dragging it.
Look for Worksheet and Data Constraints
A protected worksheet can block edits to locked cells. Check Review > Unprotect Sheet. If the sheet requires a password, you need the password or assistance from the workbook owner; there is no appropriate fill command that bypasses protection. In shared or managed workbooks, confirm that you have permission to edit the range.
Merged cells can prevent a selection from behaving like a regular rectangular range. If Excel reports that the operation cannot be performed on merged cells, inspect the target area and consider unmerging cells using Home > Merge & Center > Unmerge Cells, if changing the layout is acceptable. Filling into a merged range is not equivalent to filling ordinary individual cells.
Excel tables have their own formula behavior. In a table column, entering a formula in one row often creates a calculated column and propagates the formula to other rows automatically. If it does not, check whether the range is actually an Excel table, whether calculated columns are enabled, and whether the formula column contains inconsistent entries. You can still use Fill Down in a table when appropriate, but avoid overwriting different formulas or intentionally customized rows.
Blank rows can also affect a double-click on the fill handle: Excel uses adjacent data to guess how far to extend, so a gap may stop the fill early. Selecting the exact destination range and using Ctrl+D or Home > Fill > Down is more predictable.
Diagnose the Symptom Before Repeating the Fill
Look at what happens immediately after the attempt. If nothing changes, suspect a disabled handle, a protected sheet, or an invalid selection. If the formula is copied but every row shows the same result, inspect absolute references and calculation mode. If the cell displays formula characters, check the Text format, a leading apostrophe, and Show Formulas. If Excel fills only partway, check for blank rows or an imprecise selection.
Undo the last operation with Ctrl+Z on Windows or Command+Z on Mac if it changed the wrong cells. Then select a small test range, fill it, and inspect the formulas before applying the operation to thousands of rows. This reduces the chance of overwriting values or formulas that were deliberately different. For a high-stakes workbook, save a copy first and compare a few calculated results with a manual check.
Frequently Asked Questions
Why does Excel copy the same formula instead of changing the row?
Check the references in the formula. References with dollar signs, such as $A$2, are absolute and remain fixed when copied. Remove the relevant dollar sign if that row or column should shift. Also check whether the formula is text rather than a calculated formula.
Why does dragging the fill handle copy a number instead of continuing a series?
Dragging can copy a value or extend a series depending on the selected cells and Excel’s interpretation. For a predictable formula copy, use Fill Down. For a numeric series, enter two starting values, select both, and drag the handle; Excel can use the difference between them to infer the pattern.
Why does double-clicking the fill handle stop early?
Double-click fill uses neighboring data to estimate the range. A blank row or a shorter adjacent column can make Excel stop before the intended last row. Select the full destination range and use Home > Fill > Down instead.
Will Ctrl+D fill down on a Mac?
Excel for Mac commonly uses Control+D for Fill Down, but keyboard settings can affect how modifier and function keys behave. The dependable alternative is selecting the range and choosing Home > Fill > Down.
Why do I see the formula instead of its answer?
The cell may be formatted as Text, the formula may have a leading apostrophe, or Show Formulas may be enabled. Check the cell format and re-enter the formula after changing it to General, then confirm Show Formulas is off if formulas are displayed across the sheet.
Related
- Excel Data Validation List: Can You Select Multiple?
- Excel Data Validation List: Remove Duplicates
- Excel Data Validation List Search: Setup and Fixes Guide
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Excel Unable to Remove a Page Break? Find the Right FixIf Excel will not remove a page break, first check whether it is manual or automatic: select the…
- Excel Formula Not Calculating? Fix the Common CausesIf an Excel formula is not calculating, first check Formulas > Calculation Options > Automatic, then check whether…
- Excel VLOOKUP Not Working? Fix the CauseIf VLOOKUP is not working in Excel, check that you are using the right match mode, that the…
- Bing Chat Excel Formula Not Working? Fixes That HelpIf a formula from Bing Chat is not working in Excel, check that it begins with an equals…
- Why Is My IFERROR Formula Not Working in Microsoft Excel?Your IFERROR formula usually appears not to work because Excel is not evaluating the formula you think it…
- Excel SUM Not Working? Fix Common Formula ProblemsIf Excel SUM does not work, first check that the formula starts with an equals sign, covers the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.