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: Oldest
  1. Anonymous
    2016-01-30T14:09:56+00:00

    For any still running into this, if you're in page layout view, switch to normal view.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2016-02-27T06:27:12+00:00

    More specifically, it only happens to me if some part of the page below is in current view (Also applies Excel 2010). This might be why zooming solves problem temporary.

    And if I release mouse button instantly, it doesn't happen in any view.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2016-03-19T20:28:17+00:00

    When is Microsoft going to correct this? 

    the answer to your question, nearly 6 years later is  ...   "NEVER!"

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2016-03-29T14:34:38+00:00

    Hi all.

    It will take ALL of us to keep on asking MS when they are going to do something about this. One day someone actually from MS will read it and respond positively.

    There is no solution, it only happens in page layout view which is what most people use to make, alter or edit a spreadsheet they intend to print so they can keep the layout fitting their chosen page size.

    There are some get-around's that work but to solve it you have to NOT work in page layout view, keep flicking back to it to check your layout while you're selecting cells with the cursor to edit them.

    If you bother to run through all the comments over the years there are many gushing about thanks for fixes but there are none, if your book or sheet gets the bug it's there for it's life. I've completely rebuilt books to get rid of it, only to find in days, weeks or months it comes back.

    I'm sure it's a fault with keyboard short-cuts, there are so many of them and you can't turn them off so you inadvertently press two keys together and it happens, the bug is there.

    There is just so much of this extra controls business that it makes the programs far too complicated, reams and reams of code your machine has to wade through to work. Be FAR better if we could open the programs in SIMPLE view with NONE of all those shortcuts enabled, if we find we need one we can enable it!

    But I'm just a grumpy old man, started off using 'Works' on an Apple IIe in the Sahara desert when I worked for an American oil company. Been through all the OS's and versions of Windows and Office suites.

    It's sad that these days the makers divorce themselves from their customers and we have to rely on forums and social media to help each other with program problems.

    This one has gone through many incarnations of Excel on many versions of OS, it MUST be a coding bug so definitely down to MS to fix it if they can be bothered. I bet the people who have visited this thread are a fraction of those affected by it.

    So all you moderators get and pass this problem up, you may have access to MS that we don't as paying customers!

    Needing forums is an admission by the maker that they are incapable of sorting out their mess.

    Was this answer helpful?

    0 comments No comments