single click selects multiple cells

  • Thread starter Wes from Scottsdale
  • Start date
W

Wes from Scottsdale

WinXP SP3 Excel 2007 SP2
Intermittently, when my user single clicks on a single cell, Excel will
select it along with 1-2 cells beneath it. If the cell is double-clicked,
the cursor shows the cell in edit mode with the additional cells selected.

It doesn't seem to matter how close the click is to a cell border. I've
also cleaned out the keyboard to make sure it wasn't a sticky shift key. The
selected cells are always beneath the click and have no correlation to the
previously selected cell.

It doesn't happen all the time and the same cell can be clicked mulitple
times with different results, sometimes selecting only one, other times
selecting two or three cells.

Any ideas?
 
C

Curtis

I've also experienced this. It's almost as if the "F8" function is locked
on. The only way I've been able to resolve this is to close Excel completely
and restart.
 
M

MichAda

From what I've been reading, a workaround is to change the zoom settings, or
pressing F8, will temporarily resolve the symptoms, but does not fix the
problem.

I've started just clicking the text bar, and navigating cells with the arrow
keys.
 
J

Jay

I found this on another forum:
"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. "
 
D

david s.

i also have been annoyed by this. i have been thinking it happens when there
has been cell merging or multiple row inserting used. i typically always use
page layout view, so can't say if it happens in normal view, however, it
doesn't seem to matter how many pages i have on a worksheet, in fact most of
my docs are single page. Closing and re-opening a file has no had any effect
for me. I am please to see the work around though, as i too have been
selecting a nearby, uneffected cell and navigating with the arrow key.

the problem is, i work with extremely novice users who tend to freak out
over anything out-of-the-ordinary...........

i am using Excell 2007 BTW

and looking forward to someone knowing what the deal is and posting it.
 
G

Giovanna

Has anyone found a remedy for this problem? I have tried the "f8" fix but
that does not work. I am getting with 1 click the two cells below are also
highlighted. The issue is sometimes I need to delete complete rows and this
selects 3 at a time. I can't get it to stop doing this. Any help would be
appreciated.
 
E

Ewald

Hi all,

Same issue here,

I'm using Excel 2007.
The problem occurs in Page Layout view only.

I found it is related to the Exel file, not the computer: tried the
problematic file on another computer with the same result.

I'm normally using a laptop (1280x800 pixels) with an additional monitor
(1600x1200 pixels).
Displaying the file full size on the lapton screen, the issue does not occur.
Displaying it full size on the "big" screen trouble starts. Making window a
bit smaller suddenly solves the issue. Full size again and the problem is
there again.
Other computer I tried has only one 1600x1200 monitor attached, same issue.

Hoping for a solution.

Regards,

Ewald
 

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