View Single Post
  #1   Report Post  
tired of finding my data scrambled
 
Posts: n/a
Default How to protect data in rows from being seperated during sort

I have a huge spreadsheet that needs to be sorted a million times but several
people. The problem is that during some of the sorts they don't always grab
the whole row and the data then gets scrambled. how can I protect the sheet
so that the rows can be moved and sorted and edited but the data within the
rows always stays together