can i restrict data entry from certain columns

  • Thread starter Thread starter surgeandoj
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Eliminating unwanted columns and eEntering data using Barcode Scan 2
Can I restrict a text column to a specific number of characters? 4
How do I restrict data entry to one of two columns 2
Excel sheet setup, need only 2 columns with auto-tab and return 1
Making tab do a CRLF when reaching end of a range 3
find & copy data from most recent entry 2
Data Entry + Validation 3
using a list to return a value from another column 1

Back
Top