Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Nov 2013
    Posts
    2
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Excel: Clicking in one cell annoyingly highlights several cells

    In some of my Excel 2010 workbooks (and in some of my wife's), when I click on a cell to enter data or to drag its contents elsewhere, Excel annoyingly highlights several cells, usually cells below the originally selected cell. While holding down on the clicker, if I move the cursor up to above the cell, the multiple highlighting reduces until, maybe 2-3 cells above the target cell, I'm finally highlighting just the one cell. Note that now the cursor is, however, several cells higher. Why is this happening and how do I fix it. (I note that I tried Excel repair from the MS CD, and it fails. I use MS Office Professional 2010.)

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,206
    Thanks
    14
    Thanked 331 Times in 324 Posts
    Are the cells merged?
    Steve

  4. #3
    5 Star Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    1,107
    Thanks
    39
    Thanked 197 Times in 184 Posts
    Just a remote possibility that it may be more of a hardware issue....Make sure that ClickLock (If available) is not enabled for your mouse in control panel>Mouse>buttons tab. Is the problem reproducible if you open the same workbooks on another computer or if you use a different mouse? If laptop, try decreasing the sensitivity of the touch pad. You may be unintentionally dragging while you are clicking.

  5. #4
    4 Star Lounger
    Join Date
    Jan 2004
    Location
    Ulaan Baatar
    Posts
    518
    Thanks
    1
    Thanked 42 Times in 40 Posts
    This issue has been around for some years, and seems to be connected with using the Page Layout view - switch to the normal layout and it goes away.

    Alternatively I've heard that pressing F8 twice (its a toggle key in Excel) make effect a temporary cure if you really need to stay in the Page Layout view..

    HTH
    Last edited by MartinM; 2013-11-24 at 07:01.

  6. The Following 2 Users Say Thank You to MartinM For This Useful Post:

    Maudibe (2013-11-23),PaulHBS (2013-11-25)

  7. #5
    5 Star Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    1,107
    Thanks
    39
    Thanked 197 Times in 184 Posts
    That's good to know, Martin

  8. #6
    4 Star Lounger
    Join Date
    Jan 2004
    Location
    Ulaan Baatar
    Posts
    518
    Thanks
    1
    Thanked 42 Times in 40 Posts
    It was there in Excel 2007 and is still there in 2010 but only happens rarely in specific files. Must be something fundamental or it would have been fixed.

    It isn't a hardware issue, it travels with the file, but I've never found a proper explanation - just workarounds.

    We 2003 stalwarts are immune

  9. The Following User Says Thank You to MartinM For This Useful Post:

    PaulHBS (2013-11-25)

  10. #7
    New Lounger
    Join Date
    Nov 2013
    Posts
    2
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Thank you. I will try this.

    For others that asked questions in order to help:
    1. I do not have ClickLock (which is available) selected for my mouse
    2. I have no merged cells. (An aside: I almost never merge cells, preferring center-across-selection immeasurably.)
    3. I am using a desktop.

  11. #8
    New Lounger
    Join Date
    Aug 2014
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Fix corrupt Excel files

    Have you used inbox repair utility of Excel that is provided with Microsoft known as “Open and Repair”. Use it and check your problem gets fixed or not. If not then you can use professional Ms Excel repair tool.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •