Pinterest Pixel

How to Lock Cells in Excel

Have you encountered a scenario where you do not want to lock the whole sheet, but just... read more

Download Excel Workbook
Bryan
Posted on

Overview

How to Lock Cells in Excel | MyExcelOnline How to Lock Cells in Excel | MyExcelOnline

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

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 workbookHow-to-Lock-Cells.xlsx

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

How to Lock Cells in Excel

 

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

How to Lock Cells in Excel

 

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

How to Lock Cells in Excel

 

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

How to Lock Cells in Excel

 

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

How to Lock Cells in Excel

 

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

 

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

 

STEP 8: Retype the password and Click OK.  

How to Lock Cells in Excel

 

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

 

How to Lock Cells in Excel

 

How to Lock Cells in Excel | MyExcelOnline

If you like this Excel tip, please share it
How to Lock Cells in Excel | MyExcelOnline How to Lock Cells in Excel | MyExcelOnline
How to Lock Cells in Excel | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Quick Excel Cleanup: How to Remove Column in Seconds

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...