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
    2013-08-26T20:37:12+00:00

    I have had that problem too in Excel 2010.  If the slider bar doesn't fix it, I found that to the left of the slider bar, there are three little icons, and clicking on the first did the trick for me.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2013-08-14T11:42:58+00:00

    I've just started having the same problem. One of the people said that zooming in can help, its TRUE. I think its because when you zoom out too much the pointer stays the same size, in this case its too large for the cells in the worksheet so it will select more that one row.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2013-07-12T20:57:11+00:00

    I didn't expect this to work, but it did! F8 did not work for me. Zooming out then back in worked.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2013-05-27T13:14:45+00:00

    I am using Excel 2007 also, on Windows 7.  Used Excel a TON for YEARS and have never had this problem before switching to this computer and configuration a couple weeks ago.  It just started today, shortly after I started working in a spreadsheet I have used many many times before (but not on this computer).

    I find I have the problem particularly when I am at 110% zoom level.  Changing it seems to snap me out of it.  Changing from Page Layout view to any other view also stops the problem.

    Currently it only happens on one particular workbook and any others based on this workbook.  Would be too complicated to recreate the workbook to get rid of the problem.

    Yes, using the arrow keys and keyboard seems to move me around okay, but there are things you can't do efficiently with the keyboard like select non-contiguous cells.

    I am using a Logitech cordless scroll mouse, which some people on other forums have linked to the problem - possibly a driver issue?  Tapping the scroll wheel doesn't help, though.

    I do not have a physically or virtually "stuck" Shift Key, and no where in my Excel window does it say I am in Extended mode.  Closing the spreadsheet or Excel and reopening the spreadsheet doesn't help.

    My multiple selections are usually 1-2 cells to the right of the cell I am selecting - in other words, all in the same row and contiguous. 

    Clicking really fast doesn't work for me, and neither does clicking multiple times on the same cell or clicking in any particular area of the cell (such as towards the very top).  One thing that does work for me is selecting the cell(s) and then dragging my mouse to the left until only one cell is selected - usually I am halfway into the cell to the left before my selection is only the cell I want.

    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

    This has been driving me crazy for weeks, and its with just 1 file.  Changing the view from "Page Layout" to "Normal" worked.  Many many thanks.

    Was this answer helpful?

    0 comments No comments