Making tab do a CRLF when reaching end of a range

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a hand scanner to scan asset tags and serial number off of
decomissioned equipment. The hand scanner can be programmed to do a tab (OR
a CRLF) after entry. I have a two column spreadsheet, so I scan the asset,
Excel tabs to the next column, then I scan the S/N. But after I scan the S/N
I have to go back and hit the Enter key to go to the next row. Can I make
Excel respond to tab by going to the next row, once it reaches the end of a
range? That is, when tabbing from the last column of a range, I'd like it to
go immediately to the next row, mimicking the Enter key. So it will traverse
my entire spreadsheet (horizontally and vertically) using only tabs?

Thanks for your help!!
 
Yes. Highlight the range (highlight the two columns). Now when you
tab, it will move through your selection, so from the 2nd column, a
tab should move to column 1 in the next row.

HTH

Andrew
 
Alternate method. No range selection needed.

Start in A1 and Tab across to G1.

Leave G1 by hitting ENTER key to go to A2. Assuming your ENTER key is set to
move down after entry.


Gord Dibben MS Excel MVP
 
Back
Top