Tom's Guide | Tom's Hardware | Tom's Games
![]() |
![]() |
![]() |
I'm running across the same issue as a previous poster ( http://www.computing.net/answers/of... ) in Excel 2007. Namely, that often when I click on a cell in excel, that cell and several cells below it will be selected (rather than just the cell I'm clicking on). The previous post had no replies posted, so I don't know what causes it or how to solve it.
One thing that I have noticed is that if I click super-fast, I only select one cell. If my clicks are longer (a longer fraction of a second), it will select cells in multiple rows. What it looks like is happening from my experimentation, is that Excel is interpreting my click as a multi-column select, and for some reason is using a point x pixels down as the end of the drag. Thus, multiple rows are selected. If the row is taller and I click near the top of the cell, I only get one cell selected, whereas when I click near the bottom of the cell, multiple rows are selected.
Re-opening the document I was working on seems to have returned Excel’s behavior to normal. I haven’t used Excel long enough to know if this will be a recurring issue. That being said, is this something others have run across (other than the previous poster I mentioned), and do people know what’s causing it and if there’s a fix available?
Thanks.

yeah I've seen it but from what I have read MS haven't yet admitted to it being a recognised issue.
Realise it isn't much help, but if you use the keyboard it doesn't happen :)

Here are a couple of things I found out.
1) When you click a cell and hold, if you move the cursor above the cell while holding the button, you can get just the cell/cells you want.
2) If you click really fast you get just the cell you want.
To me this all seemed like a cursor position recognition problem. I did a couple of tests, and found that when you don't have the page maximized, it works just fine.

I am having the same problems with Excel 2007. It started with cells above and below being selected. I figured it had something to do with my scroll wheel. I would make sure the wheel was not in between clicks and then clicks on some merged cells. This would fix the problem. However, now I am getting cells to the left and right selecting and my scroll wheel does not go left or right. I've tried closing excel and reopening the file but same thing. Sofar I can't get it to stop doing it.

I've noticed that if you hit "undo" when this starts to happen it reverses itself so I suspect it's a choice the user is making unwittingly since, as one poster pointed out, going out of excel and back in does not correct it. Hope that helps.
JoJohanne

I have the same problem. However, I found that if you right-click, (menu pops up), but only the one cell is selected. Then, if you immediately, left-click the menu goes away and the cell remains the only one selected. So I've just got into the habit of doing right-click/left-click combos for cell selection whenever this problem happens.
Regards,
Gerry

![]() |
![]() |
![]() |

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.
| Ads by Google |