Protect Sheet: Allow cell editing but nothing else

[jodyflorian]

Hi,

I'm looking for the simplest way to lock/protect a worksheet such that:

1) The user edit cells designated with that permission (some cells will need to be locked, others permitted for editing the value)
2) The user has no other privileges on that sheet.

PS 1: It would be helpful if rather than allowing cells one by one I could specify ranges of editable cells.
PS 2: I don't mind if the format of the cell is locked or not, but would be nice to know how to allow/disallow this for the cells who's values can be edited.

Any help greatly appreciated

Thanks in advance

[jodyflorian]

http://it.cas.psu.edu/training/howto/excel/protect.html

[Dandaman]

To allow users to edit only specific cells on a sheet you need to unprotect the the sheet, select the cell or range of cells you want the users to be able to edit, Press ctrl+1, go to the protection tab, uncheck the locked option, exit the window and protect the sheet again. I don't know of a way to permit only certain types of editing. Hope this is good enough for you.

[Dandaman]

bah! Too slow.