View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lock MY Cells Lock MY Cells is offline
external usenet poster
 
Posts: 1
Default need to lock 5 cells but not protect entire sheet

I am doing a budget spreadsheet that will always need editing but I don't
want anyone to remove the formulas from cells where the final totals appear.
If I protect the worksheet, I can't edit anything. How can I lock only those
5 cells and still work on the other.