14 December 2014

Easy Ways to Give Password Protect Specific Cell in Excel Worksheet

One of the advantages of the Microsoft Excel application is the function Protect Sheet. This function can be used to lock the cell in a sheet, which is the goal so that the cell can not be edited. For this occasion I will give you tips and tricks to give the password to protect certain cells or only partially, and some other cells that can still be edited.

With the protection on the file, will maintain the confidentiality of our data in it. by relying on the protection of our files can also be a boomerang for the creator. why? you know how? could have been the creator of the forgotten password of password that has been made. Severe anyway? hopefully not happen to you. But do not worry if it happens, you can open it with a trick that I gave earlier, How to Unlock Cell Excel Password Protectable Without Software.

Easy Ways to Give Password Protect Specific Cell in Excel Worksheet

  1. First block cell which want to be able to edit. Eg in the example image below my block on the cell or range E5, E7, E9, E11 and E13. Then click Format and click once on the Lock Cell to change the selected cell becomes Unlock Cell.
  2. Easy Ways to Give Password Protect Specific Cell in Excel Worksheet
  3. Then click Format once again but this time choose Protect Sheet
  4. Easy Ways to Give Password Protect Specific Cell in Excel Worksheet 2
  5. In the Protect Sheet window, click unchek the option Select locked cells, Do not forget to add a password, then click OK. Confirm Password window will appear, enter the same password again and finally click OK.
  6. Done. If all steps are correct then it should only last cell in unclock alone that can be selected (clicked) and edited, while another cell can not clicked as locked or protected.

0 Komentar untuk "Easy Ways to Give Password Protect Specific Cell in Excel Worksheet"