3 restricted permissions to protect the form from being modified at will

php Xiaobian Xigua teaches you how to set 3 restricted permissions to protect the form from being changed at will by others. These permissions include locking cells, setting password protection, and limiting the editing range, effectively protecting the integrity and confidentiality of table data. These simple yet effective methods can help you better manage and protect table content, making data more secure and reliable.

If you are worried about this problem, you can use the three "permission restrictions" of Excel tables to set different protection measures according to your needs. Next, let's look at what limits can be set.

Limitation 1: Lock the worksheet

Locking an Excel worksheet can prevent accidental changes. Only by entering a password can the restriction be lifted. However, if there are multiple worksheets, each worksheet needs to be set separately.

Setup steps:

1. Open the Excel table and click [Protect Worksheet] in the [Review] list of the menu.

.

2. After the dialog box pops up, set different restrictions as needed, or all restrictions, then enter the password you want to set, and click [OK] to set it.

.

3. After setting, when editing the Excel table, a dialog box will pop up, prompting that you need to enter a password before editing.

.

Limitation 2: Lock the workbook

If there are multiple worksheets in an Excel, you can set a locked workbook. Then the positions of each worksheet cannot be moved, and operations such as deletion, copying, and renaming cannot be performed. This is equivalent to locking the structure of the Excel table.

But the content of the table can still be edited. If you want to restrict editing, you must also set "Restriction 1".

Setup steps:

1. Open the Excel table, click [Protect Workbook] in the menu [Review] list, enter the password you want to set after the dialog box pops up, and click [OK] to complete the setting. .

.

2. After setting, the structure of the Excel table cannot be changed. When you click "Workbook", you can see that many options are gray and cannot be selected.

.

A dialog box will also pop up, prompting "The workbook is protected and cannot be changed."

.

Limitation 3: Some areas are locked and cannot be edited

If you want only part of the data in the Excel table to be uneditable, you can use the restricted permissions of "Lock Partial Areas".

Setup steps:

1. Open the Excel table, click the "triangle symbol" in the upper right corner of the table, or use the shortcut key "Ctrl A" to select the entire table.

.

2. Right-click on the table and select [Format Cells].

.

3. After the dialog box pops up, click the [Protect] option, then remove the "tick" in front of [Lock], and then click [OK].

.

4. In the table, select the area to be locked, then right-click the mouse and select [Format Cells].

.

5. After the dialog box pops up again, this time check [Lock] in the [Protect] option, and then click [OK].

.

6. Return to the table menu bar. Just like setting "Restriction 1", click [Protect Worksheet] in [Review], then enter the password and confirm.

After completion, the originally selected area cannot be edited, and other areas can be edited normally.

.

The above three methods of setting "restricted permissions" in Excel tables can all be revoked if they are no longer needed.

To cancel "Restriction One" and "Restriction Three", you can click [Undo Worksheet Protection] in the menu [Review] list in the Excel table, then enter the originally set password in the pop-up dialog box, and click [OK] Later, the restrictions were lifted.

.

To cancel "Restriction 2", click [Revoke Workbook Protection] in the [Review] list in the menu. The same is true. Enter the password in the pop-up dialog box to revoke the restriction.

.

It should be noted that no matter which "restriction" of Excel is revoked, you need to enter the originally set password, otherwise it cannot be revoked.

What should I do if I really forget my password? There is no option to forget the password in the Excel table, so in this case we need to use other tools, such as the tool used by the editor, which can directly remove various restrictions of the Excel table without a password.

In the tool, click the [Unrestriction] option, and then import the Excel table.

Tool link: Pepsi Niu Excel Password Recovery Tool

The Excel table after the restriction is lifted will generate a new table. Click [Go to View] to open the folder to see it.

The above is the detailed content of 3 restricted permissions to protect the form from being modified at will. For more information, please follow other related articles on the PHP Chinese website!