Forum Discussion
Excel selects wrong cell
I have this issue as well and found that it is the zoom that is causing this to happen. If you change to 100%, you will be able to click on the right cell.
And this morning I was looking into this issue, played with the scroll lock, but I wasn't seeing the issue. Until I noticed I had the zoom at 130%.
I changed the zoom to 100% and instantly had the problem.
I have found a fairly easy work around: change worksheets. The problem goes away for a while.I use a laptop with extended monitors. and I use the laptop keyboard. For me, quickest fix is to scroll up-down on the touchpad. This seems to reset things without having to navigate to a different worksheet.
The problem is as bad today as in March 2023, when I first reported it. All users should be offered compensation by Microsoft, and their payments waived or refunded.
I'm usually at 100% and see the issue consistently. Changing zoom, scrolling, changing screen, resizing the window are workarounds that work for a bit until the issue returns. And then the same workaround applied again may or may not help again.
I'm starting to think this may be connected to multiple screens and freeze panes used together, which I do quite a lot. Is this the case for others on the thread?I use multiple screens and get the issue. Tend to use freeze view less but still frequently get the issue so don't think its down to freeze view.
Thanks for adding your input to this disgusting case. For me it can happen on a basic worksheet with nothing applied to it at all. I've not tried just the laptop on its own for a while (I use two extended screens), it wouldn't be usable like that for me anyway.
ı was dealing with this issue about a year. now as i read this comment, the fire extinguished. Thanks alot.
- That worked!! Thank you!!!!
kaseygoh yes that works. For one click, before the issue re-occurs. Then you can use the laptop's trackpad instead of the mouse, and that works for one or a few clicks before the position gets out of sync again. Then you can resize the window, and that may work too for a few clicks. Once you've done all these workarounds and Excel is truly confused, the only way to recover is restarting the application.
I'm having the same issue and have been for some time.. It's so frustrating. The issue occurs on my Civil Service issued Dell laptop when using Excel in the App rather than the online view and my own HP laptop. Both use Microsoft 365. It occurs whether I'm using my mouse or a trackpad. Today it seems worse then ever on my HP. It tends to resolve if I minimise the screen and then maximise it again. But today that is only lasting one or two cell clicks at a time. So frustrating!
Yes, happens across different laptops. Windows versions/builds, monitor configs etc. etc. I can't get by with the web version as it's not the same, doesn't do certain things and has a lot of crazy bugs.
I resolve the issue by very quickly scrolling the display up and down, that seems my quickest way, but the issue returns.
I'm thinking of creating dozens of new tickets so at least other users around the world have a greater chance of finding the threads and adding their concerns.
The fact Microsoft abanonded the case and have refused to even reply for a long, long time, is utterly disgusting.
