Results 1 to 4 of 4

Return to start of next line for data entry

This is a discussion on Return to start of next line for data entry within the Excel Questions forums, part of the Question Forums category; I am filling in data to a number of cells in a row of data, and at the last cell, ...

  1. #1
    Board Regular
    Join Date
    Jun 2005
    Location
    North Queensland
    Posts
    824

    Default Return to start of next line for data entry

    I am filling in data to a number of cells in a row of data, and at the last cell, when the Enter key is pressed, I want to automatically go tothe first cell in the next row.

    Can anyone please advise if this is possible using Excel?

    regards,
    Joe
    My regards,

    Joe

  2. #2
    Board Regular Blade Hunter's Avatar
    Join Date
    Mar 2008
    Location
    Sydney, Australia
    Posts
    2,837

    Default Re: Return to start of next line for data entry

    If you press TAB to get to the next cell then enter when you get to the last one it will take you one row down and back to the left to where you first started using TAB.

    Example:

    Cell A1 enter something then hit TAB which will take you to B1, do it three more times and you should be in E1

    Press Enter and it should go to A2
    .select, overused and inefficient.

  3. #3
    MrExcel MVP Robert Mika's Avatar
    Join Date
    Jun 2009
    Location
    (current) UK, (origin) Poland
    Posts
    7,217

    Default Re: Return to start of next line for data entry

    Use Tab key after every cell(not the arrow key)
    So:
    A1: Enter data--Tab
    B1: Enter Data -Tab....
    when you hit Enter after last cell in row Excel should bring you back to the first cell of entry in next row A2
    - Read the Posting Guidelines, Forum Rules & FAQs
    - Want to post a small screen shot? Try one of these Excel jeanie, MrExcel HTML Maker or Borders-Copy-Paste
    - If posting vba code, please use Code Tags .

  4. #4
    Board Regular
    Join Date
    Jun 2005
    Location
    North Queensland
    Posts
    824

    Default Re: Return to start of next line for data entry

    Many thanks Robert and Blade Hunter. I have been using Excel for years ( mostly with VBA) and never knew this!
    My regards,

    Joe

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com