Selecting a cell in Excel goes to an incorrect cell

Anonymous
2023-06-08T14:41:12+00:00

Issue reported multiple times for several years:

When selecting a cell in Excel, the cell selected is in a different location to where the user's cursor is. Issue leads to massive amount of lost productivity and causes serious errors in data.

Reported multiple times recently, no response from MS other than to report it to Feedback Hub (again).

The bug renders Excel totally unfit for purpose, for customers paying for it.

The bug should be fixed immediately, treated as high priority.

Steps already tried:

  • Regress Office version.
  • Rebuild laptop altogether.
  • Change laptop altogether.
  • Try Safe Mode.
  • Reset scaling to 100% on all monitors in use, and reboot.
  • General driver updates.
  • Try touchpad instead of mouse, change mouse.
Microsoft 365 and Office | Excel | For business | 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 No comments

58 answers

Sort by: Oldest
  1. Anonymous
    2024-03-14T14:33:29+00:00

    Hello Tom,

    We've identified a reproduceable case involving scrolling with the Touchpad in which Excel screws up calculating the offset to the top of the grid. This bug is in the process of being fixed. Does this sound similar to the issue you're seeing?

    One thing that would be particularly helpful to us is if you could submit feedback directly through Excel. Use the little feedback button in the upper right corner. Include a screenshot or the workbook and your email. Mention my name.

    Thanks,

    Chris

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2024-03-15T12:22:37+00:00

    Chris,

    I have the same problem but I'm not using a touchpad mouse. Can you also verify when Excel "screws up calculating the offset..." Does it correct itself if you click into another sheet in the same workbook?

    At least we are getting somewhere with this as its been ongoing for a couple of years in my experience.

    Thanks,

    Joshua

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  3. Anonymous
    2024-03-15T13:10:42+00:00

    Hi Chris, I've sent the following via Excel feedback (I don't have the icon you mentioned but assume it's the same as the feedback menu option). Thanks for taking this seriously, please continue to treat it as urgent, many thanks, Tom

    FAO Chris Hammond, regarding Excel offset bug (https://answers.microsoft.com/en-us/msoffice/forum/all/selecting-a-cell-in-excel-goes-to-an-incorrect/1f64c90e-4a48-475f-890e-e3aa26f3d8f0?page=4&messageId=36c743be-ec7d-4c74-9d4a-266bedfd3fa4), from Tom Vanheems (l**************@gmail.com). In response to latest query, issue occurs even both when touchpad is enabled or disabled. File attached. In screenshot, cursor was in G12, but G22 selected. Offset interval varies. Thanks, Tom

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2024-03-15T13:11:15+00:00

    Feedback fails to post, error: "Something went wrong — try submitting again in a few minutes." Had to remove attachment, which isn't very helpful, for it to then submit.

    Was this answer helpful?

    0 comments No comments
  5. Anonymous
    2024-03-15T14:44:03+00:00

    Hello Joshua,

    Most users report forcing the grid to redraw fixes the issue -- at least temporarily. So try resizing the window.

    There could be a few issues here. We think that these problems are caused by some combination of Excel features that affect the grid layout, like freeze panes, grouping, or filtering, and hardware, like multiple monitor setups or trackpad gestures. Identifying consistent reproduceable examples in house to debug has unfortunately proved elusive.

    This forum is interesting for community discussion, but it's not too helpful in trying to get to the bottom of a problem like this. Please submit feedback through Excel.

    Thanks,

    Chris

    Ps Tom. I responded to your feedback. So you should have an email from me i.e. from Microsoft in your inbox (or junk mail folder!)

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments No comments