Below will show you how:

How to lock cell in excel to prevent editing. Select the area of the workbook you’d like to protect. Right click and select format cells. In the format cells dialog box, check the lock option under protection tab,.

Select the whole worksheet by clicking the select all button. Select cells and ranges that you want to lock, right click and select the format cell item from the context menu. Apply the following steps to protect specific cells from editing:

Click selection unlock under the design tab. If prompted, enter the password to unprotect the worksheet. Press “ok” when you’re done.

Go to the ‘protection’ tab on this window and enable. Protect sheet protect the worksheet and contents of locked cells. The next image depicts the data having items and the.

On the review tab, in the protect group, review the following protection options: 2.format cells can be selected by right. Alternatively, you can use the keyboard shortcut ctrl + 1.

And then click the ok button in the popping up kutools for excel dialog. After that, manually select the cells you want to protect with a password by holding ctrl on your keyboard and then selecting the cells. In the “home” tab, press “editing > find & select > go to special…”.