Excel Auto Tabbing in Excel Worksheet Data Entry

[Fred Roushan]

At work, our computer does not have Access, but it has Excel. I am creating a database of clients in Excel. Is there any way to enter contents into a cell, hit Tab button, and automatically move to the next cell to the right and at the end of the row, automatically Tab to the first cell in the next row(entering the next record, client)?
Thanks,
Fred

 

[Bexy]

Hey Fred,

Try this. When you enter data in a cell use TAB to go to the next cell and continue along using Tab until you need to go back to the first column. When you get to the last cell in that row, enter your data and then hit ENTER.

This then returns to the next row in the first column.

Hope that helps
B