Home |
Search |
Today's Posts |
#1
|
|||
|
|||
can i restrict data entry from certain columns
Is there a way to keep data from being entered in all columns after column B? The data is scanned by wireless barcode scanner and the scanner can only have one suffix (i.e. tab, space, enter) {can't alternate}. This will help in having to go back and cut and paste all the entered data to the correct position on the spreadsheet. -- surgeandoj ------------------------------------------------------------------------ surgeandoj's Profile: http://www.excelforum.com/member.php...o&userid=25032 View this thread: http://www.excelforum.com/showthread...hreadid=385613 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Excel's XML mapping/export with data organized in columns | Excel Worksheet Functions | |||
How to take matching data from 2 columns and put in the same row? | New Users to Excel | |||
How do you create a selection box for data entry within excel | Excel Discussion (Misc queries) | |||
Comparing data in two columns and highlighting the data | Excel Worksheet Functions | |||
Filtering Text Data from Multiple columns | Excel Worksheet Functions |