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: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-01-22T12:31:37+00:00

    Excel 2007, regular Dell mouse. The problem was fixed by switching to Normal View. benzo95's steps from 1/4/2013 to recreate the problem did replicate the problem. I can't believe he/she was able to find that combination of settings.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2013-01-04T20:48:26+00:00

    I have tried this and you are correct.  I can also recreate if I have the right column shown by the same amount.  If you click to far in the right of a cell it will select two cells in the row.  If you click more toward the left it will only select the one cell.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2013-01-04T19:32:29+00:00

    I have found how to recreate this problem. Knowing how to recreate it may help bug fixers, and will definately make it easier to work around the issue.

    1. Open Excel
    2. Put in Page Layout Mode and Landscape mode (Landscape mode has nothing to do with the issue, it just makes it easier to demonstrate the problem)
    3. If you'll notice, in page layout mode, Excel displays pages in rows and columns in the Excel Window. Adjust the window so that the very top of the 2nd row of pages is shown in the Excel window. (You can do this with a maximized window by adjusting the zoom, or with an adjustable window just by adjusting the size of the window. (If you see "Click to add data" on the second row of pages, you have too much of the 2nd row of pages showing showing, and it won't "work".
    4. Click on any cell in the first row of pages, except any cells in the last row. It should select multiple cells. It *seems* that the less you have exposed of the second row of pages, the more cells it selects, and it *seems* that maybe the bottom of the header field is the cut off for when it won't happen.

    To recap, when Excel displays the very top of pages in the Excel window, multiple cells are selected with a single mouse click on any cells clicked except those in the last row of the page. Hopefully I have explained this clearly.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2012-12-19T12:11:27+00:00

    This fixed it for me -Does not make sense but it works -  Thanks

    Was this answer helpful?

    0 comments