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.
Leave a Reply