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)
Excel selects multiple cells instead of one (cells are not merged) - When clicking on a cell, Excel will select multiple cells around the intended selection. Also, the number of cells automatically selected and position of the selection is random each time the intended cell is clicked on.
Shift + Arrow Keys will select correctly but is not practical to use every time.
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.
Might be EXT mode - touch F8 to clear this
Might be Sticky Keys - touch SHFT 5 times to clear this
gsnu201004
To expand on EXT mode: Regarding EXT mode this is turned on or off in 2007 by pressing F8. It is also called Extend Selection in 2007 or later and if the Selection Mode option has been turned on for Excel's status bar you will see "Extend Selection" displayed. This mode can also be turned off by pressing Esc.
If this answer solves your problem, please check Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers, Shane Devenshire
In the right bottom of your screen, there is a zoom in and zoom out (+) or (-) just click the + or - twice or thrice, your excel cells will go back to normal. I don't have an explanation of this, but It works for me.
I use Excel 2010. The selection of a cell works fine until I select landscape orientation, then a cell selection shows 2 cells unless I click close to the top of a cell. Moving the cursor to the space immediately over the first row of cells and clicking when I see the message "hide white space" has solved my problem.
Thanks AdamClarke91
I had the same problem. In my situation, I was in View > Page Layout mode. Switching to Normal mode cleared the problem. It is also true for Page Break Preview mode. This problem would start randomly and it was driving me crazy. Thanks to all who post solutions.
Microsoft Home and Office 2010