Two methods to lift Excel’s “restricted editing”

php editor Zimo introduces you to two methods to remove the "restricted editing" of Excel, making it more convenient for you to process Excel files. Excel is a powerful office software, but you may encounter limitations that cannot be edited when using it. Through the following two methods, you can easily lift editing restrictions in Excel and improve work efficiency.

Another limitation is to set it to "read-only mode", and a prompt will appear when opening the Excel table.

We can use the following two methods to lift it according to different restriction settings.

First of all, we can check whether there is an [Unprotect Worksheet] option on the toolbar below [Review] in the Excel table. If so, click directly and a dialog box for entering a password will appear. Enter the originally set restriction password. Press [OK], and the "restriction protection" will be cancelled.

The Excel table can be edited freely.

If the restriction method of the Excel table is set to "read-only mode", we can lift the restriction by "Save As".

First, click [File] above the Excel table, select [Save As] in the list, and then select the new path to save the file after removing the restriction on the right.

After selecting, the [Save As] dialog box will appear. Click [General Options] in [Tools] below.

At this time, a dialog box for entering the password will appear. You can see that there are already passwords in [Modify Permission Password]. You only need to delete these passwords and turn them into blank spaces, and then press [OK]. At this time, the newly saved Excel will remove the "read-only mode".

Both of the above methods need to know the original password to unlock it. The first method requires you to enter the password before opening the Excel table, and then remove the password after opening it; the second method requires you to open the Excel file and enter the password to edit it, otherwise you can only " Read Only", if you don't remember the password, you can't remove the restriction.

But we can use other tools, such as the Pepsi Niu Excel Password Recovery Tool, which can directly cancel the "restriction protection" and "read-only mode" of the Excel table without a password.

Select the [Unrestriction] module in the tool, and then import the Excel table.

Tool link: Pepsi Niu Excel Password Recovery Tool

After the operation is completed, click [Go to View] to find the unrestricted Excel.

The above is the detailed content of Two methods to lift Excel’s “restricted editing”. For more information, please follow other related articles on the PHP Chinese website!