protecting individual cells - not entire worksheets

M

mark

What is the best way to protect individual cells on a
worksheet(that have values that have been calculated
elsewhere) from being modified accidentally?
Regards Mark
 
P

Paul Falla

Dear Mark
Highlight the individual cells that you wish to protect,
then rightmaouseclick and choose format cells. Click on
the protection tab - make sure the "locked" box is ticked.
Click th "OK" button. Now go to tools - Protection -
Protect sheet - enter a password if required.

Hope this helps

Paul Falla
 
D

Don Guillett

Perhaps it should be mentioned that the default is locked. So, if you want
other cells unlocked, you must unlock and then protect the worksheet.
 
Top