Locking Worksheets

B

Bobbi Jo

Hi! I need to know how to lock cells in a worksheet. I
only want to lock specific cells!

Thanks!
 
R

Ron de Bruin

Hi Bobbi

Ctrl-a to select all the cells
Ctrl-1 and choose the protection Tab and unselect locked
Ok
Select the cells you want to protect
Ctrl-1 and choose the protection Tab and and select locked
Ok
Now protect your sheet (Tools-protection-protect sheet)
 
Top