Excel Copy Formula Drag Down Not Working? Try These Fixes

Errors & fixes · Updated November 19, 2026

If dragging a formula down in Excel does nothing, first check that the fill handle is enabled: go to File > Options > Advanced and turn on Enable fill handle and cell drag-and-drop. Then drag the small square at the lower-right corner of the selected cell; if the formula fills but its result does not change, check the cell references and calculation settings.

How dragging a formula down works

Excel’s fill handle copies a cell or continues a recognized series. When the cell contains a formula with relative references, Excel adjusts those references as it fills each row. This is why a formula that refers to the row above can produce a different result in each row without being rewritten manually.

For example, with quantities in A2:A4 and prices in B2:B4, enter 3 in A2 and 10 in B2, then put =A2*B2 in C2. That formula returns 30. Drag C2’s fill handle down one row and Excel normally changes the formula in C3 to use A3 and B3; if A3 is 4 and B3 is 8, the result is 32. The formula is copied, but its relative references move with it.

The fill handle is the tiny square in the selected cell’s bottom-right corner, not the cell border or the larger selection outline. When the pointer is directly over it, it changes to a small black plus sign. If the pointer instead looks like a four-headed arrow, you are positioned to move the cell rather than fill from it.

Check whether the fill handle is turned off

Excel has a setting that disables both the fill handle and cell drag-and-drop. If the square is missing, or dragging the cell corner has no effect anywhere in the workbook, this is the first setting to inspect in Excel for Microsoft 365 on Windows:

  1. Choose File > Options.
  2. Select Advanced.
  3. Under Editing options, select Enable fill handle and cell drag-and-drop.
  4. Choose OK, select a formula cell, and try its lower-right corner again.

On Excel for Mac, open Excel > Settings (called Preferences in some releases), choose Edit, and enable Allow fill handle and cell drag-and-drop if that option is shown. In Excel for the web, drag the fill handle from the selected cell; the desktop Options dialog and its Windows setting are not available there. If the handle is visible but difficult to grab, increase the worksheet zoom or select the cell carefully before dragging.

Use Fill Down when dragging is awkward

Dragging is not the only way to copy a formula down. The Fill Down command is useful when the destination range is long, the handle is hard to target, or the mouse drag keeps selecting the wrong cells. Select the formula cell and the blank cells below it, then choose Home > Fill > Down. Excel copies the top cell’s contents into the cells beneath it, adjusting relative references as appropriate.

For example, if C2 contains the formula and C3:C20 are the intended destinations, select C2:C20 before using Fill Down. The top cell must contain the formula you want to copy. On Windows, Ctrl+D runs Fill Down for the selected range; on Mac, use Command+D. These shortcuts work on the current selection, so check that it starts with the source formula and does not extend into unrelated columns.

If you want to fill only as far as neighboring data, double-click the fill handle rather than dragging. Excel usually uses the adjacent column’s continuous data to decide how far to fill. A blank cell in that neighboring data can stop the fill early, so inspect the last filled row. Double-click behavior depends on the surrounding layout; dragging or selecting a specific range and using Fill Down gives you more control.

Check relative and absolute cell references

A formula may fill successfully but appear not to work because its references are locked or move differently than expected. In a reference such as A2, both the column and row are relative. In $A$2, both are fixed; $A2 fixes the column only, while A$2 fixes the row only. Dollar signs are intentional when every copied formula should keep pointing to the same input.

For example, suppose C2:C4 contains totals of 30, 40, and 50, and E1 contains a tax rate of 10%. With totals in C2:C4 and the fixed tax rate in E1, enter =C2*(1+$E$1) in D2. It returns 33 when C2 is 30. Copying it to D3 changes the total reference to C3 but keeps the tax rate at E1, producing 44 when C3 is 40. If you omit the dollar signs around E1, the rate reference shifts as the formula is filled and may point to the wrong cell.

Click a filled cell and inspect the formula bar. If the row number has not changed where you expected it to, edit the original formula’s references and fill again. In a formula, select a reference and press F4 on Windows to cycle through absolute and relative reference styles. On some laptops, you may need the Fn key as well; keyboard behavior varies by device.

When the formula fills but the answer does not update

Sometimes the drag works: the formula appears in each destination cell, but the displayed answers stay the same or seem outdated. Check calculation mode under Formulas > Calculation Options. In most ordinary workbooks, Automatic is the expected setting. If the workbook is set to Manual, Excel may not recalculate formulas whenever inputs change. Choose Automatic, or press F9 on Windows to recalculate; on Mac, use Fn+F9 if the function keys are assigned to hardware controls.

Also distinguish a formula from text that looks like one. If a cell displays =A2*B2 instead of a result, the cell may be formatted as Text, the formula may begin with an apostrophe, or Formulas > Show Formulas may be turned on. Select the affected cell, change its number format to General from Home > Number Format, then press F2 and Enter on Windows to make Excel interpret the entry again. On Mac, use the equivalent edit-and-confirm keys for the keyboard layout. Changing the format alone does not always convert an already-entered text string into a working formula.

Look for layout and workbook restrictions

Some worksheet conditions can prevent a fill or make its result confusing. Check these before assuming the formula itself is broken:

  • Protected sheet: A protected worksheet can prevent edits to locked cells. Check Review > Unprotect Sheet; a password may be required. Only unprotect a sheet if you are authorized to change it.
  • Merged cells: A fill range that crosses merged and unmerged cells may not behave like a normal rectangular range. Unmerge cells where appropriate, or fill a consistent, unmerged range.
  • Non-adjacent selection: Ctrl-clicking separate ranges can leave a selection unsuitable for a straightforward fill. Select one continuous column range with the source formula at its top.
  • Existing contents: Dragging or filling can overwrite cells below. Check the destination range first, and use Undo immediately if an unintended overwrite occurs.
  • Filtered or hidden rows: The visible layout may conceal rows that are still part of a selected range. Verify the formulas in the actual destination cells, especially when filling a filtered list.

Excel tables also have their own behavior. In a table, entering a formula in a calculated column often propagates it through that column automatically. If that does not happen, check that the cells really belong to the table and that the column does not contain inconsistent formulas or manually entered values. You can still select a table-column range and use Fill Down, but confirm that the result preserves the intended table structure.

Choose the right fill method for the task

Dragging, Fill Down, and copying and pasting can all put a formula in multiple rows, but they suit different situations. Dragging is quick for a short, visible range. Fill Down is more precise when you know the destination range. Copy and paste is useful when the target cells are separated or on another part of the sheet, but it can also copy formatting and other cell properties depending on the paste method.

After using the handle, Excel may display an Auto Fill Options button near the filled range. Its choices can include copying cells, filling only the formatting, or filling without formatting; the available choices depend on the source and context. Choose the option that matches your goal. If you want the formula but not the source cell’s appearance, use the option to fill without formatting rather than manually undoing a series of format changes.

A useful distinction: dragging a formula normally copies the formula with adjusted references; dragging a number or date may continue a series, depending on the values and options selected. If Excel repeats a value when you expected a sequence, use the Auto Fill Options menu to choose the appropriate series or copy behavior. Formula copying and series filling are related features, but they are not the same operation.

A quick troubleshooting sequence

To identify the cause without changing many settings at once, work through this order:

  1. Select one formula cell and confirm that a formula, rather than plain text, appears in the formula bar.
  2. Look for the small square at the selection’s lower-right corner and test whether the pointer becomes a black plus sign.
  3. If the handle is unavailable, enable it in Excel’s editing options. If it is available but unreliable, select the destination range and use Fill Down.
  4. Inspect a filled formula to see whether relative references changed correctly and absolute references stayed fixed.
  5. If the formula is present but its displayed result is stale, check calculation mode and recalculate.
  6. If filling is blocked, check sheet protection, merged cells, the selected range, and existing destination contents.

This sequence separates three different problems: the fill action is unavailable, the formula is copied incorrectly, or the calculation is not refreshed. Identifying which one applies makes the fix faster and reduces the chance of overwriting good data.

Frequently Asked Questions

Why is the fill handle missing in Excel?
It is commonly disabled in Excel’s editing options. On Windows, check File > Options > Advanced > Editing options and enable Enable fill handle and cell drag-and-drop. If the option is enabled, make sure a cell is selected and look closely at its lower-right corner.

Why does dragging copy the same formula instead of changing the row?
The formula may use absolute references, such as $A$2, which stay fixed when copied. It may also contain mixed references that lock only a row or column. Inspect the formula in the next row and remove or reposition dollar signs if those references should adjust.

How do I copy a formula down without dragging?
Select the source formula and the destination cells below it, then choose Home > Fill > Down. On Windows, Ctrl+D is the shortcut; on Mac, use Command+D. Check the selection before filling because cells beneath the source can be overwritten.

Why does Excel show the formula instead of its answer?
Show Formulas may be enabled, or the cell may contain formula-looking text because it is formatted as Text or starts with an apostrophe. Check Formulas > Show Formulas, then inspect the cell format and re-enter the formula if needed.

Why does the formula copy down but the result stay the same?
Check whether the references are intentionally or accidentally fixed, then check Formulas > Calculation Options for Manual calculation. A formula can be copied correctly and still display an unchanged result until Excel recalculates it.

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.