Excel Dragging Formula Not Working? How to Fix It

Errors & fixes · Updated November 19, 2026

If Excel will not drag a formula, check that the fill handle is enabled, then drag the small square at the selected cell’s bottom-right corner—not the cell border. If the formula copies but gives unexpected results, check calculation mode and whether its cell references should change as it fills.

How formula dragging is supposed to work

In Excel for Microsoft 365 on Windows, select the cell containing the formula and look for a small square in the lower-right corner of its selection border. That square is the fill handle. When the pointer is positioned over it, drag down or across the cells you want to fill. Excel copies the formula and adjusts relative references for each destination cell.

For example, with quantities in A2:A4 and prices in B2:B4, enter =A2*B2 in C2. If A2 is 3 and B2 is 5, C2 returns 15. Dragging the fill handle from C2 to C3 changes the formula to use A3 and B3; if those cells contain 4 and 6, C3 returns 24. This adjustment is normal: Excel treats A2 and B2 as relative references.

Dragging from the cell’s edge does something different: it moves the selected cell or range. If you see a four-headed arrow or a move cursor instead of the fill cursor, move the pointer to the tiny square in the corner. The distinction matters because both actions begin by pointing at the selection border.

Enable the fill handle in Excel options

If the small square is missing or cannot be dragged, Excel’s fill-handle setting may be off. In Excel for Microsoft 365 on Windows, open File > Options > Advanced. Under Editing options, select Enable fill handle and cell drag-and-drop, then choose OK. Return to the worksheet and try again.

This setting controls both dragging the fill handle and dragging cells to move them, so turning it on restores both behaviors. If the checkbox was already selected, do not assume the formula itself is the problem; check the other causes below. The option is an Excel application setting, so it may affect other workbooks you open in that Excel installation.

On a Mac, Excel’s settings are organized differently from Windows. Look in Excel > Settings (or Excel > Preferences in some releases) and open the editing settings to check the fill-handle and cell-dragging option. Excel for the web has a different interface and may not expose the same desktop options; if the handle is unavailable there, open the workbook in the desktop app and check its settings.

Use the fill handle rather than another drag action

Start with a single formula cell so the result is easy to inspect. Point precisely to the lower-right corner of its border, wait for the pointer to change to the fill indicator, then press and hold the mouse button while dragging across the destination cells. Release the button only after the intended range is highlighted. If you select several cells first, Excel may fill based on the pattern in that selection, which can be confusing when the cells contain different formulas.

If dragging is awkward, use a keyboard fill command instead. Select the formula cell and the cells below it, then press Ctrl+D on Windows to fill down. On Mac, use Control+D in Excel. To fill right, use Ctrl+R on Windows or Control+R on Mac. These commands fill the selected range from its top row or left column; they do not require the mouse or the fill handle.

There is also a ribbon route: select the source cell and destination range, then choose Home > Fill > Down or Home > Fill > Right. This is useful when dragging is inconvenient, such as on a touchpad or with a large range. The commands copy formulas in the same way as filling with the handle, so relative and absolute references still behave according to their reference types.

Check formula references when the result looks wrong

A formula can fill successfully and still appear broken because its references move. A reference such as A2 is relative: when copied one row down, it becomes A3. A reference such as $F$1 is absolute: both the column and row remain fixed. Mixed references, such as $F1 or F$1, lock only the column or row. These dollar signs are often the reason a formula works in its first row but not in later rows.

For example, with prices in A2:A4 and a tax rate of 8% in F1, enter =A2*$F$1 in B2. If A2 contains 100 and F1 contains 0.08, B2 returns 8. When filled down, the price reference changes to A3 or A4 while the tax-rate reference stays at F1. If you instead used =A2*F1, the second row would refer to F2, which may be blank or contain something else.

To check what Excel actually filled, select one of the destination cells and inspect the formula bar. You can also press F4 while editing a cell reference to cycle through relative, absolute, and mixed reference forms in Windows Excel. On many Mac keyboards, use Command+T to cycle reference types; depending on the keyboard, function-key settings can affect F-key behavior. If the intended references are already correct, investigate calculation or display settings instead.

Check calculation mode and formula display

Sometimes dragging changes the formulas correctly, but the displayed answers do not update. In Excel for Microsoft 365 on Windows, go to Formulas > Calculation Options and choose Automatic. In Manual calculation mode, Excel may wait for a recalculation before updating dependent results. Press F9 on Windows to recalculate open workbooks; on Mac, use Fn+F9 if the function keys are configured for system features.

Another common mix-up is seeing formulas in cells instead of their results. The Show Formulas command toggles formula display; on Windows, its shortcut is Ctrl+` (the grave-accent key, usually near the top-left of the keyboard). On Mac, use Control+`. Turn the command off or choose Formulas > Show Formulas to return to normal result display. A narrow column can also make a result look truncated, so widen the column before concluding that filling failed.

Check whether the formula cell is formatted as Text if Excel displays an entered formula literally or does not evaluate it as expected. Change the cell format to General or an appropriate number format, then re-enter the formula. Merely changing the format may not convert text already stored in the cell into a working formula; pressing F2 and then Enter after the format change can make Excel interpret the entry again.

Look for protection, merged cells, and table behavior

A protected worksheet may prevent edits in locked cells. If Excel reports that the cell or chart is protected, check Review > Unprotect Sheet if you have permission and the password, if one is required. Do not assume the workbook is damaged: protection is designed to block changes to specified cells. If only some destination cells are locked, the fill may stop or produce an error when it reaches them.

Merged cells can also interfere with filling because a merged area does not behave like a regular rectangular set of individual cells. If the source or destination overlaps merged cells, consider unmerging the relevant range through Home > Merge & Center and filling into ordinary cells. Preserve the layout first if other people rely on the merged formatting.

Inside an Excel table, a formula entered in a calculated column often propagates automatically to the other rows in that column. That can make dragging unnecessary, or it can appear that Excel is undoing a manual change because the table is keeping the column formula consistent. Check whether the range is a table by selecting a cell and looking for the table-related ribbon tab. For a normal fill operation, you can still use the fill handle, but inspect the entire calculated column afterward to confirm the formulas match your intent.

Why double-clicking the fill handle may stop early

Double-clicking the fill handle is a shortcut for filling a formula down alongside neighboring data. Excel uses adjacent populated cells to estimate how far to fill. If there is a blank in the neighboring column, or the adjacent data ends earlier than the intended destination, Excel may stop at that point. This does not necessarily mean the formula or fill handle is broken.

When the destination length matters, select the exact range yourself. For example, select C2:C100 with C2 containing the formula, then use Ctrl+D on Windows or Control+D on Mac. This avoids depending on the continuity of data in a neighboring column. If you do use the double-click shortcut, review the last filled row rather than assuming Excel inferred the range you had in mind.

A quick troubleshooting sequence

Work through these checks in order; each isolates a different kind of failure:

  • Confirm that a formula is present in the source cell and that you are pointing to the small square at the selection’s bottom-right corner.
  • Check File > Options > Advanced on Windows and enable fill-handle dragging if it is off.
  • Try filling a small range with Ctrl+D or Home > Fill > Down to separate a mouse issue from a formula issue.
  • Inspect a filled cell’s formula bar to see whether references changed as intended.
  • Check for Manual calculation, Show Formulas, Text formatting, protected cells, merged cells, or table calculated-column behavior.
  • If the workbook is open in a browser and the interface behaves differently, try the desktop version and verify the workbook is not read-only.

Save the workbook before making broad changes, especially if several users share it. If the issue happens only in one file, compare the same action in a blank workbook: if filling works there, the original workbook’s protection, structure, or settings are more likely involved. If it fails across workbooks, revisit Excel’s application options and input device behavior.

Frequently Asked Questions

Why is the fill handle missing in Excel?
On Windows, open File > Options > Advanced and make sure Enable fill handle and cell drag-and-drop is selected under Editing options. If it is enabled but the handle is hard to see, select a single cell and look closely at the lower-right corner of its border.

Why does dragging copy the formula but show the same answer?
Check whether the formula uses absolute references, whether the referenced values are actually different, and whether calculation is set to Automatic. Also make sure Show Formulas is off. A copied formula can be correct even when two rows happen to return the same result.

How do I copy a formula down without dragging?
Select the formula cell and the cells below it, then press Ctrl+D on Windows or Control+D on Mac. You can also choose Home > Fill > Down. Confirm that the selection begins with the cell containing the formula.

Why does double-clicking the fill handle stop before the last row?
Excel estimates the fill range from neighboring data. A blank or a shorter adjacent column can make it stop early. Select the exact destination range and use Fill Down when you need a specific ending row.

Does dragging a formula change the original formula?
No. Filling copies the formula into destination cells; it does not replace the source formula. Relative references adjust in the copies, while absolute references remain fixed. If the source itself changes, check that you are not dragging the cell border and moving the cell 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.