Forum Discussion
Excel will not let me click into cells or incorrect cell is selected randomly
Hi, This is an ongoing issue that I've been having for years across platforms, computers, versions of excel and workbooks. Basicially, one of two things happen: 1-I click on a cell but nothi...
Hi, this is annoying me too. A quick way to get "back to normal" is to press:
(1) Scroll Lock (2) Up Arrow (3) Scroll Lock (4) Down Arrow
This can be done really quickly but this doesn't permanently fix the issue obviously.
Took me ages to work this out 🙂
(1) Scroll Lock (2) Up Arrow (3) Scroll Lock (4) Down Arrow
This can be done really quickly but this doesn't permanently fix the issue obviously.
Took me ages to work this out 🙂
Thanks for the suggestion. I have my own 'fix', not sure if it works for everyone, but when the issue happens I simply scroll up/down using touchpad swipe. Doing it quite widely and rapidly a few times seems to 'shake' it back to normal, as utterly ridiculous as this is.
- This works for me to fix the issue temporarily.
If the cell selection issue happens, use the two-finger swipe on the trackpad - either from left to right, or from top to bottom, and let go.
This is not a permanent fix but it will take care of the issue without having to close and reopen the file.Hi all, reading this thread. I remember having the same issue many years ago with an older version of Excel (I want to say Excel 2010 or possibly even earlier than that), also using the trick of switching to another sheet in the same document and back again, and it was eventually fixed by Microsoft without me having to change laptops or anything. So surely someone at Microsoft has access to a knowledge database where the fix was documented?
Anyhoo, I want to share that I also started experiencing this issue with Excel 365. Up until yesterday, I was using Excel 365 on a laptop operating Windows 10. I had no such issue with my spreadsheet in Windows 10.
Yesterday, my Windows 10 laptop died, and so I switched to a new laptop running Windows 11. I am using the same spreadsheet that I had saved to an external drive right before my laptop died and that I moved to my Windows 11 laptop. I do NOT have a touchscreen on either laptops, or an external mouse, or a second monitor. The printer connected is the exact same printer on both laptops.
Besides the difference in iOS, this Windows 11 laptop has a much worse resolution than my Windows 10 laptop. They're both HP laptops. Not sure why the resolution might be a factor but I think I saw this mentioned as a possible cause in one of the replies.
So I hope this will help winnow down the possible reasons for this, as people are driven nuts trying to figure what, in their setup, might be causing the problem. Personally, I think it has to do with Windows 11 being a **bleep** OS and Excel 365 not playing well with it (or vice versa). I feel like I've taken a giant step back into the 20th century, personally.
- Thanks for noting your experiences. For me, it started on Win 10, and it's been disastrous being moved to a Win 11 laptop to try to resolve it, as the issue is still present but there are tons of issues and bugs with Win 11, absolutely crazy.
As for screen resolution, I've tired various changes and the issue persists, unfortunately. I've tried scale, resolution, different monitors etc., with no luck.
