Locking everything except cells B4:B8

H

H

Hi, can someone help me lock this sheet except for these cells - I've tried
doing the Protect Sheet but everything seems to get locked?

Thanks
 
N

NBVC

Select the range you want to unlock and go to Format|Cells and in the
Protection tab uncheck the "Locked" checkbox.. click Ok.

Now re-protect the sheet through Tools|Protection|Protect Sheet.
 
E

Eduardo

Hi,
before protecting the sheet you need to unlock the cells, so select the
cells where you want to let users to enter information, right click on the
mouse, format cells, then last tab "Protection", uncheck locked, then protect
the worksheet
 
Top