In Excel how do i get the cursor to tab down without the keyboard

  • Thread starter Thread starter DHeckler
  • Start date Start date
D

DHeckler

I use a barcode scanner to make entries into an Excel spreadsheet. How do I
get the cursor to move down a column after a scan?
 
"down a column"?

Try either ActiveCell.Offset(1,0) or ActiveCell(0,1) depending on if you
meant move down a row or across a column.
 
I use a barcode scanner to make entries into an Excel spreadsheet. How
do I get the cursor to move down a column after a scan?
Click to expand...

if you are just scanning in. i would try to protect the cells
- highlight your column
- right click on your highlight
- click format cells...
- click the protection tab
- uncheck the locked button
then protect the worksheet depending on what version of excel you have
- in excel 2007 protect is in the Review ribbon
- uncheck "select locked cells"
- in excel 2003 its under Tools>protection
dont bother to give it a password...just protect it if you have a bunch of
scanning to do in a row.
 
Back
Top