Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Help! 123 Arrow keys move sheet view but not cellpointer

Help! 123 Arrow keys move sheet view but not cellpointer

Help! 123 Arrow keys move sheet view but not cellpointer

I'm using Lotus 123 (part of SmartSuite version 9.6.8) under WinXP Pro.  Inadvertently, I seem to have done something that has altered the behavior of the arrow keys, and it's driving me NUTS [g].

For a jillion years, since Lotus for DOS eons ago, I've expected the arrow keys to move the CellPointer (the location of the call where you can enter data).  This morning, that changed and now the arrow keys shift the view of the total windows being displayed up, down, left and right, but the CellPointer stsys locked where it was (and thus is can totally disappear from view).

This applies to all workbooks (even a newly created blank one), so I assume that by mistake I have set my User Preferences awry (probably by unknowingly clicking on one of those inscrutable cutesy-poo icons that GUI designers love so much).

I've checked all my User Setup preferences twice and I can't seem to figure out what I did to cause this.  (Help implies that scrolling behavior is set by the Classic Keys tab within user preferences, but no matter how many times I look at them, I can't figure  out what's wrong.  

I'm sure that this is a blindingly obvious stupid error, but I can't seem to figure out what I've done.  Can anybody tell me how to get the arrow keys back to behaving normally?

Thanks for any help you can offer.


RE: Help! 123 Arrow keys move sheet view but not cellpointer

Have you checked your Scroll Lock Key?

RE: Help! 123 Arrow keys move sheet view but not cellpointer

Danswindow wrote "Have you checked your scroll lock key?"

I'll bet that was the answer!  After posting my message, I decided to try the when-all-else-fails remedy for many software problems -- restart Windows -- and that fixed it.

It didn't occur to me to check the scroll lock key setting because an excruciating careful search of the help didn't turn up ANYTHING for keywords "scroll" or "lock" that mentioned that key and how it affects navigation.  The explanation may well be there, but I couldn't find it. (Maybe it's stored in Write-Only-Memory for security [g]).

I've added a note about the scroll-lock key to my personal HelpMe files, where I record all the crucial stuff that the manuals don't cover and/or don't explain in a way that is clearly comprehensible to me. So if it happess again, I'll have something to jog my memory.

Thanks very much for taking the time to offer your suggestion. Even though I'd "solved" the problem by other means, it always drives me nuts when to use a workaround to fix a probme without really understanding WHY it happened (so there's no assurance that it won't happen again).

For a few hours, I was close to having a panick attack at the thought that my old reliable Lotus was "broken" and I might finally have to throw in the towel and switch to Excel. (As best I can tell, Excel's a perfectly adequate spreadsheet tool in the Visicalc tradition, but I have no desire to waste a whole bunch of time getting up to speed on all the quirky details on how its functions work,)



Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close