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

B

bparting

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!
 
G

Greg Koppel

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!
 
G

Gord Dibben

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
 
Top