Cell Protection Question

[cgi_pro]

Hello

How do I make (for example) cell A1 protected while B1 is editibale on
the same sheet (say Sheet1)?

 

[Roger Govier]

Hi

By default, all Cells are locked. This condition is only invoked,
however, when the Sheet is then Protected with
Tools>Protection>Protect Sheet (either with or without a password)

In order to do what you ask, first you need to remove the locked status
on all cells that you want to remain editable, with
Format>Cells>Protection and remove the checkmark from locked.
Then protect the sheet.

 

[cgi_pro]

You're good bro, thanks a lot it worked as I wanted it to work