tab 3 times then go to next line in Excel

i am trying to scan some barcodes into excel.  i need to scan 3 different barcodes moving to the next column after each scan  then moving to the next row after the 3rd barcode scanned.  any easy way to do this?
rjefAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Phillip BurtonConnect With a Mentor Director, Practice Manager and Computing ConsultantCommented:
If I understand the question, when you press tab, it should go to the next column, except on the third time, it should go to the next line.

Create a table with three columns. Select one (or several) rows with three columns, press Ctrl+L, and click "OK".

Now, if you are inside the table, the tab button works as requested.
0
 
rjefAuthor Commented:
thanks
0
All Courses

From novice to tech pro — start learning today.