C
cjb22
How to stop selecting multiple cells with one click in Excel 2007
Can you explain this a little more? When I click a cell in XL2007, only that
cell is selected.
I experience the same problem periodically: a single click on a
spreadsheet is selecting a cell and several more below it (four more
in my case). It doesn't happen on all documents (especially new
ones), though. No idea why it happens or where one can "turn it
off"... I guess it must be some kind of option that becomes active
while creating the sheet, but I haven't been able to find anything
about this yet.
**always** happens on specific documents (that is, is it repeatable), or is
it a haphazard sort of thing?
Rick
Rick Rothstein (MVP - VB) said:I still wonder what is behind this as I cannot make it happen here at all. I
tried several new and old documents, some for XL2003 and others from XL2007,
and single clicks are single clicks no matter what zoom level I am set at. I
wonder if it is mouse driver related in some way. I am using a Logitech
mouse (G7 if that matters) and I do not have the problem. Why don't those
having the problem post the mouse you are using... perhaps if they are all
the same mouse (driver), then that company could be approached to solve the
problem. If the mouse (drivers) differ in any way, then stop posting as that
would not be what the problem is.
Rick
LeahT said:As a side note...I have noticed that if I use the arrow keys to select one
cell and then hit "ctrl-c" and copy it somewhere. That usually resolves the
issue for a while! (dunno...I am doing a lot of copying though...half a row
copied to a different row seems to fix it if I use the arrows and
"shift-arrow" to select.)
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.