In microsoft excel: How do you make a column auto return to the next cell without hitting the enter key?

In microsoft excel: How do you make a column auto return to the next cell without hitting the enter key?
I formated one column (A) and I want it go to the next cell which is below after I have scanned a 16 digit # with my barcode scanner automatically without hitting the enter key. please help

Best answer:

You should be able to left click the cell and drag it down. It should carry the formula all the way to where you stop dragging it!

Tags: auto, cell, column, Enter, Excel, hitting, Microsoft, next, return, without

Under Forum