Solved

tab 3 times then go to next line in Excel

Posted on 2014-09-18
2
155 Views
Last Modified: 2014-09-18
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
Comment
Question by:rjef
2 Comments
 
LVL 24

Accepted Solution

by:
Phillip Burton earned 500 total points
ID: 40330431
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
 

Author Closing Comment

by:rjef
ID: 40330545
thanks
0

Featured Post

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
Today companies are subjected to more-and-more data, and it won't stop any time soon.  But there are obvious opportunities for reducing data, particularly data duplicated among companies.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question