Lesson#121: How to make some cells unprotected when protecting a sheet

OK, I am having a sheet here which calculate the age when birth date is provided. I need to protect the sheet before giving it to users. So none of them change the structure or formula. But I also need to make some cells unprotected to make the user enter necessary data. I have colored those cells yellow which I will left unprotected.

So for that select those specific cells and right click on them. Then click on Format Cells. Select Protection tab where you can see the Locked option is already selected. By default Locked option is always selected for any cell. But this has effect only when you have protected the sheet. You have to deselect the Locked option for these specific cells only.

Now right click on sheet tab and click on Protect Sheet and then put a password and re-enter password and OK.

That’s how it is done. Now only those three yellow cells are left unprotected for users.

Hi! I am Puspendu. I am the founder and author of Excelabcd. I am little creative person, blogger and Excel-maniac guy. I hope you enjoy my blog.

Tagged with: ,
2 comments on “Lesson#121: How to make some cells unprotected when protecting a sheet
  1. Sanjoy says:

    Need the solution on reverse condition..
    Where want to protect some cells in a Excel sheet..

    • Ok then Select the whole sheet by pressing Ctrl+A then right click on sheet, click Format Cells, Protection tab, de-select Locked option. Now select only those cells which you want to protect and by following same method select the Locked option. and then protect the sheet. done.

Leave a Reply

Your email address will not be published. Required fields are marked *