Issue with Excel automatically expanding selection of cells

[ExcelSelectiontroubles]

Hello, I recently switched over to 365 and I have been having this issue with Excel I cannot seem to figure out!

When I click my mouse once on a single unmerged cell, Excel will automatically expand the selection. I assume Excel is trying to in some way predict what range of data I might try to be selecting with one mouse click, but it is becoming extremely disruptive and I am at my wits’ end! What is confusing as well is that it is not consistent when it does this, it seems to be when I am in an Excel workbook with a large data set where where I am clicking has other data around it.

In trying to troubleshoot:
It is not “focus cell” as that highlights the row and column the cell is in visually, so it does not seem to be that, my problem is Excel actually automatically selecting the cells, not just a visual highlight.
It does not seem to be caused by the F8 expand selection, as that is indicated in the bottom bar and I have never found pressing F8 has any impact.
I have seen suggestions that it could be the "Extend Data Range Formats and Formulas" option but that feature does not seem to do what Excel does when I click a single cell, it does not seem to impact either when I turn it off.

More info:
This happens across multiple workbooks, regardless of computer or keyboard and regardless of what file, so it does not seem to be tied to any sticky shift key or Macro I’m not aware of, at least from what I can tell. It seems to be a feature added in 365.

If anyone has any suggestions, I would truly truly appreciate it, this has been so difficult to deal with! Thank you in advance!

 

[Jeffrey Mahoney]

Not seen anything like that. Just grasping at straws here: Do you have something in your mouse settings that would cause this. Do you have a laptop, can you use your mouse pad on the laptop correctly? Touchscreen? same problem?

Does using your keyboard arrows to navigate have the same reaction?

 

[Jeffrey Mahoney]

Please try this: Close excel and re-open it with no other workbooks loaded. open a brand spanking new file. Try to mouse. Does it work properly? Add something into cells as you would expect it to fail. Does it work properly?

 

[ExcelSelectiontroubles]

Not seen anything like that. Just grasping at straws here: Do you have something in your mouse settings that would cause this. Do you have a laptop, can you use your mouse pad on the laptop correctly? Touchscreen? same problem?

Does using your keyboard arrows to navigate have the same reaction?

No, it clicking with the mouse that seems to do it! I’ll try to do more testing to see if I can replicate this, I have had this issue across several laptops, different mouses, etc but haven’t tested it with the touchpad so next time it starts happening I’ll try to some investigating!

 

[ExcelSelectiontroubles]

Please try this: Close excel and re-open it with no other workbooks loaded. open a brand spanking new file. Try to mouse. Does it work properly? Add something into cells as you would expect it to fail. Does it work properly?

I am struggling to recreate it reliably but the next time it starts to happen I’ll try some of this to get more information/collect more data. Thank you!