Share via

drag and drop has stopped working on Excel,

Anonymous
2023-04-07T18:47:54+00:00

two days ago this feature was working perfectly, yesterday it wasn't anymore. Advice on web is to go to Options, Advanced, however when I click on Options the only option is Regional Format Settings, there are no other options. I've tried F2, Esc, holding Ctrl to try to drag etc,. It dos auto fill, just won't drag. My desktop version works fine, it's just the 365 version.

thanks

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-07-31T02:16:43+00:00

    This worked for me. Good Luck: (Windows 10, Microsoft 365, Desktop (not browser version)).

    When in Excel Desktop,

    File -> Options -> Advanced

    There's a section titled, "Editing Options".

    **> Make sure the box right under that is CHECKED ("Enable fill handle and cell drag-and-drop").

    The one under it was checked, as well.

    When that box was NOT checked, I had the problem.

    When I went in and checked that box, I did not.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-04-07T19:45:19+00:00

    No, it does not. I even created a new document and uploaded it to OneDrive. The one on my desktop works fine, but the one I uploaded doesn't.

    Was this answer helpful?

    0 comments
  3. HansV 462.6K Reputation points
    2023-04-07T19:38:21+00:00

    Does it help if you close and reopen Excel in the browser?

    If you restart your computer?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2023-04-07T19:10:46+00:00

    so how do I get drag and drop back? Like I said it was working fine up until yesterday

    Was this answer helpful?

    0 comments
  5. HansV 462.6K Reputation points
    2023-04-07T19:04:04+00:00

    If you only see Regional Settings, you're probably using Excel Online (the browser version).

    The setting that you mention is only available in the desktop version of Excel.

    Was this answer helpful?

    0 comments