Locking a format

[Iriemon]

How do I lock the format but still allow a user to input values into a cell?

I have cells that are unlocked to allow for operator entry but if the
operator copies and pastes from another spreadsheet, the format I've set up
changes to whatever the copied and pasted cell had.

thanks

Irie!

 

[atiq8961]

How do I lock the format but still allow a user to input values into a cell?

I have cells that are unlocked to allow for operator entry but if the
operator copies and pastes from another spreadsheet, the format I've set up
changes to whatever the copied and pasted cell had.

thanks

Irie!

Dear Iriemon
First you decide which cell or cells you wish to lock and unlock,
Then click to fromat menu > format cell > protection > tick the locked or
unlocked,
Then click the tools menu > protection > protech sheet
First you put up your password ex (xyz) then select catagary form allow user
and tick select unlocked cell