How to Lock a column MS Excel
some time we need to lock a column from the end user protecting from accidental changes.
1 data1 =fun(A1)
2 data2 =fun(A2)
3 data3 =fun(A3)
We want the user to allow key in data in column ‘A’
Function given in column ‘B’ will produce result and user will be able to view the result.
we don’t want the user to select/edit the cells of column ‘B’
steps how to achieve this:
 Select the columns (or rows/cells) the user should be able to to TYPE data into.
 Format menu / Cells / protection tab
 Remove the tick-mark from ‘locked’
 Tools menu / protection / protect sheet and apply protection
You will find that you can only type data in the cells that you selected and then removed the ‘locked’ tick-mark from.
This is applicable for cells, columns or rows..