Spreadsheet with locked cells - is it possible?

[rhyspippard]

Is it possible to create a spreadsheet where all cells except a few are locked for editing?

I need to create a template spreadsheet for a client. This client has been rather keen to overtype formula in the past and has caused themselves problems in doing so.

A spreadsheet template where only certain cells are open for editing would be very useful. Is it possible?

 

[Smitty]

Sure, just select the cells that you want editable and goto Format-->Cells-->Protection-->Uncheck "Locked" then protect the sheet.

HTH,

Smitty

 

[rhyspippard]

excellent - thank you!

and will the locked formatting continue if i copy and paste the selection of cells many times within a worksheet?

could the user also unlock these cells if they so wanted? is there anyway to password protect them or make them unusable?

 

[Smitty]

Not sure what you mean about the formatting part, but you can add a password when you protect a sheet. That'll keep 99% of users honest.

Smitty

 

[rhyspippard]

that is exactly what i needed to know. thank you