Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 168
  • Last Modified:

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?
0
rjef
Asked:
rjef
1 Solution
 
Phillip BurtonCommented:
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

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now