Cell Protection Question

C

cgi_pro

Hello

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

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.
 
Top