1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Excel 2003 question.

Discussion in 'Other PC Software' started by OLDSALTY, 2005/11/10.

  1. 2005/11/10
    OLDSALTY Lifetime Subscription

    OLDSALTY Inactive Thread Starter

    Joined:
    2003/02/21
    Messages:
    573
    Likes Received:
    0
    When I finish filling in data in a row and hit return how do I make the cursor jump to the first column in the next row?
     
    OLDSALTY,
    #1
  2. 2005/11/10
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    Have a play with ....

    Tools > Options > Edit & check 'Move selection after enter' & select an option from the dropdown menu.
     
    PeteC,
    #2


  3. to hide this advert.

  4. 2005/11/10
    OLDSALTY Lifetime Subscription

    OLDSALTY Inactive Thread Starter

    Joined:
    2003/02/21
    Messages:
    573
    Likes Received:
    0
    That just moves the cursor to the cell under the cell I just entered data in. I want it to go down and then all the way to the left to the beginning of the next row so I can start the next record.
     
    OLDSALTY,
    #3
  5. 2005/11/11
    PeteC

    PeteC SuperGeek Staff

    Joined:
    2002/05/10
    Messages:
    28,896
    Likes Received:
    389
    OldSalty

    If I understand correctly you want to fill data into a row of cells across a spreadsheet and when you reach the last column you want the cursor to jump back to the first column, but one row lower. i.e. to the first empty cell in the first column ....

    In Tools > Options > Edit check 'Move selection after Enter' and select down.

    Type your data in the first cell and hit the Tab key to move to the next cell in the row.

    When you reach the end column of that row, enter the data and hit the Enter or Return key and the cursor will jump back to the first column, one row lower.
     
    PeteC,
    #4
  6. 2005/11/11
    OLDSALTY Lifetime Subscription

    OLDSALTY Inactive Thread Starter

    Joined:
    2003/02/21
    Messages:
    573
    Likes Received:
    0
    OK Thanks Pete I was not using the tab key I was using the arrow or the mouse and that makes the cursor do something different.
     
    OLDSALTY,
    #5

Share This Page

  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.
    Accept Learn More...