Excel cells are automatically protected?

Unprotect some cells Select the object cell range, right click, and select "Format Cells" as shown in the following figure; Then, follow the previous operations to clear the hooks before "Lock" and "Hide", as shown in the following image.

Because of the setting, you can cancel the automatic protection by changing the setting:

1. Open the excel you want to protect.

2. Select the "Review" option, zhidao can see a toolbar with "Protect Worksheet" on the toolbar of the page.

3. Click the button to open the "Protect Worksheet" dialog box. In this dialog box, you need to set a password when you unprotect the worksheet, and the operations that are allowed to be performed after protecting the worksheet, and select the checkbox in front of the allowed operations, that is, click ".

4. Click the "OK" button, the dialog box to determine the password will pop up, enter the password set in the "Protect Worksheet" page, and then click OK.

5. At this time, if you enter data or modify data in the worksheet page, a prompt message will pop up that the worksheet is protected.

6. When you want to write the document, you can unprotect the worksheet. Similar to the operation when setting up a protected worksheet, open the Excel document you want and select Review, and you can see that the original tool of "Protect Worksheet" has been changed to "Unprotect Worksheet".

7. Click the "Unprotect Worksheet" button, the "Unprotect Worksheet" dialog box will pop up, enter the password when setting "Protect Worksheet" in the box, and then click the "OK" button.

8. Go back to the excel worksheet area and find that you can document.

Step 1: Select the entire worksheet, right-click [Format Cells] - [Protect], confirm [Lock] [Hide], there is no check in front.

Step 2: Select the range of cells to be protected, right-click [Format Cells] [Protect], and select [Lock].

Step 3: Click [Tools] - Protection], [Protect Worksheet] in the menu bar, enter the password twice, and confirm it.

Excel is an electronic program in the Microsoft Office System. You can use Excel to create and format workbooks (electronic collections) so you can analyze data and make more informed business decisions. In particular, you can use Excel to track data, generate data analysis models, write formulas to perform calculations on your data, pivot your data in a variety of ways, and display it in a variety of professional-looking charts.

In short: Excel is an office software that makes it easier to work with data.

Sometimes we want to excel**.

For example, only some cell contents can be modified, and the rest of the cell data is not allowed to be modified (including font size, font, etc.), we can do this.

Now we have an excel** and want to set the b2, b3, b4 cells as the parts that are allowed to be modified, and the rest cannot be modified.

1. Select the area (B2, B3, B4 cells) that you want to modify the circle of mu, right-click, and select "Set Cell Format" from the right-click menu.

In the Protection tab, remove the hook in front of Lock.

2. Click "Tools" on the menu bar to "Protect" and "Protect Worksheet".

Tick "Select unlocked cells" and enter the password twice.

Now let's try it out.

Modify cells B2, B3, B4 without problem.

To modify the C2 cell, Excel pops up the following prompt to remind you that the protected cell is being modified.

If you want to remove the modification restriction of C2 cells, we can select "Tools" - "Protection" - "Undo Worksheet Protection" from the menu bar.

Enter the password you just set in the dialog box that pops up.

Now, the C2 cell data is modified successfully.

1.Find the Excel** set up on your computer and click to open the Excel**.

2.Once opened, find the "Review" item above the toolbar and click on this option. As shown in the figure below.

3.Find the option to undo worksheet protection and click on it, as shown in the image below.

4.Enter the password that was protected at that time, and then click Confirm. (You need to remember your password, if you forget it, you can't revoke it.) ）

5.After clicking to confirm, the protected cells will be unprotected.

Step 1: Select the entire worksheet, right-click [Format Cells] - [Protect], confirm [Lock] [Hide], there is no check in front.

Step 2: Select the cell area to be protected, right-click [Format Cells] [Protect].

Select Lock.

Step 3: Click [Tools] - Protection], [Protect Worksheet] in the menu bar, enter the password twice, and confirm it.

Excel2016**Set cell drop-down option method:

1. Select the "Cell" you want to add to the drop-down list.

2. On the menu bar, select "Data" - Data Verification "--Data Validation".

4. Set the allow condition to "Sequence" and check the next two options.

5. Then set "**" for men and women, remember that there is a "comma" between the two words.

<> click Enter a description.

<> click Enter a description.

<> click Enter a description.

<> click Enter a description.

<> click Enter a description.

<> click Enter a description.

<> click Enter a description.

<> click Enter a description.

Finally, let's verify our results. After confirmation, we want to enter data in the "protected cell", and this prompt will pop up. It means that we have completed the protection of the cell. As shown in Fig.

<> click Enter a description.

<> click Enter a description.