can i restrict data entry from certain columns

S

surgeandoj

Is there a way to keep data from being entered in all columns afte
column B? The data is scanned by wireless barcode scanner and th
scanner can only have one suffix (i.e. tab, space, enter) {can'
alternate}. This will help in having to go back and cut and paste al
the entered data to the correct position on the spreadsheet
 
D

DNA

Select the cells you do not want to have data entered, lock those cells and
unlock all others. Protect the worksheet but make sure
uncheck "Select locked cells" under the option "Allow users of this
worksheet to"

HTH
 
Top