Results 1 to 15 of 15
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Appleton, Wisconsin, USA
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    psycho Excel selecting problem (2K)

    Hey kids,

    Has anyone run across this situation? There must be a trigger, but suddenly Excel is in "Select" mode. No matter what you do with the mouse or arrow keys, you can only select a range of cells. You can't "get out" of the mode to type or do anything else. How is this triggered and how do you turn it off?

    THANKS!
    Angela

  2. #2
    2 Star Lounger
    Join Date
    May 2002
    Location
    Midland, Michigan, USA
    Posts
    133
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: psycho Excel selecting problem (2K)

    I have a couple of questions for you:
    1. Does this happen with any one particular workbook, or with every spreadsheet that you open?
    2. Does the Escape key help you out?

    Thanks!

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: psycho Excel selecting problem (2K)

    Does the status bar say "EXT"?
    Does F8 get you out of it?

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: psycho Excel selecting problem (2K)

    Try "pressing and rolling" the wheel on the mouse.

    Steve

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Appleton, Wisconsin, USA
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: psycho Excel selecting problem (2K)

    My problem is that this has happened several times to two coworkers. I'm not sure what triggers it, and so it's hard to duplicate. I'll pass your questions on to them and see if they remember the answers. Thank you!
    =======
    I just played with the F8 EXT thing, and that's similar to the behavior that they're getting, but it's more persistant. With EXT mode, you can start typing something and arrow out of it. But with what they were having, I don't think they could do that.

  6. #6
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    Paragould, Arkansas, USA
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: psycho Excel selecting problem (2K)

    It's not you, Angela (or your co-workers) <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23> . My office still uses Excel 97. Every once in a while, but not as often as you, I get the same deal - your mouse is stuck selecting ranges, and you can hardly do anything. The only out I've sound is to Ctrl-S (save) then Ctrl-W (close) to close the workbook. Finally, shut Excel down & start over. I haven't figured it out myself.

  7. #7
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: psycho Excel selecting problem (2K)

    not only that, but i've had this behavior operate across the board in all office apps. for example, you go to word and click somewhere away from the cursor and everything between the selection gets hilighted. sometime toggling ScrLk works but more often than not -- gasp -- I have to reboot. This is Win2KPro, Office2KPro, but I've seen similar things on other installations. There seems to be something buggy in Windows code that occasionally pops up. In my experience, this tends to happen more often in Excel than anywhere else but it is a huge pain. Doesn't happen too often, thankfully.

  8. #8
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: psycho Excel selecting problem (2K)

    I have this problem on both a Dell and a Gateway. It's especially annoying in File Explorer. Sometimes I can escape the behavior by putting the cursor on the anchor cell in Excel, or first file selected in File Explorer, and Ctrl-Shift-Clicking.
    -John ... I float in liquid gardens
    UTC -7ąDS

  9. #9
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    St. George, Maine, USA
    Posts
    158
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: psycho Excel selecting problem (2K)

    Angela

    This situation can also be due to a sticky shift key. Have them tap the shift key a couple of times to free it up.

    Good luck

  10. #10
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: psycho Excel selecting problem (2K)

    This happens almost daily. But only with Excel and only on my Dell Laptop. I had chalked it up to a malfunction with the touchpad on the laptop. I just exit Excel, bring it back and everything's okay for a while longer... But no real explanation, I'm afraid! <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
    - Ricky

  11. #11
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Appleton, Wisconsin, USA
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: psycho Excel selecting problem (2K)

    So do any of the above suggestions help with your problem, or do you just reboot/restart?

  12. #12
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: psycho Excel selecting problem (2K)

    Strangely enough, I haven't been able to duplicate the problem. I do recall that using the ESC key had no effect. The wheel mouse is not the issue as I have no wheel mouse on the laptop, it's a touchpad. And I'm fairly certain that the F8 key would not have been the cure - it's a different type of action (but I will try it when the problem returns, you never know...)
    - Ricky

  13. #13
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Appleton, Wisconsin, USA
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: psycho Excel selecting problem REVISITED!

    I have another user with this issue now. She writes:
    <font color=blue>Since last Friday, and I've shut down my computer nightly since and the problem continues, when I go into Excel and use my mouse to choose a specific cell, my mouse essentially turns into a scrolling mouse, and I can't do anything except use Ctrl-Alt-Del to end task. If I use the tab key or up/down arrows, then it's fine. This is the only program I'm having problems with.</font color=blue> .

    I asked her to examine the suggestions above and she responded:
    <font color=blue>Since I've rebooted 3 times since this started, I wasn't optimistic, but I tried them all and nothing worked.</font color=blue>

    Can anyone help??? THANKS!!

  14. #14
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Appleton, Wisconsin, USA
    Posts
    188
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: psycho Excel selecting problem REVISITED!

    OK, I think we actually solved this, and I wanted to post the solution in case others run across it. We swapped mouses (or mice? what would that be?)! We gave her an optical mouse and she's all set! <img src=/S/sailing.gif border=0 alt=sailing width=25 height=25>

    Regards,
    Angela

  15. #15
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: psycho Excel selecting problem REVISITED!

    > We swapped mouses (or mice? what would that be?)!

    Mieces, as in "I hate those mieces to pieces".

Posting Permissions

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