Methods for locking multiple specified cells in an Excel table

For data in an Excel workbook, adding a password to the workbook is an easy and practical way to do so if we just want someone else to see it and not want it to be arbitrarily modified. In practice, when we protect data in some of the specified cells in an Excel workbook, we also have to allow others to modify the data in other cells. So how does this work? Next, I will take an Excel workbook as an example (protect only the data in columns C and D), and give you an introduction on how to implement it.

First step: Open the workbook and switch to the "Sheet1" worksheet; then select all the cells on the worksheet and press the Ctrl+1 shortcut key to open the Protection tab of the Custom Series dialog box (Figure 1), and then cancel the Lock checkbox and click OK.

Note: This step is intended primarily to unlock all cells first. The next step is to lock the specified cells.

Step two: In the SHEET1 worksheet of the compensation table. xlsx workbook, first select the C and D column cells that you want to protect (or other contiguous or noncontiguous cells), and then press the Ctrl+1 shortcut to open the Protection tab of the custom series. Also check the "lock" and "Hide" checkbox shown in Figure 1, A and B, and click OK.

Then, in the Excel2007 main interface, click the Allow users to edit Range button on the Review tab, open a dialog box with the same name, and click the New button to eject the New Zone dialog box.

Then enter the password in the text box below the area password in the New Zone dialog box and click the OK button.

Finally, in the new pop-up Confirmation Password dialog box re-enter the password is OK.

Upon completion of the above operation, click the Format button on the Home tab of the EXCEL2007 main interface, select Protect Sheet from the pop-up drop-down menu to open the Protect Sheet dialog box, and then follow the prompts to remove the password for worksheet protection in the dialog box. Enter the new password in the bottom text box (or the same password you set for the first time to protect some cells) and click the OK button.

As a result, we have completed all operations for adding read-only passwords to cells in columns C and D in the "compensation table. xlsx" Workbook "Sheet1" worksheet. Of course, you do not have to enter a password if you are editing a cell other than column C and column D in the SHEET1 worksheet.