Data Entry across columns

  • Thread starter Thread starter Mike the Kiwi
  • Start date Start date
M

Mike the Kiwi

I want to add data to my spreadsheet across say 10 columns (hence the direction moved after Enter would be to the right), but
I would like to know how I can set it so that once I have reached the 10th column, when I press Enter again the active cell
would pop back to column 1 for the next row of data entry.
I know there is a way to do this.

All help is appreciated.
Cheers
Mike the Kiwi
 
Thanks Debra


Debra Dalgleish said:
After you enter data in each of the first nine columns, press the Tab
key to move to the right.
After you enter data in the tenth column, press the Enter key to move
down one row, and back to the first column.
Click to expand...
 
Back
Top