There will be two check boxes;

How to lock cell in excel to prevent editing. Every cell has an individual lock. First, remove protection from those cells to which employees of branch stores will make changes. In the “home” tab, press “editing > find & select > go to special…”.

On the review tab, in the protect group, review the following protection options: Right click and select format cells. Choose the cells which you want to lock from editing.

Press “ok” when you’re done. In the format cells dialog box, check the lock option under protection tab,. When the format cells window appears, select the protection tab.

Select all the cells in the sheet. Select the area of the workbook you’d like to protect. Click on the tab labeled protection. 5.

To select all cells, just click on the small triangle at the left top corner of the grid lines, just after column a. A new window will open. 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. How do you lock a cell for editing in excel 2016? 1.unlock all cells in excel before locking any particular ones.