View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JCM
 
Posts: n/a
Default How do I lock some fields but allow editing for others in excel

Under the format cells (ctrl "1"), then click the protection tab. You can
lock or unlock the cell. This is activated afterwards by Tools / Protection

"S.Sharif" wrote:

I am creating a form using excel at which certain fields of the form, editing
is prohibited. Users then wont be able to change the locked values. Editing
is allowed for other fields.