This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am using excel 2007, on occasion when i try to select any one cell it will highlight and select multiple cells. Once this occurs it happens with every cell I click on.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I have heard, but cannot confirm, that some people with this problem have found that altering the zoom level (slider in lower right corner of Excel window) gets the multiple seelction to go away
best wishes
people.stfx.ca/bliengme
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
I've experienced this problem for years and 'think' I've finally found the solution! If I do a heavy longer (when I say longer we're talking milliseconds) mouse click it highlights multiple cells however when I do a quick light mouse click it only highlights one cell.
I'm finding it difficult to believe that something has bugged me for so long has such a simple solution. Let me know if it works for you.
John
Yes, it is time dependent. If you click within 5-10ms it selects the right cell. But this trick is not a solution.
Excellent,
Going to normal view from page layout view worked for me and I have been fighting this for at least 5 years now on and off. Will have to see how long it lasts for.
This resolved the issue for me...
when I tapped the shift key 5 times it asked me if I wanted to turn on sticky keys and I said no - the message went away and the issue of multiple cells highlighting as I used the arrow keys was fixed. Also, weirdly, the Caps lock was also switched whilst I had the select issue - ie, it was giving me CAPS when it was off and lower case when it was on. This has also resolved the issue.
Cheers
Paul