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
    2014-03-28T00:13:18+00:00

    It worked, thanks for posting more specific instructions on how to remedy this.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2014-03-11T21:02:01+00:00

    ....

    Again, to be clear, only happens to me when in Page Layout view at 110% zoom.  Maybe zoom level could be different on other people's computers depending on the monitor size?  Does it have something to do with the video driver?

    Just trying to add information for troubleshooting purposes.  Could it be a feature of Excel 2007 that we may not know about, like selecting cells with similar formatting or something?  Even if it is not a "bug" that needs to be fixed, help is appreciated

    • and then maybe it could be added the Excel Help online or something.

    Thanks!  Sue

    In reply to Sue's message above, I seem to have found the solution, in my Excel 2007. The problem occurred on my machine when I was using 103% zoom and "Page Layout" view. I changed the Page Layout view to Normal view (in 100%view), and the problem seems to have gone away for now.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2014-02-08T12:30:27+00:00

    Hi again all.

    Sorry none of those get arounds are a cure, just a get around, there are several but it always comes back once you have it in a sheet or book. You just can't use page layout view to lay out pages!!!!!!!!!!!

    MS NEEDS to sort it, it's gone on long enough and through different versions of Excel.

    We all need to keep mentioning it on forums like this or it'll never be sorted properly.

    I'm on 2010 now and need to do some work with it, dreading it as I know it'll be there at some point and you just can't lay out a page easily if you're not in page layout view, need to keep flicking back and forth.

    So please don't refer to a get around as a cure as it's not.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2014-02-05T18:29:50+00:00

    I have this problem all the time.  Very frustrating.  Bernard's suggestion worked.  Thanks Bernard!

    Was this answer helpful?

    0 comments No comments