View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
fred fred is offline
external usenet poster
 
Posts: 1
Default Protecting cells

Can anyone help me with a problem I have with protecting cells in
Excel. I need to protect the content of some cells but not others and
as far as I can see Excel is all or nothing.
I have a spreadsheet which does some calculations based on data
entered by people with almost no computer knowledge. They keep
entering data in the results cells by mistake and screwing up the
spread sheet. The standard protect cells option appears to allow you
to protect all the cells in a worksheet or non at all.

Any ideas please?