Excel Not Copying Formula When Dragging? How to Fix

Errors & fixes · Updated November 18, 2026

If Excel is not copying a formula when you drag, first check that the fill handle is enabled: in Windows, go to File > Options > Advanced and select Enable fill handle and cell drag-and-drop. Then select the formula cell and drag the small square at its bottom-right corner into the cells you want to fill. If the handle is enabled but the results are wrong, check the formula references and calculation settings next.

How formula dragging works

Excel’s fill handle is the small square at the lower-right corner of a selected cell or range. Dragging it extends the cell’s contents into neighboring cells. When the cell contains a formula, Excel normally copies the formula and adjusts relative references to match each destination. It does not simply repeat the displayed answer.

For example, with quantities in A2:A4 and unit prices in B2:B4, enter this formula in C2:

=A2*B2

If A2 contains 3 and B2 contains 12, the result in C2 is 36. Dragging the formula down one row normally puts a formula equivalent to A3 multiplied by B3 in C3. If A3 contains 5 and B3 contains 10, C3 returns 50. This automatic adjustment is useful for row-by-row calculations, but it can look like a copying failure if a reference should have stayed fixed.

Dragging the fill handle is different from dragging the cell border. The border moves or copies the cell itself, depending on the action and settings; the fill handle fills a range. If the pointer is on the border rather than the tiny corner square, Excel may move the cell instead of extending its formula.

Check whether the fill handle is enabled

In Excel for Microsoft 365 on Windows, open File > Options > Advanced. Under Editing options, check Enable fill handle and cell drag-and-drop, then select OK. If this option is off, the corner handle will not work as expected. This setting is separate from whether the cell contains a valid formula.

In Excel for Mac, look in Excel > Settings or Excel > Preferences > Edit for the fill-handle and cell-dragging option; the wording and exact location can vary by Excel release. Excel for the web has a different, browser-based interface, so if dragging is awkward, use the Home ribbon’s fill commands or copy and paste instead.

After changing the setting, click the formula cell once and look closely at its lower-right corner. The handle is small, so zoom level, a narrow column, or a touchpad can make it difficult to grab. Move the pointer directly over the square until it changes to the fill cursor, then drag across the destination cells. If the handle appears but does not respond, check whether the worksheet is protected or the cells are part of a merged range.

Drag the formula into the intended range

To fill a formula down, select the cell containing the formula, position the pointer on its bottom-right handle, and drag down through the last target row. To fill across, drag to the right or left. Release only after the intended destination cells are highlighted. A quick drag that starts on the cell border, or a selection that stops one row early, can make it seem as though Excel ignored the formula.

Double-clicking the fill handle can fill a formula down without manually dragging. Excel uses neighboring data to estimate how far the formula should extend, so this is most dependable when a nearby column has uninterrupted entries for every row. It may stop early or choose an unexpected length if that adjacent column contains blanks. Check the filled range before relying on it.

When Excel recognizes a sequence, the fill result may differ from a simple copy. For example, dates or numbers can continue as a series. If the Auto Fill Options button appears after dragging, open it and choose Copy Cells to repeat the contents rather than extend a sequence. For formulas, the usual behavior is to copy the formula while adjusting relative references, but the button can help clarify what Excel did.

If dragging remains inconvenient, select the formula cell and the cells below it, then use Home > Fill > Down. On Windows, Ctrl+D fills down from the top cell of the selected range; on Mac, Control+D works in Excel versions that support that shortcut. The ribbon command is a useful alternative when a mouse or touchpad makes the handle hard to control.

Check relative and absolute cell references

A formula can copy successfully but return an unexpected result because its references move. In a reference such as A2, both the column and row are relative. Filling down changes the row; filling right changes the column. This is generally what you want when each row uses its own inputs, as in the quantity-times-price example.

Use dollar signs to lock a reference that should not move. With the amount in B2 and a tax rate of 8% in D1, enter this in C2:

=B2*$D$1

If B2 is 100, the result is 8. When the formula is copied down, B2 becomes B3, but $D$1 remains fixed. A reference such as $D1 locks the column only, while D$1 locks the row only. In Excel, selecting a reference inside a formula and pressing F4 cycles through the reference styles on Windows; on some keyboards you may need Fn+F4. Mac keyboard behavior can vary, so adding or removing the dollar signs directly is a reliable alternative.

To inspect what Excel placed in a destination cell, select it and read the formula bar. Compare its references with the original formula. If the copied formula points to the wrong row or column, adjust the reference style rather than repeatedly dragging. A common misconception is that dragging should preserve every reference exactly; ordinary relative references are designed to change when copied.

Use fill commands, copy and paste, or an Excel table

The fill handle is not the only way to propagate a formula. Choose a method based on the shape of the data and how often the range changes:

  • Home > Fill > Down: Best when you know the exact destination range and want to avoid dragging.
  • Copy and paste: Copy the formula cell, select the destination range, and paste. Excel adjusts relative references just as it does when filling.
  • Double-click the handle: Convenient for a long list beside a continuous column of data, but verify where the fill stops.
  • Excel table: A calculated-column formula can automatically extend to other rows in the table, which is useful for data that grows over time.

To create a table, select the data and choose Insert > Table, confirming whether the range has headers. Enter a formula in a table column and Excel will typically treat it as a calculated column, applying the same formula pattern throughout that column. This behavior can be more dependable than dragging as new table rows are added. Tables also use structured references, which refer to column names rather than ordinary cell coordinates. If Excel does not extend a calculated-column formula, check that the cells belong to the table and that the table column has not been manually populated with inconsistent formulas.

Diagnose common reasons formulas do not fill

If the handle is available but filling fails or produces blanks, work through these checks. They distinguish a copying problem from a formula, worksheet, or display problem:

  • The sheet is protected: A protected worksheet can prevent edits in locked cells. Check Review > Unprotect Sheet if you are authorized to make changes; a password may be required.
  • The destination contains data: Dragging or filling can overwrite existing entries. Confirm the target range is empty or that replacing its contents is intended.
  • Cells are merged: Merged cells can interfere with selecting or filling a rectangular range. If practical, unmerge the affected cells and try again.
  • The wrong cells are selected: A fill command copies from the top row of a selected range. Confirm the formula cell is at the top before using Fill Down.
  • The formula is text: If Excel displays the characters of a formula instead of calculating it, the cell may be formatted as Text or the entry may begin with an apostrophe. Change the format to General, then re-enter the formula; changing the format alone may not convert an existing text entry.
  • A dynamic-array formula owns the range: In Microsoft 365, some formulas spill results into neighboring cells. Cells inside a spill range are controlled by the formula in its upper-left cell and cannot be edited independently. Check that area for a spill result before trying to fill over it.

Another clue is whether the fill operation changes the cell contents at all. If the destination remains empty, focus on the handle, selection, protection, and merged cells. If a formula appears but its result is wrong, examine references and calculation mode. If the same old result remains after a successful fill, calculation settings are a more likely cause.

Check formula display and calculation settings

Excel may be showing formulas rather than their calculated results. Choose Formulas > Show Formulas to switch between formula display and result display. Also check that the cell is wide enough: a narrow column can show #### for some values, although that does not mean the formula failed to copy.

If formulas are present but their answers do not update, go to Formulas > Calculation Options > Automatic. In Manual mode, Excel does not recalculate every formula immediately after an input changes. Pressing F9 recalculates open workbooks on Windows; Mac keyboard shortcuts can depend on the keyboard and system settings, so the Calculation Options menu is a straightforward check. Changing calculation mode affects the workbook environment, not the fill-handle setting.

For a focused check, select a destination cell and look at both the formula bar and its displayed value. A changed formula with a stale result points toward recalculation; no formula points toward the fill action or a restriction; an unexpected reference points toward relative-versus-absolute addressing. Separating these symptoms is faster than repeatedly dragging the same cell.

Frequently Asked Questions

Why does dragging copy the same number instead of a formula?
If the source cell contains a value rather than a formula, dragging may repeat that value or extend a recognized series. Select the source and inspect the formula bar. If it shows a formula, check the destination’s formula bar to see whether the references changed as expected.

Why does Excel copy a formula but show the same answer?
The formulas may be using absolute references, or the cells may display rounded values that look alike. Compare the actual formulas and underlying inputs. Also check Formulas > Calculation Options > Automatic if results are not recalculating.

How do I copy a formula without changing its references?
Use absolute references with dollar signs, such as $A$1, for the parts that must remain fixed. Alternatively, copy the formula as text only if that is genuinely what you need; normal formula copying is designed to adjust relative references.

Can I fill a formula down without using the mouse?
Yes. Select the formula cell and the destination cells, then choose Home > Fill > Down. Ctrl+D is the Windows shortcut; Control+D works in supported Mac versions. Make sure the formula cell is the first row of the selection.

Why does double-clicking the fill handle stop early?
Excel estimates the fill length from nearby data. A blank in the neighboring column or an inconsistent data block can make it stop sooner than expected. Drag to the exact last row or select the full range and use Fill Down instead.

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.