Excel file is a file format that you can often use to produce relevant data technology documents, the production of a problem form contains a lot of the author's efforts, the form of the form, data, formulas have been modified, will have an impact on the business of the entire form.convert word to pdf with embedded excel files So need we need to excel in the table content of environmental protection. Today, we share with you how to set up their own security protection ability to excel table and students how to cancel the protection, there may be forgotten excel password how to cancel the protection.

Set excel encryption

Method one:

The easiest way is to set protection for the entire Excel worksheet. After opening the Excel file, go to the "Review" toolbar, click "Protect Sheet", and enter the Excel password to be set, just click "OK".

Method two:

If you want to more accurately protect the excel table, we can choose to protect some cells,jpg to pdf converter and combine so that the form can not be edited by others, but other cells can be edited by others. Set the steps as follows.

Open Excel File and select the entire worksheet, right-click and select Format Cells

In Cell Format select the "Protection" tab, we will uncheck "Lock" and click "OK".

Then by deselecting the worksheet, select the table we need to protect, right click again and select [Set a cell format].

To select protection, we need to check the lock and click OK.

Finally, we need to set up sheet protection for the worksheet. Click on the toolbar in the [Audit] - [Worksheet Protection], enter the password for Excel, and finally click [OK] to complete the protection of some cells.

Cancel excel protection

Have you learned the two ways to protect Excel? Next learn how to cancel the protection, when we want to edit the file we need to cancel the protection to edit, cancel the protection of the method is very simple, and the first method of setting up the protection of the same - [View] - [Cancel protection worksheet] - [Enter Excel password] - [OK] you can cancel the protection.

Forget the password how to do?

After setting the excel password, we may appear to forget the password situation,word to pdf converter online free i love pdf resulting in us through their own businesses want to edit excel files are not; there as a development situation analysis is because we need to download the excel table template on the Internet, open China after the study found that the problem is set up excel protection, we do not know the password, so there is no way to copy, Edit the form. Above these situations, want to get a solution, the most direct method is to retrieve the excel password, but the micro office does not provide the community to retrieve the password system function, we can only learn according to their own ability to continue to innovate to try to utilize a variety of passwords. Or you can also effectively try to use management tools, without password directly cancel excel protection.