Solved Excel click 1 cell selects multiple

DELL Vostro 400
August 14, 2008 at 08:20:09
Specs: Windows Vista Home Premiu, Intel Core 2 Duo; 2.83 GH

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.


See More: Excel click 1 cell selects multiple

Report •


✔ Best Answer
November 11, 2008 at 11:59:16

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



#1
August 18, 2008 at 09:09:57

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 :)


Report •

#2
August 27, 2008 at 10:08:09

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.


Report •

#3
September 23, 2008 at 11:04:42

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.


Report •

Related Solutions

#4
November 10, 2008 at 06:42:11

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.
Jo

Johanne


Report •

#5
November 11, 2008 at 11:59:16
✔ Best Answer

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


Report •


Ask Question