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.

Rick


"cjb22" wrote in message
...
How to stop selecting multiple cells with one click 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 :-P.

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.

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

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.

I, too, have had this problem with Excel. On my home computer, restarting
Excel has thus far done the trick; however, on my work computer, I tried this
several times and it didn't work. In this thread, I saw that someone simply
changed the zoom to 100% and that took care of the problem, so I tried that
and it worked for me. It's annoying that I can't zoom out like I would like
to, but at least I can select one cell at a time.

"Elaine" wrote:

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.