Wednesday, January 25, 2012

How do i protect cells from modification in lotus 1-2-3 spreadsheet?

I want to protect cells that contain formulas so they don't accidentally get overwritten by entering a value. I know the same can be done excel, but I want to do this for Lotus 1-2-3 spreadsheet.

How do i protect cells from modification in lotus 1-2-3 spreadsheet?
I believe you have to click style/protection and click in box for "keep data unprotected....". You have to highlight the cells you want to allow data entry. You then click file/protect and click the "seal file" box. This protects everything except what you chose from before.


No comments:

Post a Comment