Excel will not let me click into cells or incorrect cell is selected randomly

New Contributor

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.)

3 Replies

@CPeterson710 

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. 

Edit cell contents

 

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.

 

NikolinoDE

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.)