selecting multiple cells in Excel 2007

R

Rick Rothstein \(MVP - VB\)

Can you explain this a little more? When I click a cell in XL2007, only that
cell is selected.

Rick
 
H

hierodule

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

Rick Rothstein \(MVP - VB\)

Can you explain this a little more? When I click a cell in XL2007, only
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.

Excel is not my primary area of expertise, but I am not aware of any such
option (nor would such an option make any sense to me). I mean, I can write
an event procedure that will do that, but I know of nothing built-in with
that functionality. Perhaps one of the other regulars here can shed some
light on your problem.

You said it "doesn't happen on all documents"... does that mean it
**always** happens on specific documents (that is, is it repeatable), or is
it a haphazard sort of thing?

Rick
 
H

hierodule

You said it "doesn't happen on all documents"... does that mean it
**always** happens on specific documents (that is, is it repeatable), or is
it a haphazard sort of thing?

Rick

Thanks for your reply.

Hmm, it does appear to be more haphazard than I thought it was.
Closing and restarting Excel seemed to do the trick, and now the
single-clicks work the way the should. But this has happened before,
so I wonder if it's some kind of rare bug that only some users
experience. (Or, could it be actually related to the mouse--I have
Logitech MX518--and not the application? Still, my pointing device
works perfectly as far as I can tell.)

Regardless, I'll try to give a more thorough description of what
happened, if only to give this thread a better sense of closure.

In the Excel file where this happened, I have 12 tabs with one
spreadsheet each (one for each month of the year), and one additional
tab at the end with data I use for the previous sheets (names of
people in a named range for drop-down selects). In the first worksheet
and the final, data sheet, single-clicks worked the way they should,
but not on the other 11 worksheets--where one click would select
multiple cells.

I eventually noticed that when I single-clicked a cell, the following
expression appeared in the Name Box (the box to the left of the
Formula Bar): 5R x 1C. Normally, an expression like that would only
appear WHEN you are click-dragging the mouse to select multiple cells.
Otherwise, only the name of the cell you click appears there, or the
name of any Named Range you have defined. However the glitch was
obviously behaving as if I were click-dragging the mouse, making Excel
automatically grab those cells below.

I Googled or a while and couldn't find any mention of this trouble, so
it looks like the OP and I are the only ones in the known universe
with this experience :p.

Oh well, it seems to be gone for the time being...
 
T

tbachoo7

It happens to me also. I thought it was a click scroll confusion.
still haven't figured out what is going on.
 
T

tbachoo7

Try changing the zoom to 100%. I had mine at 110% it happened. Then
100%, no longer happened!!!!
 
R

Rick Rothstein \(MVP - VB\)

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
 
P

pianist38

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
 
P

pianist38

I am having the very same problem. I use an LX5 Logitech mouse. The zoom
level sometimes eliminates the multiple row selection... sometimes merely
changes the number of rows the click selects. Aggravating, 'tis!

~Sarah Lynn~
 
A

Adam.Warmack

I have the same problem. I can sometimes make it go away by closing
the document or by switching to another view. It shows up
sporadically regardless of what file is open. Very irritating.
 
L

LeahT

Oh good! I thought I was alone in this issue!!! It is driving me crazy!
Although, I have to admit, this long line of people having this problem and
no answer to how to resolve it is very disappointing! Has anyone figured out
what the issue is!?

(PS: I had the problem when using a logitech, a dell laptop mouse pad, and
the current mouse which is a gateway)

-Leah-
 
L

LeahT

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.)
 
L

Legallisa - switching from WordPerfect

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


OK all you MVPs, figure this out for us!!! This is happening to me too, on
almost all files. Driving me crazy. I thought I might have accidently hit
F8 or SHFT F8 but that wasn't it.
 
L

LeahT

Okay...sooooo I have noticed something new with this phenomina...I am not
sure about anyone else...but it only happens to me in "Page Layout" view. The
most likely time for it to happen is when I have two pages (ie: page 1 and 2)
both visable on my screen at the same time...for example, I am getting close
to the end of page 1 and my screen scrolls up to reveal the top of page
2...it will suddenly start happening them. If I scroll the page back up to
only show page 1 on the screen...it stops happening.

Let me know if anyone else experiences this. I am starting to think there is
a tiny clitch in the "Page Layout" view.
 
L

leofwilson

I've been having this a lot recently (Technika MINIMSE02, so I don't
think it's a mouse issue).

Changing the zoom level seems to fix it each and every time, so I'd
say it's a click detection issue - Excel believes I'm selecting a
wider area than I am.
 
L

LeahT

I have noticed that my previous observation regarding the layout view has
been spot on every time I have this issue. A co-worker had also mentioned the
issue and I instructed her to try scrolling so that only one page showed on
the screen and it resolved the issue for her as well.

I am not sure if anyone else has noticed that this is only happening in
layout view or not because there weren't any responses to my previous post. I
have noticed though that this is when it happens for me and those in my
office and that the fix is simply to make sure there is only one page showing
at a time when in layout view.

I would love to know if others have found this to be the case as well.
 
M

megangomez

I experienced this problem today, and after implementing the suggestion of
scrolling through Page View to show just one page, the error corrected
itself. I can show two pages side-by-side in Page View without the clicking
issue, but if the bottom of the pages are showing at all, the clicking
problem returns. What the heck?! I now know how to deal with it, but what
an annoyance. :-(
 
E

Elaine

Having the same issue. Just posted in the more recent item titled "Excel
keeps selecting two cells". I have a Microsoft Intellimouse Optical USB... I
doubt this has anything to do with the mouse.

Closing and reopening the document does not help. Restarting excel does not
help.
 

Ask a Question

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.

Ask a Question

Top