We are using Microsoft Excel 2003. When the user clicks on a cell the mouse is then stuck highlighting cells where ever the mouse moves. This can not be released by anything apart from closing excel from the menu bar or task manager.
Thanks for your advice. I have checked the shift key and it isn't stuck down. Also replaced the keyboard and mouse. I haven't had any joy with any suggestions i have found by searching on google either.
Thank you for your idea. This hasn't solved the problem though.
What is different about the behavior of the excel in question and things like F8 or ClickLock is that the excel highlighting moves with the mouse and not when you click.
->"When the user clicks on a cell the mouse is then stuck highlighting cells where ever the mouse moves."
That's not very clear at all.
Does the user have to click in another cell to see the effect? Or does simply moving the mouse cause problems? And by highlighted, do you mean selected?
Go to another computer and do the following two things:
1)
- Left Click on any cell
- Press and hold down [Shift]
- Click another cell
- Release [Shift]
You'll see that the entire range between the cells is selected.
2)
- Left Click on any other cell
- Press and hold down [Ctrl]
- Click another cell
- Release [Ctrl]
You'll see that each of the two cells you clicked on is selected, but no other cells are.
Which, if either, of these two things is happening on the PC you're having trouble with?
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ 181-2886 before posting.
The fault is more like your first example but when the mouse is moved the highlighting moves with it. Clicking of the mouse doesn't work, the mouse won't release the highlighting of the cells.
Freemo,
This sooo sounds like a stuck Ctrl key. I've run a test on a good machine and held the Ctrl key. The effict I get is similar to what you are describing. What we should be asking is does the same thing happen when selecting items from the desktop or other explorer window. If not, then this probably isn't the case.
Try this: In Excel put pointer over a cell and hit the spacebar... if the entire column is selected then you have stuck control key. Replace the keyboard and try again, especially if you can do multiple non-adjacent selections from the desktop or My documents.
cckens
"Not always my best shot, but I hit the target now and then"
-me
Thank you for all your help. In response to your ideas, am sorry but none has worked.
xlhelp - I have tried changing the mouse driver from a HID to a USB driver. Also uninstalled and reinstalled in device manager and installed a new mouse, ps2 and usb.
cckens - No Ctrl key is stuck. This only happens in excel, never in any other app. I have changed the keyboard and also the drivers.
Stella740pl - I have checked Sticky Keys and this is not on, neither is ClickLock etc
Thanks for everybodies help so far, i know we will get there.
This frustrating problem just happened to me too. The highlighting follows the mouse. I fixed mine by clicking the little red button on the middle of my mouse. I don't know why, but it worked.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.