Two methods to set the "read-only mode" of an Excel table

php editor Xinyi introduces you two methods to set the "read-only mode" of Excel tables to make your data safer. At work, it is particularly important to protect the security of data. By setting read-only mode, you can prevent others from modifying the table content and ensure the integrity and accuracy of the data. Next, we will introduce the operation steps of these two methods in detail, allowing you to easily deal with various data protection needs.

1. Passwordless “read-only mode”

If you mainly want to prevent yourself from accidentally modifying the table, you can set a "read-only mode" without a password.

After opening the Excel table, click [File]-[Information]-[Protect Workbook]-[Always open as read-only].

Then close the form and save it, and Excel's "read-only mode" will be set.

When you open the form again, a dialog box will pop up, prompting "Do you want to open it in read-only mode?"

If you select [Yes] to open it in read-only mode, even if the Excel table is modified, the original file cannot be saved. If you select [No], the opened Excel table is not in "read-only mode" and can be modified and saved normally.

"Passwordless read-only mode" is no longer needed in the future and can be cancelled.

First of all, we must operate in "non-read-only mode", that is, after opening the Excel table, when the prompt box "Do you want to open it in read-only mode" appears, select [No].

Then follow the set operation path and click [File]-[Information]-[Protect Workbook]-[Always open as read-only] again. After saving the table, Excel's "passwordless read-only mode" is released.

2. "Read-only mode" with password

If we want to prevent others from modifying the Excel table, or specify that people can modify it, we can set a password-protected "read-only mode" for the Excel table.

This mode needs to be set through "Save As". After opening the Excel table, click [Save As] under the [File] option, and then select the save path after saving on the right.

After the dialog box pops up, click [General Options] in the [Tools] list below. The file name can be modified to save it as a new file, or the original file can be directly overwritten without modification.

After the dialog box pops up again, enter the password you want to set in the [Modify permission password] column, click [OK] and enter it again. The "Read-only mode with password" of the Excel table will be set.

Open the Excel table again, and a dialog box will pop up, prompting "Enter the password to obtain read and write permissions, or open it in read-only mode."

If you select [Read-only], it is the same as the first method. You can open the Excel table, but after the table is modified, the original file cannot be saved; if you want to edit the file and save it, you need to enter a password before it can work normally. Edit and save.

How to remove the "read-only mode with password"?

After opening the Excel table, we enter the "editable mode" through the password, then follow the set operation path, click [File] - [Save As] again, select the save path after saving, and then click [Tools] - [General] Options].

Finally, the dialog box below will pop up. You can see that the [Modify Permission Password] column already contains a password. Delete this line of password, turn it into a blank space, and then save it. The "password read-only mode" of the original Excel table has been removed.

If you forget your password, you can actually remove the "read-only mode" of the Excel table. You only need to save the table as a new table in the "read-only" state without setting a password.

Of course, if we don’t remember the password, we can also use other tools, such as the Pepsi Niu Excel Password Recovery Tool, which can directly remove the "read-only mode" of the Excel table or the "restricted editing" that cannot be lifted without a password.

After selecting the [Unrestriction] module in the tool, then import the Excel table.

Tool link: Pepsi Niu Excel Password Recovery Tool

After selecting the [Unrestriction] module in the tool, then import the Excel table.

The above is the detailed content of Two methods to set the "read-only mode" of an Excel table. For more information, please follow other related articles on the PHP Chinese website!