How to encrypt tables

How to encrypt the table: First click on the "File" menu bar and select "Information"; then click on "Protect Workbook" and select "Encrypt with Password" in the pop-up drop-down list; finally in Enter the password for the created file in the text box and click "OK".

The operating environment of this article: windows7 system, Microsoft Office Excel2016, DELL G3 computer

This can be achieved by using the "Protect Worksheet" function .

1. Click the "File" menu bar, select "Information", and you can see the "Protect Workbook" item in the right window.

#2. Click "Protect Workbook" and select "Encrypt with Password" in the pop-up drop-down list.

#3. A password input window will pop up. Enter the password for the file you created in the text box and click "OK".

#4. At this time, another window will pop up, asking us to re-enter the password to ensure that the password was not entered incorrectly the first time. If the input is incorrect, a warning window will pop up. Enter the correct password in the text box and click "OK".

5. Click "Save" when finished.

#6. Next time we open this file, we will first be asked to enter the file password, otherwise we cannot open it. Just enter the password in the small window text box.

[Recommended learning: Excel tutorial]

The above is the detailed content of How to encrypt tables. For more information, please follow other related articles on the PHP Chinese website!