Excel may not drag a formula down when the reference is locked, the fill handle is disabled, the cells are merged or filtered, or the formula is stored as text. If you miss the cause, you copy the wrong value or no formula at all. This guide matches each failure to the fix, from F4 and cell formatting to tables, filters, and workbook settings.

What the symptom means

What the symptom means
A hand points at a spreadsheet on a computer screen

You are trying to copy one formula down multiple rows, but Excel is not extending it the way you expect. First, look for the tiny square fill handle in the lower-right corner of the selected cell. Then drag down or double-click it. If that still fails, use copy and paste or Fill Down.

Excel uses AutoFill to copy formulas and patterns down a range. With normal relative references, the references shift as the formula moves down. With absolute cell references, the $ signs keep a row or column fixed. Excel for the web and desktop Excel can both support formulas, so the problem is usually the sheet state or the formula setup, not the app itself.

Likely causes

  • Most often: the fill handle or drag-and-drop setting is turned off in Excel options.
  • Commonly: the worksheet is protected, or the target cells are locked on a protected sheet.
  • Often: merged cells interrupt drag-to-fill.
  • Sometimes: the formula uses the wrong mix of relative and absolute references.
  • Sometimes: the data range ends at a blank row, filtered row, or table boundary.
  • Less commonly: the formula is entered as text, so Excel treats it like a label instead of a calculation.

Why won't Excel let you drag formula?

If Excel will not let you drag at all, the fill handle is often hidden or disabled, or editing is blocked on the sheet. The fastest check is to click a cell and look for the tiny square at its bottom-right corner. If it is missing or inactive, turn the setting back on, then check sheet protection next.

  1. Go to File > Options > Advanced.
  2. Under Editing options, turn on Enable fill handle and cell drag-and-drop.
  3. Select the formula cell again and look for the small square in the corner.
  4. If the handle appears but still will not move, go to Review > Unprotect Sheet.
  5. If the sheet asks for a password, enter it or ask the file owner to remove protection from the worksheet.

Suppose a formula in B2 will not drag to B20, but the same workbook lets you copy other cells. That points to a setting or sheet restriction, not a bad formula. A common first-timer mistake is checking the formula first, when the handle itself is disabled.

Why does the formula change wrong when you drag it?

When the result changes the wrong way, the formula is usually copying correctly but the references are not set the way you want. Relative references shift as you fill down. Absolute references stay fixed. Mixed references lock only the row or only the column, which is useful when only one part should move.

  1. Click the source formula and inspect each reference in the formula bar.
  2. Press F4 on a selected reference to cycle through relative, absolute, and mixed forms.
  3. Use $A$1 when the reference must never move.
  4. Use A$1 or $A1 when only one direction should stay fixed.
  5. Drag the fill handle down again and compare one copied row to the row above it.

Picture a formula in C2 that should always read tax rate from F1. If you drag it down and the reference becomes F2, F3, and F4, the fix is not a new tool. It is an absolute cell reference, such as $F$1, so every copied row points to the same cell.

Why does the formula stop at certain rows?

AutoFill can stop when the range has blanks beside it, when the sheet has a filtered list, or when the data is inside an Excel Table with its own fill behavior. Double-clicking the fill handle also depends on adjacent data. If the neighboring column has gaps, Excel may stop at the first break.

  1. Check the column next to the formula range for blank cells in the middle of the data.
  2. Remove or fill the gap, then double-click the fill handle again.
  3. If the range is filtered, clear the filter from Data > Sort & Filter > Clear.
  4. If the data is in a table, click inside it and use the table’s auto-fill behavior instead of dragging manually.
  5. For a plain range, try dragging the fill handle to the last visible row rather than relying on double-click.

Say your sales total formula fills down to row 18 and then stops. If rows 19 to 30 are blank in the adjacent column, Excel may treat row 18 as the end of the region. Filling the missing cells or using a table usually solves that boundary problem.

Sheet protection, filters, and hidden rows

Protected worksheets, filters, and hidden rows can all make drag behavior look broken, but they do not fail in the same way. A protected sheet blocks editing in locked cells. A filter can make it seem as if rows were skipped. Hidden rows are less often the main cause, but they can still confuse a fill action if you expect every row to show the same result.

  1. Go to Review > Unprotect Sheet and remove protection if the option is available.
  2. If cells remain locked after removing protection, select the range, then open Home > Format > Format Cells > Protection and check the lock state before protecting again.
  3. Clear filters from Data > Sort & Filter > Clear so every row is visible.
  4. If rows are hidden, select the full range and choose Home > Format > Hide & Unhide > Unhide Rows.
  5. Try the fill action again on an unfiltered, fully visible range.

Formula drag troubleshooting matrix

Formula drag troubleshooting matrix
A laptop displays a spreadsheet on a sunlit desk beside a coffee cup
Symptom Likely cause Quickest test Best fix
No small square at the cell corner Fill handle is disabled in Excel options Open File > Options > Advanced and check Editing options Turn on Enable fill handle and cell drag-and-drop
Pointer changes, but nothing fills Worksheet is protected Try Review > Unprotect Sheet Remove protection from the sheet or allow editing in the target cells
Drag stops at a merged block Merged cells interrupt AutoFill Click inside the area and look for merged formatting Unmerge the cells, fill, then reapply layout if needed
Formula copies, but references do not move as expected Absolute references are fixed with $ signs Inspect the formula bar for $ symbols Change the reference to relative or mixed form as needed
Fill stops at a blank row Adjacent data range has a gap Check the next column for blanks Fill the gap or drag manually past it
Double-click fill ends early AutoFill follows the adjacent data region Compare the stopping row with the neighboring column Remove blanks or use drag instead of double-click
Rows seem skipped Filter is hiding part of the list Use Data > Sort & Filter > Clear Clear the filter, then fill the full range
Formula works in one area but not in a table Excel Table uses structured behavior Click inside the table and enter the formula in one row Use the table’s auto-fill or structured references
Only some rows update after paste Hidden rows or filtered rows are in the range Show all rows and repeat the action Unhide rows or clear filters before copying
Dragging does nothing, but copy and paste works Drag action is blocked while clipboard copy is allowed Try Ctrl+C then Ctrl+V on two rows Use paste, Fill Down, or a table instead of dragging

Still not working?

Still not working?
An Excel worksheet screenshot shows formula errors and a highlighted menu

If dragging still fails after the settings and reference checks, switch to a method that does not depend on the fill handle. Select the source cell and the target range, then press Ctrl+D to fill down. Or use Home > Fill > Down for the same result. Those paths are often safer in protected, filtered, or table-based sheets.

  1. Select the source formula and the rows below it.
  2. Press Ctrl+D to fill down the selection.
  3. If the range repeats often, convert it to an Excel Table from Insert > Table.
  4. Enter the formula once in the first table row and let the table extend it.
  5. If the formula still misbehaves, copy the cell and paste it row by row to compare the result against the source formula.

Excel templates can help when the same layout and formulas keep returning. Microsoft describes templates as including formulas, structured labels, charts, and data visualizations. For quick formula work in a browser, Excel for the web is free for create, edit, and share use cases, and it includes core formula features for everyday spreadsheet work. Microsoft also positions Copilot in Excel as a way to understand data and generate formula suggestions.

Prevention is simple here: use a table for repeating formulas, and lock only the cells that should stay fixed before you protect the sheet.

Keep reading

Frequently asked questions

Why is excel not dragging down formula?

Start with the three checks that fail most often: the fill handle setting, sheet protection, and the formula itself. Go to File > Options > Advanced to confirm drag-and-drop is enabled, then use Review > Unprotect Sheet if editing is blocked. If the formula uses $ signs, fix those references before trying again.

Why I can't drag formula in excel

If you cannot drag at all, the problem is usually the interface or the sheet state, not the calculation. Look for the small square at the cell corner, then confirm Enable fill handle and cell drag-and-drop is on. If the sheet is protected, remove protection or unlock the destination cells first.

Why won't my formula drag in excel

When drag fails in one area but not another, compare the data around the range. A blank row, merged cells, or a filter can stop AutoFill early. Use Data > Sort & Filter > Clear to remove filtering, then try Ctrl+D on a selected block if dragging still fails.

Why won't excel let me drag formula

Excel can refuse the drag action when the fill handle is turned off or the worksheet is protected. Check File > Options > Advanced first, then open Review > Unprotect Sheet. If the cells are merged, unmerge them before trying again, because merged cells often break drag-to-fill behavior.

When dragging down a formula in excel

When dragging down a formula in Excel, relative references should shift and absolute references should stay fixed. If the result is wrong, press F4 on the reference in the formula bar to cycle through the reference types. That is the fastest way to correct a copied formula without rewriting the whole expression.