Fill handle & drag-paste don't commit in Excel desktop
1h ago
I have an issue where Excel's drag-to-fill and drag-to-copy/paste don't work, but everything else does. This started suddenly this morning after 2+ years of no issues, with no updates or new installs beforehand.
Symptoms:
• Select a cell, drag the fill handle down - the small preview tooltip correctly shows the next value in the sequence (e.g., 3, 4, 5) as I drag.
• When I release the touchpad, nothing appears in the cell. It stays blank.
• Same problem with drag-and-drop copy/paste within Excel: the drag works, but releasing doesn't commit anything.
• Regular copy → Paste (Ctrl+V) also fails to apply formatting, but Paste Values works fine.
• Fill Series via the ribbon (Home → Fill → Series) works correctly.
• Ctrl+D (fill down) does not work either.
What I've already tried (no change):
• Tested on a brand-new blank workbook
• Excel Safe Mode (excel /safe)
• New local Windows user profile
• Reset Office registry settings (HKCU\Software\Microsoft\Office\16.0\Excel)
• Full Office uninstall and reinstall
• sfc /scannow - found and repaired corrupted system files
• DISM /Online /Cleanup-Image /RestoreHealth - completed successfully
• Checked for Group Policy restrictions (none found)
• Checked for interfering background software (only Chrome and Excel running)
• Ruled out touchpad hardware since drag-and-drop works fine in File Explorer
• Checked "Enable fill handle and cell drag-and-drop" and "Show Paste Options button" settings - both as expected
• Confirmed no touchscreen/stylus, no ClickLock, no ITouch/gesture conflicts
What works:
• Excel Online - drag-fill and paste work perfectly
• Typing values manually
• Paste Values (Ctrl+Alt+V → Values)
• Fill Series dialog
System info:
• Windows, Microsoft Office LTSC Professional Plus 2024
• No recent updates, installs, or policy changes before the issue started
Contacted Microsoft Support directly, who were unable to resolve it and suggested posting here. Any ideas on what else could cause writes to fail specifically on drag-release while click-based commits work fine would be much appreciated.
microsoft-3652 answers
1h ago
Hi Horus,
Thank you for providing the detailed troubleshooting steps you've already completed. Based on the behavior described, Excel appears able to calculate the fill or copy operation correctly during the drag action, but the change is not being committed to the worksheet when the action is completed. Since the issue persists across new workbooks, Safe Mode, a new Windows profile, and even after an Office reinstall, it is unlikely to be related to a specific workbook, user profile, or standard Excel configuration.
As a temporary workaround, you may continue using:
- Home > Fill > Series for sequence generation.
- Paste Values when copying data between cells.
- Excel Online, where drag-fill and paste operations continue to function normally.
Given that common troubleshooting measures and repair processes have already been exhausted, the next practical step would be to monitor for any recent Windows or Office updates that may coincide with the behavior and test again after future updates become available.
I understand how disruptive this can be, especially when core editing actions are part of an everyday workflow. You've already completed many of the advanced troubleshooting steps typically recommended, which helps narrow the scope considerably. Hopefully a future update or deeper investigation can identify the underlying cause. In the meantime, the available workarounds should allow you to continue working while the issue is being reviewed.
Please note that this is a peer-to-peer community forum where Microsoft developers don't monitor for feature requests. We can't address product feature requests or design changes.
Let me know if you need further assistance, feel free to ask me by clicking "Add Comment" or "Add Answer" if you cannot add comment so your response will be visible. Thanks for your effort.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
0 question comments
Use comments to ask for clarification. Post a solution as an answer.
No question comments on this page.