Lock cells in Excel

In the last two chapters, we discussed the workbook and worksheet protection.

This final chapter aims to provide some details on cell locking.

Locking cell means, denying the end user to make changes or delete a particulat cell or range of cells in the worksheet.

Note that, to lock the cells, the worksheet must be protected.

The following illustration shows how to lock a cell in excel.

1.Select the worksheet in which the cells are to be locked.

2.Choose the cells to be locked.

In case of non contiguos cells, Ctrl key has to be used.

In our case, let us take cell N11 for example.

3.Right click the chosen cells, N11 in our case and select Format Cells option.

excel lock cells

The following dialog box appears.

Seelct 'Protection' tab and check the "Locked".

excel lock cells

As shown in the above window itself, locking the cell has no effect until the worksheet is protected.


You can find similar Excel Questions and Answer hereunder

1) How do I add a symbol like Triangle / Inverted Triangle for indicating trends in a cell using VBA?

2) How can I identify cells with Circular Reference in a WorkSheet?

3) How can I enter information in multiple cells simultaneously?

4) Applying a countif formula only to visible cells in a filtered list in Excel

5) how to combine the content of two or more cells in Excel

6) I have a complex WorkSheet with lot of fields and data - How can I quickly find the cells that have formulas?

7) How can I identify all cells with Conditional Formatting in my WorkSheet?

8) How can I sort data using multiple criteria?

9) How can I remove hyperlinks from a range of cells?

10) How to see to which cells a cell is connected or used by. How to see the precedents of a cell


Here the previous and next chapter