1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Simple Excel Question - Right arrow

Discussion in 'Business Applications' started by P Michael, May 18, 2004.

Thread Status:
Not open for further replies.
Advertisement
  1. P Michael

    P Michael Thread Starter

    Joined:
    Nov 12, 2002
    Messages:
    44
    It's been a while since I've used Excel and it's time to update my gas mileage sheet. I seem to recall that I could enter a date in column A and then press the right arrow and the selected cell would move to column B and so on. But instead the whole screen shifts as in panning. Any ideas?
    ~Peter
     
  2. angel

    angel

    Joined:
    Dec 2, 1998
    Messages:
    2,736
    Do you by chance have the Scroll Lock enable on your keyboard?
     
  3. Couriant

    Couriant Trusted Advisor

    Joined:
    Mar 26, 2002
    Messages:
    31,944
    First Name:
    James
    Yup should be the Scroll Lock's doing :) (on the top right inbetween PRTSCN and PAUSE/BREAK)
     
  4. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    Nope. Actually, what he's got is Lotus settings under Tools-Options, Transition tab...

    :D
     
  5. P Michael

    P Michael Thread Starter

    Joined:
    Nov 12, 2002
    Messages:
    44
    It was that I had the scroll lock button on. I looked at the transitions tab and didn't notice anything odd. Thank you.
    Now what does the scroll lock do -- or used to do?
    ~Peter
     
  6. Anne Troy

    Anne Troy

    Joined:
    Feb 14, 1999
    Messages:
    11,746
    First Name:
    Anne
    Cool. Being wrong means I learned sumpin! :D
     
  7. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    Good question.

    http://www.straightdope.com/mailbag/mscrolllock.html

    What it effectively does in XL is allow you to move around the sheet without affecting the current selection, be it a cell or a range. I can't however think of any practical use for this.

    Purely for the hell of it, see the "most I can manage to fill up my status bar 'boxes'" pic.

    Rgds,
    Andy
     

    Attached Files:

  8. Couriant

    Couriant Trusted Advisor

    Joined:
    Mar 26, 2002
    Messages:
    31,944
    First Name:
    James
    At last someone that admits being wrong :) And you're right, we do learn something everyday here on TSG when we're wrong (or kinda off... :D)
     
  9. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/230375

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice