Selecting a cell in Excel goes to an incorrect cell

Hi Tom,

Sorry to jump on this query, did you get it resolved?

I am having the exact same issue and it is driving me slightly insane!!!! I use excel constantly and have done all the things suggested but nothing works.

Thanks

Suzanne

Hi Suzanne,

Thanks for adding your experience, it all helps. No resolution. Microsoft have stopped responding, even on their own forums. I've contacted them via social media and they refuse to help. Without question the most disgusting customer support fail I've witnessed in all my years working in tech. To leave a product as important as Excel not fit for purpose, and then not even respond to customers in a professional manner, is quite despicable.

Tom

Hello Tom,

The offset selection problem is a relatively rare complaint. Unfortunately, we've been unable to reproduce the issue in house. I'm sorry that you're hitting it so frequently.

We suspect that it may be caused by freeze panes, grouped columns and rows, or filtering (or some combination) in which the mouse click gets out of sync with the cell table when doing a lot of manipulation to the sheet.

If you could provide an example workbook and a step by step description on how Excel gets into this state in your next feedback submission, it'd be hugely helpful. You can mention my name. Otherwise, it's near impossible to track down the cause of this anomaly.

Thanks,

Chris

Excel Engineering

FYI. If you submit feedback through the app, but don't include your email address in the email field in the feedback pane, there is no way for us to contact you in response to your feedback.

FAO Chris, Excel Engineering

Thanks for entering the dialogue, Chris. I was able to replicate within minutes of reading your reply. Steps/info below; saving to synced location/OneDrive certainly seemed a factor in this test, it's not something I've considered previously and I'm pretty sure the issue occurs working off local unsynchronised location, but perhaps it can be a factor:

1. Open new workbook in monitor (laptop has two monitors in use and issue is same whether at home or in the office). I've tried switching off monitors, changing DPI etc.
2. Add data in a few cells going down enough rows so I need to scroll.
3. For a couple of minutes testing, issue does not manifest.
4. Save to a OneDrive location, auto-save automatically enables.
5. Issue immediately occurs; vertical offset of c. 16 rows (see column J of attached image).

I can't seem to attach the file.

MS/Win build/version info attached. I'm on W11 but it's same on W10.

Hope this helps -

Tom

Hi Tom,

Thanks for the additional details. But bear with me:

You're using desktop Excel, right?

Are there any add-ins that load when you boot Excel?

Does your organization use a custom workbook template that changes some of the default settings, like zoom, fonts, font size, row height?

Is the worksheet in Normal view or Page Layout view?

Can I ask you to boot Excel and then click the Send Feedback button in the upper right corner?

That's a better mechanism to communicate. You can include your email, screenshots (if allowed by your admin) and attach files directly to the feedback. And I can respond to you in email.

--Chris