Excel 2007, Undesired selection of multiple cells

Anonymous
2010-07-20T19:01:58+00:00

I am using excel 2007, on occasion when i try to select any one cell it will highlight and select multiple cells. Once this occurs it happens with every cell I click on.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
Anonymous
2010-07-29T19:22:04+00:00

I have heard, but cannot confirm, that some people with this problem have found that altering the zoom level (slider in lower right corner of Excel window) gets the multiple seelction to go away

best wishes

people.stfx.ca/bliengme

Was this answer helpful?

0 comments

163 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2012-08-01T19:17:38+00:00

    I'm using a plain old Dell laser mouse and have the problem... It's weird how it's very spotty - only certain sheets will do it while others in the same workbook won't.  :-(

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-08-06T10:42:13+00:00

    I've had this for years, read many "answers" on many "forums". NO ONE has come up with a solution.

    I'm a plumber and if one of my jobs leaks I go back and fix it! (MS pls note but you won't as you're far too arrogant).

    It must be a bug, enabled by a certain conbination of keystrokes as I have it on one sheet of a multiple sheet workbook and not on the whole sheet, I get 7 cells highlighted in the column below the one I select. I'm on an IBM ThinkPad A30, XP Pro S3 with Office 2007. Not the mouse as it's the same with the built in cursor control (even with the mouse unplugged).

    It's a real pain to "work around" and it's in a template and that sheet took a lot of hours to build and all the sheets have linked cells to copy similar information forward. I'm also an electrician and use it to record all my circuit test results and print reports.

    There are many things that work temporarily to disable this bug but it invariably comes back at some point.  I think I will have to bite that bullet and delete that sheet then rebuild it as that is the only way I've discovered to get rid of it. But if you do bt chance hit that certain conbination of keystrokes it will be back!

    Heartfelt thanks to anyone who can come up with a solution to this, we don't want workarounds though, need it SOLVED as those of us who experience it do get very frustrated as it is such a hindrance.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-09-13T13:43:48+00:00

    I have the same problem. Whenever I turn Macro's on and use my refresh macro my cell selection is broken. 

    A workaround for this is zooming out/in or in/out. Or you can add the following macro:

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    ActiveWindow.Zoom = 85

    ActiveWindow.Zoom = 100

    End Sub

    It zooms out/in very quickly whenever a cell has changed. It does restrict zooming.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2012-10-24T03:33:33+00:00

    I own two trackballs by logitech; one wireless the other wired. Both of them do this to me. Doesn't matter if I use excel 2007 or 2010. It's very frustrating.

    Was this answer helpful?

    0 comments