Locking a format

  • Thread starter Thread starter Iriemon
  • Start date Start date
I

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!
 
Iriemon said:
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!
Click to expand...

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