Protect Column in MS Excel

This tutorial can help you how to un protect and protect specific column(s) or cell in Microsoft Excel.

Step to follow:

Step1. Excel file already open.
step2. on your keyboard press Ctrl+ A to select all cells
step3. on your mouse click right hand button
step4. select Format Cells..
step5. on Format Cells prompt box facility option click "Protection" tab
step6. tick "Locked" checkbox and click OK button
step7. select specific cell(s) or column(s) to unprotect by highlighting through mouse
step8. on your mouse click right hand button again
step9. select Format Cells..
step10. on Format Cells prompt box facility option click "Protection" tab
step11. unticked Locked checbox to unlocked selected cell(s) or column(s) from step 7.
step12. select tab sheet from lower section and click mouse right hand button and click Protect Sheet
step13. On Protect Sheet prompt option facility, unticked Select locked cells checkbox
step14. On Password to unprotect sheet text field enter desire password and click Ok button

Expected results: Unlocked Cell(s) or Column(s) should be editable and the rest should not be editable

Tags: #exceltips #MSExcel #excel