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!!

On 9 May, 21:06, John A <John wrote:
Can I make Excel respond to tab by going to the next row, once it reaches the end of a range?

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

Wow! I was hoping there was a simple answer, but I never dreamed how simple!

Thanks.

"loudfish" wrote:

On 9 May, 21:06, John A <John wrote:
Can I make Excel respond to tab by going to the next row, once it reaches
the end of a range?

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

On Wed, 9 May 2007 13:06:02 -0700, John A <John
wrote:

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!!