View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Beverly Darvill[_2_] Beverly Darvill[_2_] is offline
external usenet poster
 
Posts: 24
Default Locking certain cells

I have a spreadsheet that as a group of 5 columns grouped together using the
DATA - GROUP option - I want to protect the first colum from entry and allow
figures to be inputted into the other 4 columns - I can do this if I dont
mind seeing all the other columns but I want to collapse them as necessary
but if I protect the relevant cells and then Protect the Sheet it wont let me
collapse the group. Is it possible?

Thanks
Beverly