Microsoft Excel Drag Formula Not Working? Fixes That Help

Errors & fixes · Updated November 20, 2026

If dragging a formula in Microsoft Excel does not fill the cells you expect, first check that you are pulling the small fill handle at the selected cell’s bottom-right corner, then confirm Excel has enabled the fill handle. On Windows, go to File > Options > Advanced and select Enable fill handle and cell drag-and-drop under Editing options; after that, check the formula’s references and the destination cells for other obstacles.

What Excel does when you drag a formula

Excel’s fill handle is the tiny square at the lower-right corner of a selected cell or range. Dragging it extends the cell’s contents into neighboring cells. With a formula, Excel normally adjusts relative cell references to match the new position. This is why dragging is useful for repeating a calculation down a list, but it can also produce an unexpected result if the formula uses references that should stay fixed.

For example, with a starting value in A2, enter =A2*1.1 in B2. Dragging B2’s fill handle down one row normally puts a formula equivalent to =A3*1.1 in B3. Excel changes the row reference because A2 is relative. If you grab the cell border instead of the fill handle, Excel may move the cell rather than fill a series; look closely for the small square before you drag.

Filling is different from calculating. Excel can place a formula into cells while showing an old result if calculation is set to Manual. Conversely, a formula may calculate correctly in its original cell but not be copied because the fill handle is disabled or the target range is blocked.

Check the fill handle and drag settings

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 choose OK. If the box was already selected, a quick check is to clear it, select OK, reopen the setting, turn it back on, and try again. This can help when dragging has stopped working after a settings change.

On a Mac, Excel’s settings are under Excel > Settings (called Preferences in some releases) > Edit. Look for the option that allows the fill handle and cell drag-and-drop, and enable it. Labels and window organization can differ by Excel release, so use the setting’s description if the wording is not identical. Excel for the web has a different interface and may not offer the same desktop options; if dragging remains unavailable there, use copy-and-paste or a fill command instead.

After changing the setting, select a cell and move the pointer over its lower-right corner. The pointer should change to a thin black cross when it is over the fill handle. If it stays as the usual selection pointer, reposition it precisely at the corner. A cell can be selected without the pointer being positioned on its handle.

Make sure the formula is really a formula

A formula must begin with an equals sign to be evaluated. If a cell displays something such as '=A2*1.1 or the formula appears as literal text, Excel is treating it as text rather than as a calculation. A leading apostrophe can force text entry, and a cell formatted as Text before the formula was entered can have the same effect. Dragging text may repeat text or create a series instead of extending a calculation.

Check the cell’s formula bar and number format. If the formula is text, change the cell format to General, then edit the cell and press Enter so Excel reinterprets its contents. Merely changing the format may not convert a formula that Excel has already stored as text. You can also delete the entry and type it again after setting the format. If many cells are affected, correct one cell first and then fill from that working formula.

Another clue is that the cells show the formula itself rather than a result. Excel’s Show Formulas view may be on; switch it off from the Formulas tab using Show Formulas. This display setting does not stop formulas from filling, but it can make a successful fill look like a failure. If only the result is stale, check Formulas > Calculation Options > Automatic on Windows. Changing calculation mode affects when results update, not whether the fill handle copies a formula.

Inspect references before filling down

When the formula fills but produces wrong answers, the drag operation may be working exactly as Excel designed. A relative reference changes as the formula moves. An absolute reference, marked with dollar signs, stays fixed. A mixed reference fixes only its column or row. Understanding these forms is especially important when a formula uses a shared rate, tax percentage, lookup value, or header.

For instance, with quantities in B2:B10 and a fixed price per unit in C1, enter =B2*C$1 in D2 and fill down. The row in B2 changes for each item, while row 1 in C$1 stays fixed. If both the column and row should stay fixed, use =B2*$C$1 for the calculation, where the quantity is in B2 and the fixed rate is in C1. These examples illustrate reference behavior; choose the reference that matches your own sheet.

To change a reference while editing a formula, select the reference and press F4 on Windows to cycle through relative, absolute, and mixed forms. On some Mac keyboards, you may need Fn+F4, depending on the keyboard’s function-key settings. You can also type the dollar signs directly. Before filling hundreds of rows, test the formula in the next row and confirm that its references shifted as intended.

Look for blocked cells, merged cells, and protection

Excel may refuse to fill into a range that cannot accept the operation. A worksheet protected against editing can prevent changes to locked cells. If you have permission to edit the workbook, use Review > Unprotect Sheet and enter the password if prompted. If the sheet belongs to someone else or is password-protected, ask its owner for access rather than trying to bypass the restriction.

Merged cells can also disrupt filling, particularly when the selected range and destination range do not have matching merged layouts. Unmerge the relevant cells if appropriate, or use a layout that keeps data cells unmerged. A spill range from a dynamic-array formula is another special case: Excel controls the output cells, so you cannot overwrite individual cells within that spill range. In that situation, edit the formula in the top-left cell or choose a different destination.

Check for existing content in the cells where the formula should go. A fill may overwrite data, or Excel may prompt before replacing it. Filtered lists and hidden rows can make the result appear incomplete or surprising because the visible sequence does not necessarily correspond to consecutive worksheet rows. If the exact rows matter, inspect the row numbers and consider filling a deliberately selected range rather than relying on a drag across a filtered view.

Use a reliable troubleshooting sequence

Try these checks in order, stopping when the formula fills correctly. Work in a copy of an important workbook if you are unsure whether a fill will replace existing entries.

  1. Select the formula cell and confirm the formula bar shows a real formula beginning with an equals sign, not text.
  2. Move the pointer to the cell’s bottom-right corner and drag the small fill handle, not the cell border.
  3. Check the fill-handle setting in Excel’s options, and enable it if it is off.
  4. Try filling into a blank, unmerged cell on an unprotected worksheet. This helps distinguish a general setting problem from a blocked destination.
  5. Inspect the resulting formula in the next row. If it is present but wrong, correct its relative, absolute, or mixed references.
  6. If the formula is present but its displayed answer has not updated, check the workbook’s calculation mode and recalculate.

To test calculation, press F9 on Windows to recalculate formulas in open workbooks; on Mac, the recalculation shortcut can depend on the keyboard and Excel settings. Do not treat recalculation as a fix for a formula that was never copied. If a short test range works but a large range does not, check for protected or merged cells, existing data, and workbook-specific restrictions along the drag path.

Ways to fill formulas without dragging

Dragging is convenient, but it is not the only way to copy a formula. If you know the destination range, select the formula cell and the blank cells below it, then use Home > Fill > Down. The Windows shortcut is Ctrl+D; Excel for Mac also commonly uses Control+D for Fill Down. Keyboard behavior can vary with system settings, so the ribbon command is a dependable alternative when a shortcut does not work.

You can also copy the formula cell, select the destination range, and paste. Excel adjusts relative references in copied formulas just as it does when filling. If a table is a good fit for the data, enter a formula in a calculated column and Excel may extend it through that table column automatically. Table behavior depends on the workbook’s settings and structure, so verify that the calculated column contains the intended formula.

For a long list with adjacent data, double-clicking the fill handle often fills the formula down to match the neighboring column’s data. It is a useful shortcut, not a guarantee: Excel uses nearby data to decide how far to fill, so gaps or an empty adjacent column can stop the fill early. Check the last filled row and the formula references before relying on the result.

Frequently Asked Questions

Why does Excel copy the same formula instead of changing the row?
If the reference is absolute, its row and column are locked with dollar signs, so it will not shift during a fill. If the formula is stored as text, Excel may also repeat the text rather than adjust a calculation. Check the formula bar and remove only the dollar signs that should not be fixed.

Why can’t I see the small square to drag?
The fill handle may be disabled under File > Options > Advanced on Windows, or the pointer may not be directly over the selected cell’s lower-right corner. Select a single cell and check the fill-handle setting. If you are using Excel for the web, try the ribbon’s fill or copy-and-paste options when desktop-style dragging is unavailable.

Why does dragging fill only part of my column?
Double-click fill uses neighboring data to determine the extent, and gaps can affect where it stops. A manual drag can also end before the last intended row. Select the full destination range and use Home > Fill > Down, then verify the final row.

Does dragging a formula change the original formula?
Ordinarily, filling downward leaves the source cell’s formula in place and creates formulas in the destination cells. Dragging the cell border instead can move the original cell, which is why it matters to grab the fill handle. Check the source and destination cells after the operation if the sheet’s layout is important.

Why did the formula fill but the answer stay the same?
The formula may reference fixed cells, may return the same result by design, or may not have recalculated yet. Inspect the formula in the filled cell first. Then check Formulas > Calculation Options > Automatic on Windows if results appear stale; calculation settings affect displayed results, not the copying action itself.

How to avoid the problem next time

Before filling a large range, test a formula in two or three rows and inspect the references in each result. Keep a clear, uninterrupted neighboring data column if you plan to use double-click fill, avoid merging cells inside calculation ranges, and use absolute references only for values that truly need to remain fixed. When a drag behaves unexpectedly, distinguish the three separate questions: did Excel copy the formula, did the references adjust correctly, and did the workbook recalculate? That simple check usually identifies whether the issue is the handle, the formula, the destination, or the displayed result.

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.