How do you encrypt a specific area cell in Excel2013?

Confidentiality in any place will be more or less necessary, Excel is no exception, in the Excel2013, there are many ways to encrypt, today we have to learn is how to Excel2013 specific areas of the cell encryption.

The following are specific practices:

1. Open a worksheet with Excel2013, select the area we need to encrypt, switch to the Review tab, and click the Allow users to edit range button.

2, there will be a "allow users to edit the area" dialog box, we click the "New" button.

3, jump to the "New Zone" dialog box, we in the "Zone password" text box in the password, and then click the "OK" button.

4, at this time will pop up a "Confirm Password" dialog box, everyone in the "Reenter Password" text box again enter the password, and remember the password, and then click the "OK" button.

5, back to the Allow users to edit the range dialog box, we click the Protect Sheet button to activate a password-protected area.

6, there will be a "Protect sheet" dialog box, we in the "Unprotect sheet protection using the password" text box to enter the password to protect the worksheet, you can be different from the previous password, and then click the OK button.

7, now will pop up a "Confirm Password" dialog box, we re-enter the password, and then click the "OK" button.

8, OK, we give specific area cell encryption work has been completed, now to check the results. When we double-click the encrypted cell to modify it, a "unlock area" dialog pops up, and the contents of the cell can be modified when we enter the area password that was previously set and click OK.

Tip: When we set up a protection worksheet, the contents of almost the entire worksheet are not changed arbitrarily.