Excel Not Letting Me Drag Formulas? Fix the Fill Handle

Errors & fixes · Updated November 18, 2026

If Excel will not let you drag a formula, first check that the fill handle is enabled: go to File > Options > Advanced, then under Editing options select Enable fill handle and cell drag-and-drop. If it is already enabled, check that you are dragging the small square at the selected cell’s lower-right corner, rather than the cell border, and look for sheet protection or merged cells that may block filling.

What dragging a formula is supposed to do

The fill handle is the small square at the lower-right corner of a selected cell or range. Dragging it across neighboring cells copies the contents or continues a pattern. When the source cell contains a formula, Excel normally copies that formula and adjusts relative references for each destination.

For example, with a quantity in A2 and a unit price in B2, enter the formula below in C2. It assumes A2 contains 3 and B2 contains 12, so the result in C2 is 36. Dragging the fill handle from C2 to C3 copies the calculation, adjusting the references to A3 and B3.

With quantity in A2 and unit price in B2, enter this in C2: =A2*B2.

Dragging is different from selecting a cell and moving its border. Dragging the border moves the selected cell contents; dragging the small corner handle fills adjoining cells. If you see a four-headed arrow or a move cursor, you may be on the border. Move the pointer to the tiny square until the pointer changes to a thin black plus sign, then drag.

Turn the fill handle back on

In Excel for Microsoft 365 on Windows, open File > Options > Advanced. Under Editing options, make sure Enable fill handle and cell drag-and-drop is checked, then choose OK. This option controls both filling with the handle and dragging cells by their edges, so turning it off can make the expected corner-drag behavior disappear.

On Excel for Mac, open Excel > Preferences > Edit and enable the fill-handle and cell-dragging option. Depending on the Mac Excel release, the menu may be labeled Settings rather than Preferences. Excel for the web does not use the same Windows Options dialog; use the fill commands or keyboard shortcuts if dragging is unavailable there.

If the checkbox is already selected, close and reopen the workbook after changing it, and test in a blank worksheet. A quick test helps distinguish an application setting from a restriction or layout issue in the particular sheet.

Drag the handle the right way

To fill a formula down, select its cell, point at the lower-right corner until the pointer becomes the black plus, and drag through the destination cells. To fill across, drag the same corner to the right or left. When you release the mouse, Excel applies the formula to the selected range.

After a fill, the Auto Fill Options button may appear near the bottom of the filled range. It lets you choose options such as Copy Cells or Fill Series, depending on what you filled. For formulas, copying generally gives the expected result; for dates or numbered labels, the choice can determine whether Excel repeats the first value or continues a sequence.

Double-clicking the fill handle is another option when a column beside the formula has uninterrupted data. Excel uses that neighboring data to estimate how far down to fill. It can stop at a blank in the adjacent column, and it may fill farther or shorter than intended if the surrounding data has gaps. Review the filled range rather than assuming the double-click reached the last row you need.

Use Fill Down when dragging is awkward

You do not have to use the mouse. Select the formula cell and the cells below it, then press Ctrl+D on Windows to fill down. On Mac, Control+D is the usual Fill Down shortcut. For a horizontal range, select the source cell and cells to its right, then use Ctrl+R on Windows or Control+R on Mac to fill right.

The ribbon provides a mouse-based alternative: select the source and destination cells, then choose Home > Fill > Down or Home > Fill > Right. The destination range must include the original formula cell at the top for Fill Down, or at the left for Fill Right. These commands are useful when the handle is hard to grab, when the sheet is zoomed out, or when you need to fill a large, precisely selected range.

In Excel for the web, the Windows desktop Options path is not available. You can still select the source and destination range and use Home > Fill, or try the keyboard shortcut supported by your browser and keyboard configuration. If a shortcut is intercepted by the browser, use the ribbon command instead.

Check formula references before assuming the fill failed

Sometimes the drag worked, but the copied formula produces an unexpected value. Excel adjusts relative references as a formula moves. A reference such as A2 becomes A3 when copied one row down. A dollar sign makes a reference fixed: $A$2 remains pointed at that exact cell. Mixed references, such as $A2 or A$2, lock only the column or row.

This matters when a formula should always use a particular tax rate, target, or lookup cell while its row-level inputs change. If the fixed reference was not entered deliberately, a copied formula may shift to a blank or unrelated cell and appear broken. Select a filled cell and inspect the formula bar to verify that each reference points where you expect.

Also distinguish a copied formula from a repeated value. If the source cell contains a number or text rather than a formula, dragging may copy it or continue a recognizable series. The Auto Fill Options button can change the result after filling. Undo immediately with Ctrl+Z on Windows or Command+Z on Mac if Excel filled an unwanted pattern, then choose the appropriate fill option or use Copy Cells.

Look for sheet and cell restrictions

A protected worksheet can prevent edits to locked cells, including filling formulas into them. Check the Review tab for Unprotect Sheet. If the sheet is protected, you may need permission or the password from its owner; do not assume protection should be removed from a shared or controlled workbook. Some protected sheets allow editing only in specified unlocked cells.

Merged cells are another common obstacle. A merged area behaves differently from a normal grid of individual cells, and a fill range that crosses merged and unmerged cells may be rejected or behave unexpectedly. If practical, unmerge the relevant cells using Home > Merge & Center > Unmerge Cells, then fill the formula and apply the desired alignment separately.

Check whether you are editing the intended worksheet and whether the destination cells are actually part of the selected range. A hidden row, filtered list, or an existing table layout can make it hard to see which cells are selected. For a table, entering a formula in one row of a calculated column often propagates it through that table column automatically; use the table’s formula behavior rather than dragging beyond the table without checking the result.

When the formula appears not to calculate

If cells display the formula text instead of the calculated result, the problem may not be the drag operation. The cells might be formatted as Text, or Excel may be showing formulas on the worksheet. Select a destination cell and check Home > Number Format; change Text to General if appropriate, then re-enter the formula. Merely changing the format may not convert an already-entered text string into an active formula until you edit and confirm it again.

To check whether formulas are being displayed, open the Formulas tab and see whether Show Formulas is enabled. Turn it off to return to calculated results. If formulas fill correctly but results do not update after inputs change, check Formulas > Calculation Options and choose Automatic when that is the intended workbook setting. Manual calculation can make results look stale, but it does not usually prevent the fill handle itself from copying formulas.

Another symptom is that the destination remains blank or reports an error. Inspect the formula in the first destination cell, check its adjusted references, and look for errors such as #REF! caused by a reference that became invalid. A short test in an empty area can show whether the issue is the formula, the selected range, or a restriction in the original part of the sheet.

A quick troubleshooting order

Work through these checks from easiest to more specific. This avoids changing workbook structure when a setting or pointer position is the real cause.

  • Confirm you are on the cell’s lower-right fill handle and see the black plus pointer.
  • In Windows Excel, verify File > Options > Advanced > Enable fill handle and cell drag-and-drop.
  • Try Ctrl+D or Home > Fill > Down with the source and destination range selected.
  • Check for sheet protection, merged cells, and table boundaries.
  • Inspect the copied formula, cell number format, Show Formulas setting, and calculation mode.

If filling works in a new blank workbook but not in the original, focus on that worksheet’s protection, merged layout, or table structure. If the handle fails in every workbook, revisit the application setting and consider whether a mouse or trackpad issue is preventing a precise drag. A keyboard fill is a useful way to keep working while you isolate the cause.

Frequently Asked Questions

Why is the fill handle missing in Excel?
It may be disabled in File > Options > Advanced under Editing options. Select Enable fill handle and cell drag-and-drop. If it is enabled, check that a single cell is selected and that the worksheet is not in a mode or layout that makes the corner difficult to see.

Why does dragging copy the same formula instead of changing the row?
Check whether the formula uses absolute references, such as $A$2, which stay fixed when copied. Also verify that the destination cell contains a formula and inspect its formula bar. Relative references normally adjust as the formula is filled.

Can I copy a formula down without using the mouse?
Yes. Select the formula cell and the cells below it, then press Ctrl+D on Windows or Control+D on Mac. You can also use Home > Fill > Down.

Why does double-clicking the fill handle stop early?
Excel uses nearby data to decide how far to extend the fill. A blank or gap in the adjacent column can cause it to stop before the bottom of your intended range. Select the exact range and use Fill Down when you need a predictable endpoint.

Does a protected worksheet stop formula dragging?
It can. Protection may block edits to locked cells, including cells you are trying to fill. Check Review > Unprotect Sheet, but obtain authorization or the password from the workbook owner before changing protection.

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.