Protecting Sheet


Posted by Lewis on December 10, 2001 5:06 AM

If i protect the worksheet, how can i unprotect certain cell without unprotecting the whole thing?



Posted by Bariloche on December 10, 2001 5:26 AM

Lewis,

Before protecting the sheet, select the cells you want to be able to change, click Format > Format Cells... > Protection and uncheck the Locked box. Now when you protect the sheet the unlocked cells will be available for editing.


enjoy