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: Most helpful
  1. 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
  2. Anonymous
    2013-05-17T19:19:04+00:00

    It worked for me thanks

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2013-05-17T17:26:05+00:00

    Yes, I had this problem and this solution fixed it. Thank you.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2013-04-13T22:00:09+00:00

    Hi Joe.

    That about the position of the cursor in the cell dictates which direction the multiple cells get generated confirms (to me) what I've said about a short cut keyboard malfunction, bit like dragging a selection.

    I wish you could switch them all off and maybe just choose which ones you want to use. I use word a lot and in my new to me 2007 version I often get editing boxes open for no apparant reason. Another of these damn keyboard shortcuts that make your work harder as you have to keep stopping to get rid of them.

    I think the programmers should have a good think on if what they design is actually needed and not if it's a good gimmick or they feel clever having invented it, does it actually HELP you use the program.

    Was this answer helpful?

    0 comments No comments