Have you encountered a scenario where you do not want to lock the whole sheet, but just a couple of cells in your Excel worksheet?

Locking an entire sheet is straightforward, but locking separate cells is a different story.

Let us say, we have this single cell that we want to lock in our Excel worksheet:

How to Lock Cells in Excel | MyExcelOnline

Here is the game plan:

  • All of the cells are locked by default, however locked cells have no effect until you have protected the worksheet
  • So we will unlock all of the cells
  • Then select the single target cell and lock it
  • After that, we will protect the worksheet and our target cell will now be locked!

 

I explain how How to Lock Cells in Excel below:

How to Lock Cells in Excel | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

STEP 1: Select all of the cells by clicking the upper left corner:

How to Lock Cells in Excel | MyExcelOnline

 

STEP 2: Right click any cell and select Format Cells:

How to Lock Cells in Excel | MyExcelOnline

 

STEP 3: Ensure Locked is unticked.  This will unlock our entire sheet.  Click OK.

How to Lock Cells in Excel | MyExcelOnline

 

STEP 4: Right click on our target cell and select Format Cells:

How to Lock Cells in Excel | MyExcelOnline

 

STEP 5: Ensure Locked is ticked this time. This will lock our target cell. Click OK.

How to Lock Cells in Excel | MyExcelOnline

 

STEP 6: Now it is time to protect our Excel sheet and see the locking in action!

Right-click on the Worksheet Name and select Protect Sheet (or go to the ribbon menu and select Review > Protect Sheet)

How to Lock Cells in Excel | MyExcelOnline

 

STEP 7: Type in a password and Click OK.  In our example, I typed in excel as the password.

How to Lock Cells in Excel | MyExcelOnline

 

STEP 8: Retype the password and Click OK.  

How to Lock Cells in Excel | MyExcelOnline

 

STEP 9: If you try editing your target cell now, Excel will not allow you to…And you are able to edit the other cells just fine!

How to Lock Cells in Excel | MyExcelOnline

 

How to Lock Cells in Excel

 

HELPFUL RESOURCE:

How to Lock Cells in Excel | MyExcelOnline

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn