Lock cells in Excel and set a password animation tutorial

Excel2003 Tutorial 41, locking cells and encrypting in Excel.

Demo Animation

Operation Steps

When multiple people edit the same workbook document, we can encrypt the worksheet in order to prevent modification of the data that is filled by others.

Start Excel, open the appropriate workbook document, and perform the tools → protect → allow users to edit range command to open the Allow users to Edit Ranges dialog box.

Click the New button to open the New Zone dialog box, enter a title in the box under title (such as "build"), then press the red button on the right side of the reference cell to convert the dialog box to a floating bar, select the appropriate area with the mouse, and then press the red button to the right of the floating bar to return to the dialog box. Set the password, press the "OK" button, and then confirm enter the password once, OK return.

Repeat these actions to set the password for the other locale.

When the settings are complete, press the "Protect Sheet" button to encrypt the worksheet.

After this setting, to edit the appropriate area, you must enter the correct password, otherwise you will not be able to enter the edit.