Excel Drag Formula Not Working: How to Fix It

Most tutorials will tell you the fix for Excel drag formula not working is buried in a settings menu. That's true maybe 30% of the time. The other 70%? The formula is dragging just fine — you're just not seeing the result you expected, and the reason is sitting right inside the formula itself.

I've watched people spend twenty minutes hunting through Options menus when the real problem was a single $ sign they didn't mean to put there. This guide works through the actual causes in the order you're most likely to need them, starting with the one almost no other article leads with.

---

What You'll Fix: Two Quick Checks Before You Touch Settings

This guide covers two distinct problems that both get called "Excel drag formula not working." First: the fill handle is missing or disabled, so you can't drag at all. Second: you can drag, but every cell shows the same value. Those are different problems with different fixes, and mixing them up is why most troubleshooting sessions run longer than they should.

Before anything else, confirm two things. One: are you on Excel desktop (Windows or Mac) or Excel Online? AutoFill in the browser-based version has real limitations the desktop app doesn't, and some fixes below simply don't apply there. Two: can you see the small green square at the bottom-right corner of a selected cell? That's the fill handle. If it's gone, start with Step 1 below, then come back here. If it's visible but dragging produces wrong results, skip straight to Step 2.

If you're running into broader formula issues beyond dragging, the common Excel errors and troubleshooting examples guide is worth bookmarking alongside this one.

---

Step 1: Turn On Automatic Calculation So Your Dragged Formula Actually Updates

Here's something that trips up people who've used Excel for years: if your calculation mode is set to Manual, dragging a formula down a column will copy the formula into each cell, but Excel won't bother recalculating any of them. Every cell shows whatever the first cell calculated back when it was last forced to update. In other words, the drag worked, but the results look identical because Excel is refusing to do the math.

To fix it, go to Formulas → Calculation Options → Automatic. That's it. If you want to confirm this is the issue before committing to the fix, press F9 to force a full recalculation. If your cells suddenly show different values after pressing F9, you've found your problem.

This is also the cause behind "Excel formula stays the same when dragged" complaints that flood the forums. The references are actually incrementing correctly. Excel just isn't recalculating them until you tell it to.

This is the first thing I check now. In my early corporate years, someone would hand off a file with Manual calculation turned on and I'd spend ten minutes checking references before it occurred to me to look at the Formulas tab.

---

Step 2: Fix the Real Reason Excel Drag Formula Isn't Incrementing Cell References

Once you've confirmed calculation is set to Automatic and the problem persists, the cause is almost certainly inside the formula itself, or it's a sheet-level restriction blocking the fill silently.

Check Whether Your Formula Uses Only Constants or Absolute References

Excel's AutoFill works by adjusting relative cell references as it moves down. If your formula references B2, dragging it down one row gives you B3. That's the behavior everyone expects. But if your formula references $B$2, dragging it produces $B$2 in every single row, locked intentionally, because the dollar signs tell Excel not to move. This is the single most common cause of "Excel drag formula copies same value," and it's almost never covered first.

Press Ctrl + ` (the backtick, top-left of most keyboards) to toggle Show Formulas mode. Scan down your filled column. If every cell shows the exact same formula text with no incrementing, that's your answer. Remove the $ signs from any reference you want to shift as you drag. Keep them only on references that genuinely need to stay fixed, like a tax rate sitting in cell F1.

A before/after comparison:

If you're newer to Excel and want a foundation before going deeper, the Excel for Beginners starter guide covers relative vs. absolute references from scratch.

Work Around Filtered Rows and Protected Sheets That Block Dragging

Two scenarios that almost no troubleshooting article covers: active filters and protected sheets.

If you're dragging a formula on a filtered list, Excel sometimes skips hidden rows or fills them inconsistently. The fix is to clear your filters first (Data → Clear), fill down, then reapply. Annoying, but reliable.

Protected sheets are even quieter about it. If the sheet is protected and the cells are locked, drag and drop simply won't work: no error, no message, nothing happens. Go to Review → Unprotect Sheet, then try again.

If you don't have the password, Ctrl+D to fill down or Ctrl+R to fill right are keyboard alternatives that sometimes work inside protected ranges depending on how the protection was set up. The same shortcuts apply on Mac.

---

Common Mistakes That Keep Excel AutoFill Broken After You've Run the Fixes

The most frequent post-fix mistake: you re-enable the fill handle in File → Options → Advanced → Enable fill handle and cell drag-and-drop, but calculation mode is still set to Manual. The fill handle works now, so you drag, and nothing updates. You're back at square one with a different explanation. Always check both.

1. Array formulas. Formulas entered with Ctrl+Shift+Enter lock into a range when entered. Dragging them doesn't extend the array the way you'd expect: it can produce errors or copy the formula without expanding it. If you see curly braces {} around your formula in the formula bar, that's an array formula. In Microsoft 365, dynamic arrays handle this differently than older Excel versions do, so if a fix works in one version and not another, array behavior is often why.
2. Excel Online. AutoFill support in the browser is limited compared to the desktop app. As of 2026, some drag-and-fill behaviors still don't work as expected in the browser, particularly with complex formulas. If you're hitting a wall in Excel Online, open the file in desktop Excel. The guide on Excel formulas not updating covers some of the Online-specific quirks in more detail.
3. Merged cells. If there are merged cells anywhere in the column you're trying to fill, AutoFill will either stop at the merge or throw an error. Unmerge, fill, then reformat if you need the visual. There's no clean workaround.

---