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 was happening in Excel 2013 and below is what fixed it:
Excel options>Advanced. Under Lotus Compatibility, make sure the Transition Navigation Keys checkbox is not checked (see attached).
SteveJM
When I am in "Page Layout" view and I am NOT full screen I have this problem without a doubt. Now, if I stay in that view and magnify the view to 120% the problem goes away. However, if I switch to "Normal" view the problem goes away as well and I can stay at 100% magnification view. You just have to try one of those and see what you prefer. It's totally weird that this "fixes" the problem, but even more weird the problem exists in the first place.
Hope that works for you. Worked for me and it seems to work for others, too.
Good luck.
Hi Darren.
Just a question for my personal info. Did the bug come back after the getaround was used, maybe not in that session but if you went back to that same sheet/book and tried to edit it?
Has it ever happened in another sheet/book?
I've had this for years, made a lot of sheets and books over those years. Now I have
learned to live with this annoying bug but it still wrankles as it just shouldn't happen.
I actually upgraded my version of Excell thinking that would cure it, no such luck and am on several after and it's still there.
I use basic templates then tweek them for individual cases so do, do a lot of cell size and shape editing so data fits an A4 printed sheet for hardcopy for clients.
This bug hits and it's a real pain to edit when not in page layout view.
It's years now and MS never have taken notice of this thread and the bug gets passed on down with new versions so they don't rewrite the whole program ever.
Hopeful of your reply
SteveJM
I had the same problem. I tried the zoom like Bernard suggested and it worked. That is the weirdest thing, but solved my problem. Thanks, Bernard!