Excel Cell Drag Not Working? Fix the Fill Handle

If Excel cell dragging is not working, first check whether the fill handle is enabled: in Windows Excel, go to File > Options > Advanced and, under Editing options, select Enable fill handle and cell drag-and-drop. Then point to the tiny square at the bottom-right corner of the selected cell and drag it; dragging the cell border instead moves the cell contents rather than filling nearby cells.

Identify what you are trying to drag

Excel uses two nearby parts of a selection for different actions, which is the source of many reports that dragging has stopped. The selection border surrounds the active cell or range. Its edge is used to move the selected contents to another location. The fill handle is the small square at the lower-right corner of that border, and dragging it copies content or extends a series into neighboring cells.

Hover over the handle before dragging. The pointer should change to a small black plus sign. If the pointer instead indicates that you can move the selection, you are over the border, not the handle. At high zoom levels or with a small cell, the square can be easy to miss. Zoom in, widen the column, or select the cell and use a keyboard fill command if targeting the square is difficult.

To copy or extend: select the starting cell or cells, then drag the fill handle.
To move: point to the selection border and drag it to the destination.
To select cells: drag across the cells themselves, not the border or handle.

Turn the fill handle back on in Windows

In Excel for Microsoft 365 on Windows, open File > Options > Advanced. Find the Editing options section near the top and check Enable fill handle and cell drag-and-drop. Select OK, return to the worksheet, and try dragging the lower-right corner of a selected cell. The setting controls both filling with the handle and moving cells by dragging their border, so a cleared checkbox can make both actions seem broken.

If the checkbox is already selected, clear it, select OK, reopen the same setting, select it again, and confirm with OK. This can help if the option appears enabled but the behavior is not responding. The change is an Excel application setting, not a formula or a setting stored only in the current cell. If you use more than one computer, check the option on the computer where the problem occurs.

On Excel for Mac, look under Excel > Settings (or Preferences in some releases) > Edit for the fill-handle and cell-dragging option. The exact wording or location can vary by release. Excel for the web has a different interface and does not use the Windows Options dialog; if dragging is awkward or unavailable in your browser, copy and paste or use the Home ribbon’s fill commands where available.

Drag the handle the right way

For a straightforward copy, click a cell and drag its fill handle across the destination cells. To fill downward, drag below the starting cell; to fill right, drag to the right. Release the mouse button only after the shaded outline covers the intended destination. If the result is not what you expected, use Ctrl+Z on Windows or Command+Z on Mac to undo it.

Excel interprets the source selection when deciding what to place in the destination. Dragging one cell containing the number 5 usually copies 5. If you select two cells containing 5 and 6, then drag the handle, Excel can extend the pattern as 7, 8, and so on. Dates and other recognized sequences can also continue. After filling, the Auto Fill Options button may let you choose between copying cells and filling a series, depending on the source data and Excel version.

Formulas are copied with reference behavior. With product quantities in B2:B4 and unit prices in C2:C4, enter =B2*C2 in D2. If row 2 contains 3 and 4, the result in D2 is 12. Dragging the handle down to D4 adjusts the references for each row, so D3 becomes the product of B3 and C3 and D4 uses B4 and C4. References with dollar signs, such as $B$2, remain fixed when copied; this is useful when every row should refer to one constant cell.

Use keyboard commands when dragging is inconvenient

You do not need a working mouse drag to fill a range. Enter the starting value or formula, select the cells to fill, and use a fill command. On Windows, Ctrl+D fills down from the top cell of the selected range, while Ctrl+R fills right from its leftmost cell. On Mac, Control+D and Control+R are commonly used for Fill Down and Fill Right in Excel; keyboard mappings can vary with macOS settings. The ribbon alternative is Home > Fill > Down or Home > Fill > Right.

For example, if D2 contains a formula and you want it copied through D10, select D2:D10 and use Fill Down. Excel uses the top cell as the source and adjusts relative formula references for each row. For a one-off copy, copy the source with Ctrl+C on Windows or Command+C on Mac, select the destination, and paste with Ctrl+V or Command+V. These approaches are useful on a touchpad, when the fill handle is tiny, or when you need an exact destination range.

Check worksheet and cell restrictions

A drag can appear to fail because Excel is preventing edits rather than because the handle is disabled. If a worksheet is protected, you may be able to select cells but not change 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 that removing protection is appropriate for a shared or controlled workbook.

Also check whether the workbook is read-only, opened in Protected View, or marked as final. A banner near the top of the window may explain that editing is restricted. Choose Enable Editing only when you trust the file and its source. If Excel displays an error when you drag, read it carefully: a message about protected cells or merged cells points to a different cause from a missing fill handle.

Merged cells can complicate filling because the merged area does not behave like a regular rectangular range of independent cells. If the operation involves merged cells, try unmerging the relevant area or use a non-merged layout. In a formatted Excel table, a formula entered in a table column may automatically populate the calculated column, so dragging may not be necessary. Table behavior can differ from filling an ordinary worksheet range.

Diagnose mouse, touchpad, and Excel problems

If the handle is visible and enabled but will not track your pointer, test whether dragging works elsewhere in Excel and in another application. A touchpad may require a particular click-and-drag gesture, and a mouse button or driver can also fail. Try a different mouse, adjust the touchpad’s drag setting in Windows or macOS, and check that the pointer is not being released while you move across the cells. These checks help separate an input-device issue from an Excel setting.

Next, test in a new blank workbook. If dragging works there, the original workbook may have protection, merged cells, unusual formatting, or other workbook-specific restrictions. If it fails in every workbook, close and reopen Excel, then check for Office updates. On Windows, you can also test Excel in Safe Mode by closing Excel, pressing Windows key+R, entering excel /safe, and opening a workbook. If the handle works in Safe Mode, an add-in or customization may be involved. Disable add-ins one at a time through File > Options > Add-ins, then restart Excel to identify a possible conflict.

Save your work before troubleshooting and avoid changing several settings at once. If the problem began after installing an add-in or changing a preference, undoing that recent change is a sensible first test. If Excel displays a specific error, use that message to narrow the cause rather than repeatedly dragging over the same range.

Common misconceptions and useful distinctions

Scroll Lock is not the usual explanation for a disabled fill handle. It affects how the arrow keys scroll a worksheet, but it does not turn the fill-handle setting off. Likewise, a formula not recalculating is a different problem from a handle that will not drag. If the formula copied successfully but its displayed result seems wrong, check the references, calculation settings, and source values separately.

Dragging does not always mean copying. If you drag the selection border, Excel moves the selected cells; if you drag the fill handle, it fills adjacent cells. If you want to duplicate a block in a distant location, copy and paste is often clearer than border-dragging, which can overwrite destination cells. For a long or precise range, selecting the full destination and using Fill Down or Fill Right is usually more controlled than trying to land on the exact last cell with a mouse.

Frequently Asked Questions

Why is the fill handle missing in Excel?
In Windows Excel, the Enable fill handle and cell drag-and-drop option may be cleared. Check File > Options > Advanced > Editing options. Also confirm that you have selected a worksheet cell and that the small square is not simply difficult to see.

Why does dragging move my cell instead of copying it?
You are probably dragging the selection border rather than its lower-right fill handle. Move the pointer until it changes to the small black plus sign, then drag. Use copy and paste if you want to place a duplicate somewhere far from the original.

Why will Excel not drag a formula down?
Check that the fill handle is enabled and that the sheet is editable. Confirm that you are dragging the handle, not the border. If the formula fills but returns unexpected results, inspect relative and absolute references; relative references change as a formula is copied.

Can I fill cells without using the mouse?
Yes. Select the source and destination range, then use Ctrl+D on Windows or Control+D on Mac to fill down; use Ctrl+R or Control+R to fill right. You can also use Home > Fill > Down or Home > Fill > Right.

Does Excel for the web have the same setting?
No Windows Options dialog is used in Excel for the web. Its interface and available drag behavior can differ from desktop Excel. If dragging is not practical, copy and paste or use a fill command in the web ribbon when it is available.

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.