Excel: Want to scan bar code then tab to next column instead of moving down a line in the same column

Question

My question is how can I scan a bar code and tab to the next column in Excel instead of moving down vertically in the same column?

I am using a Powerscan PM9500

Answer 1

You can change the direction of pressing Enter.

See https://www.makeuseof.com/tag/make-enter-key-excel-move-different-direction/ for instructions

Go to File -> Options

This may or may not work not sure if you’re scanner is pressing enter after a scan. (I’m guessing it does)

Answer 2

Additionally to @PeterH 's answer, you can also modify your barcodes as to replace the EOL character with a form field control Tab character instead of a Line Return. Depending on your barcode and scanner system, it's possible you may need to consult the OEM of the scanner units or the barcode encoding software.

EDIT: I just noticed you had included the model number of your barcode scanner! Please refer to your product's user manual starting from page 341, which will walk you through how to input form field control characters for each applicable platform. In case the link ever breaks, I've hosted a copy here as well.