Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Controlling Keyboard Keys (Excel 97 SR-2)

    From time to time I notice that some special key functions, usually navigation keys, quit functioning normally. Now, a co-worker has a similar problem. We tried exiting then restarting Excel, then tried exiting and cold booting, then restarting Excel, but still no luck. A second user (different pc) opened the same worksheet and had no trouble. But when the first user opens this file, the combo CRTL+SHIFT+DOWN only moves down to the next empty cell instead of moving down and highlighting as it should.
    Is the a file or swtich or something that controls the keyboard keys? Other suggestions are appreciated.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Controlling Keyboard Keys (Excel 97 SR-2)

    Check : Tools, options, transition. Uncheck transition navigation keys.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Controlling Keyboard Keys (Excel 97 SR-2)

    Have you checked the transition settings: Tools, Options, Transition Tab.

    Review the "Option buttons" under the settings section, MSoft Excel menus should be the only one active.

    If the Lotus 1-2-3 Help or the Transition Navigation Keys are active the Crtl+Shift+Down functionality does not work.

    Hope this helps.

    John

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Controlling Keyboard Keys (Excel 97 SR-2)

    Timing is everything.....at least the suggestion is the same.

    John

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Las Vegas, Nevada, USA
    Posts
    334
    Thanks
    8
    Thanked 0 Times in 0 Posts

    Re: Controlling Keyboard Keys (Excel 97 SR-2)

    Thanks to all for your technical support. I'm not sure how my coworker got the Transition Navigation option selected, but it does the trick.

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Controlling Keyboard Keys (Excel 97 SR-2)

    I seem to remember opening a Lotus 123 file in Excel can set some of those options.

    But mostly it has just been the user ("Oh, no, I *never* go into that!" <bg>) that has just been experimenting and has forgotten he/she ever changed anything in there...
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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