excel how to lock cells but some formatting can be modified

Excel cells are locked by default. If you want to protect the cell content lock from modification, you need to set the cell to be protected as locked and strong, and the others are not locked. Then do the cell protection, preferably set to change the password.

In this way, others can't change the password if they don't know it. Here's how:

1. Unlock all cells first. Select all cells, then right-click, select and click "Format Cells" in the right-click menu, click the protection tab above after entering, and remove the check box of the lock option. Then exit as shown in the figure.

2. Select the cells you want to protect. (You can hold down the Ctrl key and click the cells one by one), and also go to Format Cells and check Lock. (This way, only the cells to be protected are locked).

3. The next step is to protect the worksheet. I don't know what version you're using, take the 2007 version as an example (the 2003 version seems to be in the menu bar of tools, format, I can't remember clearly), there is a "Protection Worksheet" under the review tool menu, click on it.

Then record the password in the small window of the protected worksheet that opens, and then record it again in the confirmation password to confirm the exit.

4. In this way, the cells in this worksheet cannot be modified, and the protection status must be lifted if you want to modify it. Of course, if you are interested, you can also look into other protection methods, such as changing the contents of cells with a password.

It is inevitable that some data in excel is not allowed to be modified, how to lock a part of the fixed cells from being modified, but allow other cells to be modified? Let's teach you about it.

Excel lock fixed some cells from being the method:

First, select all **, or click on the blank space, press Ctrl+A to select all, right-click to format cells, or the number toolbar in the toolbar, and find "Protect".

Remove the checkmark in front of Lock and click OK. Then select the cells that you need to lock and can't be, in the example, the yellow part is not used, still format the cells - protect, and tick in front of the lock.

Then find "Review" - Protect Worksheet Set Password in the toolbar, check the first two items, confirm the password, and click OK.

Follow the steps below to lock the cell formula from being modified in Excel:

1. First open Excel** and insert a formula into the cell.

2. Then right-click the cell with the formula, and click to format the cell.

3. Click Protect in the pop-up dialog box.

4. Finally, check the lock button under the protection tab and click OK.

1. Open the form that needs to be unrestricted. You can see that many of the tools in the menu bar are grayed out, indicating that they cannot be carried out.

2. Open **, find the Microsoft Office chart in the upper left corner, and click it.

3. There is a "Save As" in the middle of the page that opens.

4. Let's click "Save As" and a small window will pop up on the page.

5. There is a "save type (t)" under the file name of the small window (n), we click on the small inverted triangle behind the save type (t), click to open to view multiple types of file saving modes.

6. We select the Unicode text, click "Save", and then a small box will pop up to save this format. We choose to be.

7. Find the file you just saved in text mode, open a new excel sheet, drag the text file to the excel sheet, and restrict the file to proceed.

Tools Raw materials.

Excel2016 version, computer.

1. Open the computer to find and click on the Excel2016 version of ** software;

2. After double-clicking to open the excel software, select all the ** at this time, here take the cells in columns A to C as an example;

3. After selecting all the cells, right-click and click "Format Cells" in the drop-down options;

4. Find and uncheck the "Lock" command under the protection option in the pop-up dialog box, which is very important, otherwise the specified cells cannot be protected;

5. After canceling all the lock commands of **, select the cells that need to be locked at this time, here take column b cells as an example;

6. After selecting the part of the cells that need to be locked, right-click the mouse and select the command of "Format Cells";

7. After entering the interface, check the command of "lock" in the protected interface box, and the lock at this time is only for the cells that need to be protected in column B, and will not affect the modification of other cells;

8. After locking the cells in column B, find and click the command of "Protect Worksheet" under the review command;

9. In the pop-up interface box, only check the command of "Select unlocked cells", and click OK to complete the lock of column B cells, without affecting the modification of other contents.

How to lock part of the cell content in excel from being modified, this can be done like this:

The first step is to select [Review] in the main menu of Excel and select [Data] to be protected;

The second step is to select [Protect Worksheet];

Step 3, after selecting [Protect Worksheet], the dialog box will pop up, and [Select Locked Cells] and [Select Unlocked Cells] are mandatory;

Step 4: Enter the password in [Cancel Worksheet Protection], and in the fifth step, select [OK].

Step 6: Confirm Password Again, and then [Confirm] <

1. Select the part**: After opening Excel**, click and drag the right click with the mouse to select the part**.

2. Pop up the Select Cell Format dialog box: **After being selected, right-click and select the "Format Cell" option in the extended box, then the dialog window will pop up.

3. Unlock all cells: Click "Protect" in the dialog window and enter its interface. Then uncheck the check mark in front of "Lock", and finally click "OK".

4. Select the cells you want to lock: After returning to the excel interface, select the cells you need to lock (protect), one or more can be. After the cells are selected, right-click and select the "Format Cells" option, enter the "Protect" interface again, then tick the "Lock" option (tick), and then click "OK", so that the selected cells are locked.

5. Protect some selected cells: move the mouse to the sheet table and right-click, select the "Protect Sheet" option in its extension, then the "Protect Sheet" window will pop up.

6. Set a password for the selected cell: enter the password to protect the selected cell in the "Protect Worksheet" window, click the "OK" button and ask to enter the confirmation password again, and then click "OK" after the password is entered, so that the selected cell is protected.

Lock the contents of the excel cell from modification, and set the protection worksheet in the review.

The steps of the method are as follows:

1. Open the Excel** that needs to be operated, and click "Protect Worksheet" in the Review tab.

2. You can set a protection password according to the situation, and then click the OK button.

3. Return to excel, click on the data cell, and find that the content of the excel cell is locked to prevent the modification operation from being completed.

**The locks cannot be modified in the following ways:Tools Raw Materials: Computers:

Lenovo Xiaoxin, system version: win10, excel version: Microsoft Excel 2010.

1. Open the Excel** you want to operate, and select the content as shown in the figure below.

2. Right-click and select [Format Cells] as shown in the figure below.

3. Click [Protection] at the top as shown in the figure below.

4. Check [Lock] in the upper left corner, and then click [OK] in the lower right corner, as shown in the figure below.

5. Then click [Review] in the menu bar - [Protection Worksheet] as shown in the figure below.

6. In the pop-up Protect Worksheet dialog box, enter the password used to cancel the worksheet protection, click the [OK] button below, re-enter the password, and click [OK] as shown in the figure below.

7. In this way, the excel is locked, and others cannot modify the content in the ** as shown in the figure below.