Can I Protect Just A Few Cells On A Worksheet?

J

Joe Miller

Can I protect just a few cells on a worksheet - and if so, how?

Thanks,
Joe Mille
 
B

Bob Phillips

Sleet the whole worksheet, goto Format>Cells>Protection and uncheck Lock.

Select the cells to protect, goto Format>Cells>Protection and check Lock.

Now protect the sheet, Tools>Protection>Protect Sheet...

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
B

Bob Phillips

Sleet? I mean Select.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

Bob Phillips said:
Sleet the whole worksheet, goto Format>Cells>Protection and uncheck Lock.

Select the cells to protect, goto Format>Cells>Protection and check Lock.

Now protect the sheet, Tools>Protection>Protect Sheet...

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

in message news:[email protected]...
Click to expand...
 
Top