Lock Cells in Excel

Have you ever wanted to lock a couple of cells rather than the whole sheet in your Excel worksheet? Locking an entire Excel sheet is different thing than locking separate cells.

Previously In Analysis: Merge Cells in Excel

Here is the explanation:

All of the cells are locked by default, but you need to protect the excel worksheet so that locked cells should have effect. 

Here we first need to unlock all the cells

After that, we need to select that single target cell and then lock it

At last, we need to protect the worksheet so that our target cell will get locked

 Steps are explained below to know how to lock the cells:

STEP1: Locking Cells

Firstly, you need to click the upper left corner to select all of the cells:

Now, select the format option just by clicking right in any cell.

Make sure that Locked option is unticked so that your entire sheet is unlock, Then Click OK

Now select the format cells by right-clicking on your target cell.

This time make sure to tick the Locked option so that your target cell get lock then Click OK.

STEP2: Protect Your Spreadsheet

Now you need to protect your Excel spreadsheet to see that whether lock is working or not.

So, for checking that you must right-click on the Worksheet Name and select Protect Sheet.

Now if you will try to edit the target cell, Excel will not be allowing you to do that but if you try to edit the other cells it will work fine.