Question: what is the difference between cell lock and column lock?
Answer: Locked Cells But even though cells may be locked, the "locking" doesn't go into effect until the user also protects the worksheet. In order for the contents of a cell to be safe from being accidentally deleted, the cell must be locked AND the worksheet or entire workbook protected.