selecting multiple cells in Excel 2007

On Mar 9, 11:17 pm, "Rick Rothstein \(MVP - VB\)"
wrote:
> 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.

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

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

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

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

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

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

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

wrote in message

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