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 nothing happens, the cell is not selected
2-I click on a cell but the wrong cell is selected (Example: Click on cell B2 but excel will select C2)
This will happen as frequently as a few times a day (across multiple workbooks) to every month (again, across multiple workbooks)
In ALL cases cells are NOT protected
Saving the workbook, closing then restarting excel fixes the problem.
As I mentioned before, this has been ongoing for years now across multiple computers, workbooks, operating systems. All systems and versions of excel were fully up to date at the time of the error. Because this is happening over several different workbooks, I do not belive it is a workbook issue (especially when it doesn't happen 100% of the time to ANY workbook)
Systems used:
Macbook Pro (circa 2015), OS up to date - No longer have this computer
Windows 8 (again, old computer)
Windows 10 (old computer
Windows 11 (2 different computers, currently owned)
I have always kept excel and the OS fully up to date and I'm currently using the most recent version of Windows and Excel.
In all cases, I have used built in trackpad and a 3 different wireless mice (with full batteries). Still randomly occurs.
It's really just an annoyance and like I mentioned before, saving the workbook and restarting excel solves the issue... until next time (which could be later that day or a few weeks...It's very random.)
CPeterson710 I turned my (new) mouse off and I seem to be able to select cells using my trackpad now. I was having the same issue even with my trackpad while the mouse was turned on. It's an ergonomic "Perixx" mouse, Model No. Permice-608, for what it's worth.
CPeterson710 - There is an excel bug that is supposed to be fixed with the Oct update that relates to using a touch pad to zoom and scroll.
But I see this is happening with mice as well.
- It's November and I still have this issue (agree with CPeterson and others -- nothing works consistently). Very annoying and time consuming. Microsoft should have been on top of this several years ago
- OMG, this is doing my nut!
I have a simple sheet with frozen panes. The scrollbars are not updating/refreshing the visible cells so a click selects something but it's where Excel *thinks* it has scrolled to, just the screen render has not updated so it's very confusing. My Office updated to v2211.
Has there been a solution to this? This started happening to me after Windows 11 update. When panes are frozen and I click on a cell it randomly selects another cell. For now clicking another sheet and going back to your worksheet seems to "fix" it, but it keeps happening.
- I am having the same problem. I tried going to a different sheet and back. But I still could not get excel to select the cell I clicked. I have had this issue on different workbooks. I never had this issue before I got Windows 11. So I think microsoft messed up something that used to work!!!
No fix for me. Windows, Excel and all drivers are up to date on the THREE computers I'm experiencing the issue. It does seem to be some sort of "focus" issue with my pointing device (mouse on desktop, mouse and trackpad on laptop #1 and trackpad on laptop #2). Clicking in some other window "works" every time...until next time. I have not found a consistent reason as to why it's been happening. Once I had the issue on a clean install of windows on a blank sheet!
- I've had the same issue. It also seems to be related to scrolling to quit working (like scroll-lock is on). It seems to happen with hidden columns and freeze panes.
I can't believe MSoft employees haven't run into this.- For sure they'll know about it outside of this forum. Staggering that they think it's acceptable to leave it unfixed; I'm about to ensure a full laptop rebuild to try to solve the issue.
- I've found for me the easiest "workaround" is to click on another open window and back into excel.
Tried all the usual stuff to fix it (uninstall and reinstall excel, back to defaults, etc. Even went so far as to reinstall windows and eventually purchased a new computer (not as a resolution...it was time))
I am also facing the same issue with one of my systems which is currently running Office 2019 and Windows 11.
- I was able to figure out my issue. The formula bar was not showing. It was a setting issue
To Show Formula Bar - Options/Advanced/Display/Check show formula bar- Tried this, but it seems this is NOT the problem in my case. Earnestly looking to a resolution of the problem...
The function row that used to show up automatically in previous Excel versions appears not to be in MS365. I type and edit text quite frequently in Excel. I am unable to click text in a cell to correct a typo. This is incredibly frustrating and step in the wrong direction in my opinion.
Hi CPeterson710
Please find below the thread for the same error that you’re facing:
https://www.excelforum.com/excel-general/1276123-excel-wont-let-me-click-on-the-cell-i-want.html
Thanks,
Suyash
According to what has been written, edit mode might be activated.
But without a file (without sensitive data) it is difficult to make assumptions, especially in this case where it goes through many Excel versions.
If it is not, many questions arise beforehand.
Does it only happen in this file?
Does this file have macros?
Are add inns enabled?
Have all updates been carried out?
Has an Office repair been performed?Anyway, hope this information helped you a bit.
I know I don't know anything (Socrates)
- Thanks for the suggestions.
Regarding files, it does not happen to every file and files that it does happen to it doesn't happen every time.
Next time I do experience this issue I'll check to see if it's in exit mode or not. In the meantime, I'll do an office repair and hope it's a non issue going forward.
To your specific questions:
*Random files at random times. I have a couple sheets I use VERY often and those are the only files I noticed the issue more than once. And yep, sensitive information 😉
*Usually no macros (I only open one file with any regularity with macros. Oddly I'm not sure I had the click issue with that file.)
*No add INS enabled
*Always updated (Windows and Office apps as well as any drivers, etc.)
