Can some cells remain unprotected in a protected spreadsheet ?

D

Detenbeck3890

I know that Lotus allows for spreadsheet protection, allowing the user to
unprotect specific cells, thus protecting against overwriting a formula while
entering variables into the spreadsheet. An example may be an amortization
schedule, containing formula to be protected, while allowing the term, rate,
and amount fields to be accessed? Can anyone help or do I have to use Lotus
!!!
 
L

L. Howard Kittle

Yes, check out help for sheet protection. I think its pretty well explained

HTH
Regards,
Howard
 
L

LACA

Select the cells you do not want protected.

Then:

- Format
- Cells
- Protection tab
- Unclick the "Locked" checkbox
 
Top