Unable to Drag the Contents of One Row to the Row Belos

ASHOK VK 0 Reputation points
2026-09-18T12:22:51.3433333+00:00

I am unable to Copy or Drag the Contents of One Row to the Other. Its happeinging in all the Excel Sheets. I have done all the Simple was ie Options -> Advance -> Enable Fill handle. Ignore other applications using Dyanamic Dynamic Exchange etc. (its unticked)

Microsoft 365 and Office | Excel | For home | Windows
0 comments

2 answers

Sort by: Oldest
Most helpful Newest Oldest

  1. AI answer

    2026-09-18T12:23:07.8833333+00:00

    This matches a known Excel issue caused by a recent update, where drag-to-fill, drag-and-drop copy, and paste can fail even when Enable fill handle and cell drag-and-drop is already turned on.

    Supported checks and actions:

    1. Confirm the fill handle setting is enabled:
      • File > Options > Advanced
      • Under Editing options, make sure Enable fill handle and cell drag-and-drop is selected.
    2. Try the non-drag fill method:
      • Select the cell with the formula or content.
      • Select the adjacent cells to fill.
      • Go to Home > Fill > Down, Right, Up, or Left.
      • Keyboard shortcuts: Ctrl+D to fill down, Ctrl+R to fill right.
    3. If drag/copy/paste still does nothing across all workbooks, treat it as the known update-related issue.
      • A Microsoft Q&A accepted answer identifies this as a known issue due to a recent update and points to the Excel hotfix article for KB5002914.
    4. Temporary workaround:
      • Use Home > Fill > Series or the Fill command instead of dragging until the fix is applied.
    5. If copy/paste is also failing:
      • One reported workaround is Ctrl+X, then Ctrl+Z, then Ctrl+V.

    If the problem started suddenly and affects every workbook, that pattern is consistent with the known update issue rather than a workbook setting.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

  2. DaveM121 934.5K Reputation points Independent Advisor
    2026-09-18T12:57:00.5866667+00:00

    The Copy & Paste and Drag to Autofill problems in Excel are currently widely reported in Excel as being caused by the latest Office update (KB5002914).

    Try uninstalling that update and restart your PC, if that does not resolve the problem, Microsoft indicate they are working to resolve this bug and will release an update as soon as possible to resolve the problems.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.