10 steps to lock worksheet on excel file

There are many ways to protect your work from irresponsible peoples. Likewise, your works which you stored in excel form file.  Beside you can protect your file by password to open it; you can protect your file by lock the worksheet. So, there is no one can modify your excel file. By this tricks, you can keeping share your file with partner or your coworker. Absolutely, there will be no worry about your work will modify by others. So, how to protect worksheet on your excel file? Follow the instructions step by step and screenshot below.

How to protect worksheet on your excel file?

Ten steps to protect your file on excel

  1. Open your excel file

  2. Hover your mouse to worksheet’s name, and right click on your mouse. 


  3. kunciaceltakbisadiedit

  4. Check “protect worksheet and contents of locked cells” box.

  5.  Check “select locked cells”.

  6. Check “select unlocked cells”

  7. kunciaceltakbisadiedit

  8. Type your password on “password to unprotect sheet” box.


  9. kunciaceltakbisadiedit

  10. Click “ok”

  11. Type your password again to confirm that your password want are correct. 

  12. Click “ok”

  13. Done.

The screenshot sample was showed, how to protect sheet one. You can protect sheet two, sheet three and until the end by the same ways. After you gave password on your sheet, you can save your file like usually.