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 No 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 No comments

163 additional answers

Sort by: Newest
  1. Anonymous
    2018-02-08T21:07:24+00:00

    somewhere in this thread I explained exactly how to recreate this problem. If you understand why/when it happens, it becomes clear why adjusting the zoom "fixes" the issue. This issue is not present in Office 2016. I can't remember if it was fixed in Office 2013, but regardless, it has been fixed, and if you understand why it happens it's easy to avoid if you're using old Office software.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2018-02-08T20:46:38+00:00

    This question was first asked in 2010, and it's 2018, and the problem still exists.

    Really? Can this problem disappear, rather than having a work around of jiggling the zoom slider?

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2017-12-26T03:29:20+00:00

    Great answer. I adjusted a tiny fraction and stopped having multiple rows selected.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2017-10-18T16:08:04+00:00

    Ok, I fixed mine by going off 110% Zoom.  When my Zoom is set at 110% it selects two cells. I tried multiple other Zoom conditions and it worked (selected one cell) every time except at 110%.  Whomever, told me to try the zoom/magnification level -THANKS!

    RF

    Was this answer helpful?

    0 comments No comments