Forum Discussion
CPeterson710
Mar 20, 2022Copper Contributor
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...
Cappy1378
Aug 30, 2024Copper Contributor
CPeterson710 I have read through this thread and thought I’d add my experience with this issue.
I have had this issue using different files on different computers over the past 3 years. I have used Windows 10 and Windows 11.
For me, I have observed this happens mainly when I’m working in a table or if at some point I have sorted the rows. It’s a huge annoyance when updating. In my experiences I have a minimum of 20 rows before this issue happens. To “unstick” it, I have to arrow up and down above and below the stuck row then arrow to a cell in the row and type to get it to work again. It’s fiddly and a time waster. I would hope that Microsoft staff would have encountered this and would have tried to find a fix. I am guessing not since it has happens for such a long time.
Coleeo2006
Aug 31, 2024Copper Contributor
That's exactly the same B.S. workaround I still use to get it to work. I started using F2 to enter the cell I select (adjacent to the whichever cell I'm on when it randomly stops letting me edit) so I don't have to reach all the way over for my mouse like a sucker, though.
I'll have to check out those catalysts you mentioned... I'm never usually paying attention to exactly what I'm doing immediately preceding the event, but this'll give me some motivation to be more vigilant.