Hello, and welcome to JustAnswer!
Are you pressing any keys while you select a cell?
No, just using the track ball click.
Do you get such problem in any other programs as well?
No, just excel.
I should have said, more than one cell is selected most of time, but not always
Do you have any button other than the track ball to left click the mouse?
What happens if you click mouse over one cell?
The cell I click on and the one to the right are highlighted. The I scroll to the left and the second box is not highlighted. This is a nuisance when double-clicking to enter a formula.
You mean when you scroll to left, the left cell is not highlighted, right?
The one to the right of the cell I want, no, the right cell.
Have you ever tried an external USB mouse?
It doesn't seem to happen on a new workbook.
No, I use the trackball exclusively
It's a USB trackball.
To verify if this is Excel problem, I would suggest you to try an external mouse if possible. To me, it doesn't seem to be a problem with Excel.
Why would that make a difference? We don't have any mice here.
There can be one possible problem i.e. Extended selection being ON.
Try pressing F8 once before you click.
Let me know if this helps.
No. It's still the same or worse, that sometimes makes three cells highlighted.
Press once more to toggle it back.
So it means 'extended selection' wasn't the problem. So, I would suggest you try an external mouse and see if it makes any difference.
OK, i tried an external mouse and had the same problem. Extended selection sure sounds like the right description.
You have not answered my question. Can someone else resume this chat if you're not available?
If you think it is the extended selection problem, you can toggle extended selection ON and OFF by pressing F8 key.
See if that makes any difference.
I will opt out in case some other expert has a better opinion about this. Thanks for your patience.