Excel Not Allowing Me to Drag a Formula? Try These Fixes

Formulas & functions · Updated November 18, 2026

If Excel will not let you drag a formula, turn on File > Options > Advanced, then under Editing options select Enable fill handle and cell drag-and-drop. Click OK, select the formula cell, and drag the small square at the lower-right corner of its border. If that setting is already on, check whether the sheet is protected or whether the formula cell is part of a spilled array.

What the fill handle does

The fill handle is the small square at the bottom-right of the active cell or selected range. Dragging it copies a formula, value, or pattern into neighboring cells. Excel adjusts relative cell references as it fills, which is why a copied formula can calculate a different row without needing to be rewritten.

It is easy to mistake the fill handle for the cell border. When the pointer is over the fill handle, it changes to a small black plus sign. If you see the usual four-headed arrow or another move cursor, you are probably on the cell edge and may move or copy the cell instead of filling the range. Move the pointer carefully to the tiny corner square before dragging.

For example, with unit prices in B2:B3, quantities in C2:C3, and a formula entered in D2, the cell layout is B2 = 12, C2 = 4, B3 = 9, and C3 = 5. Enter =B2*C2 in D2 and drag the handle down one row. Excel adjusts the formula in D3 to use B3 and C3; the results are 48 in D2 and 45 in D3. This automatic adjustment is normal, not a change to the formula’s basic purpose.

Turn the fill handle back on

In Excel for Microsoft 365 on Windows, open File > Options > Advanced. In the Editing options section, make sure Enable fill handle and cell drag-and-drop is checked, then choose OK. If it was already checked, you can clear it, choose OK, reopen the setting, check it again, and choose OK. This can reset a setting that was changed unintentionally.

This option controls both filling from a cell corner and drag-and-drop movement of cell contents. Turning it on does not mean that every drag will fill a formula: the pointer still needs to be on the fill handle, and the target cells must allow editing. If you work in a managed workplace, an administrator or workbook design may also restrict what you can change.

On Excel for Mac, look under Excel > Settings (called Preferences in some releases) > Edit, and enable Allow fill handle and cell drag-and-drop. The wording or layout can vary slightly by release. Excel for the web has a different interface and does not use the Windows File > Options path; use its fill handle when it is available, or copy and paste the formula as an alternative.

Make sure you are dragging the right way

Use this sequence to distinguish a disabled handle from a simple selection problem:

  1. Click once on the cell that contains the formula. Do not start by selecting the entire row or column.
  2. Check that the formula is in the cell, rather than only being typed into the formula bar and not yet confirmed. Press Enter to commit an edited formula.
  3. Move the pointer to the cell’s lower-right corner until it becomes the small black plus sign.
  4. Hold the left mouse button and drag across the destination cells, then release.
  5. Check the filled cells and the formula bar to confirm that the formulas and references changed as intended.

If you want to fill several columns, select the source formula cells and the destination range first, then use a fill command. Dragging a single corner is most straightforward for a contiguous range in one direction. If you need to copy formulas into nonadjacent cells, copy the source and use Ctrl-click to select destinations where appropriate, then paste; the exact behavior can depend on the selection and worksheet layout.

Use keyboard or ribbon fill commands

You do not have to use the mouse. On Windows, select a range with the formula cell at the top and the cells to fill below it, then press Ctrl+D to fill down. To fill right, select a range with the source formula at its left edge and press Ctrl+R. These commands copy the top or left cell through the selected range, adjusting relative references in each destination.

You can also use Home > Fill > Down or Home > Fill > Right. On Mac, use the same Home tab commands if the keyboard shortcut differs on your keyboard or in your Excel release. Copy and paste is another dependable fallback: copy the formula cell, select the target range, and paste. For adjacent cells, double-clicking the fill handle can fill downward alongside a neighboring column of data, but it is not a universal substitute for dragging.

Double-click fill uses nearby data to estimate how far the formula should extend. If the neighboring column has blank rows or stops earlier than the data you intend to fill, Excel may stop at that boundary. Check the bottom of the filled range before relying on this method for a long list.

Check formula references before filling

A formula can fill successfully and still return unexpected results because its references move. A normal reference such as B2 is relative: when copied down one row, it becomes B3. An absolute reference such as $B$2 stays fixed. Mixed references lock only the column or row, such as $B2 or B$2. These distinctions matter when a formula needs to use a constant, such as a tax rate or target value, while changing the row being calculated.

For example, with a value in B2 and a fixed rate in F1, the cell layout assumed is B2 = 100 and F1 = 0.08. If the formula in C2 should multiply each row’s value by the same rate, enter =B2*$F$1 in C2 and fill down. The result in C2 is 8, and the copied formula in C3 will continue to refer to F1 while changing B2 to B3. If you leave F1 relative, filling down changes that reference to F2, which may be blank or contain a different value.

When a filled formula looks wrong, click one of its destination cells and inspect the formula bar. A missing dollar sign or an unintended fixed reference is often the cause. A fill operation copies the formula pattern; it does not know which cells you meant to keep constant.

Look for sheet protection, merged cells, and spilled formulas

A protected worksheet can block changes to locked cells, including filling a formula into them. Check whether the Review tab offers Unprotect Sheet. If the sheet is protected, ask its owner for permission or the password rather than trying to work around the protection. Some protected sheets allow edits only in particular unlocked cells, so a formula may fill in one area but not another.

Merged cells can also interfere with filling because one merged area does not behave like a set of ordinary, equal-sized cells. If the source or destination range includes merged cells, unmerge them where appropriate or choose a layout that does not require a fill across the merged area. Do not unmerge a designed report without checking how its headings and formatting will change.

Excel 365 formulas that return multiple results can spill into neighboring cells. The cells occupied by a spilled result are not individually editable formula cells; the formula belongs in the top-left cell of the spill range. Trying to drag or overwrite part of that result may be blocked or produce a spill-related error. Edit or move the original formula cell instead. This is different from an ordinary formula copied down one row at a time.

Tables and other reasons copying may look different

In an Excel table, entering a formula in one cell of a calculated column often fills the formula through the column automatically. That behavior can make dragging seem unnecessary, or make it appear that Excel is controlling the fill. If automatic formula propagation is not happening, check the table’s boundaries and whether the cells are actually part of the table. A range that merely has table-like formatting is not necessarily an Excel table.

Filtering a list does not turn the fill handle off, but filling a range that includes hidden or filtered rows can be confusing. Confirm which cells are selected and inspect the affected rows afterward. If the formula must apply only to visible records, use a method designed for visible cells rather than assuming a drag will skip every hidden row.

Also distinguish a formula that will not fill from one that fills but does not recalculate. Manual calculation can leave displayed results unchanged even after formulas are copied. If the formulas appear in the destination cells but their values are stale, check Formulas > Calculation Options > Automatic. Calculation mode affects when results update; it does not normally disable the fill handle.

Frequently Asked Questions

Why can I select a cell but not see its fill handle?
Check that Enable fill handle and cell drag-and-drop is selected in Excel’s Advanced options. Also confirm that the pointer is over the lower-right corner of a single selected cell and that the sheet allows editing.

Why does dragging move the cell instead of copying its formula?
You are probably dragging the cell border rather than its fill handle. The fill handle is the tiny square at the lower-right corner and shows a small black plus sign when the pointer is positioned correctly.

Can I fill a formula without dragging?
Yes. On Windows, select the source cell and destination range, then use Ctrl+D to fill down or Ctrl+R to fill right. You can also use Home > Fill > Down or Home > Fill > Right, or copy and paste.

Why did the formula change when I dragged it down?
Excel normally updates relative references as a formula moves. Use dollar signs to lock a row, column, or both when a reference must remain fixed; then inspect a destination formula to verify the result.

Why will Excel not let me overwrite one cell in a formula range?
The cell may be part of a spilled-array result, where the formula is controlled by the spill’s top-left cell. It may also be locked on a protected worksheet. Check the original formula cell and the sheet’s protection status before changing the range.

Related

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.