How do I lock the work sheet and then unlock specific cells?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I can protect the entire worksheet but then I'm lost as to how to actually unlock only certain sells that I want to share with other users. Please help!
 
With the sheet unprotected, choose the cells that you want unlocked and then
go to Format/Cells. Choose the Protection tab and uncheck the box for
Locked. Protect the sheet and you are done.

HTH, Greg

Hi,
I can protect the entire worksheet but then I'm lost as to how to actually
Click to expand...
unlock only certain sells that I want to share with other users. Please
help!
 
By default, all cells on the sheet are "locked" when Sheet Protection is
applied.

Select the cells you wish others to edit then Format>Cells>Protection.
Uncheck the "locked" box.

Now Tools>Protection>Protect Sheet.

Gord Dibben Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How unlock locked cells 2
Locked Several Worksheets, allow format cells/select unlocked cell 2
How to change format protection default to unlocked? 2
Locked cells are still able to be selected with proper protection 1
How can I remove the previous lock cells and keep the new ones. 2
macro to unlock and lock cells in password protected sheet 3
keep specific cells from being changed. 1
Can't move between cells. (Not the scroll lock) 1

Back
Top