And then click the ok button in the popping up kutools for excel dialog.

How to lock cell in excel to prevent editing. Click the button at the top left corner of worksheet to select all cells. Protect the sheet lastly.just select all cells. There will be two check boxes;

The next image depicts the data having items and the. If prompted, enter the password to unprotect the worksheet. 1.unlock all cells in excel before locking any particular ones.

When the format cells window appears, select the protection tab. Select all the cells in the sheet. Go to the ‘protection’ tab on this window and enable.

Select the area of the workbook you’d like to protect. What we want to do here is leave the. Right click on an or group of cells, click on format, click on protection.

Right click and select format cells. After that, manually select the cells you want to protect with a password by holding ctrl on your keyboard and then selecting the cells. On the home tab, click the format cell font popup launcher.

2.format cells can be selected by right. Select the whole worksheet by clicking the select all button. Click on the tab labeled protection. 5.