View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Daniel Daniel is offline
external usenet poster
 
Posts: 354
Default Keep data together

I need to keep the contents of rows together, but allow users to freely edit
the contents of the cells.

Users should be able to sort, but regardless of the range selection the data
on any row must always stay together.

Locking isn't the answer because users must then unlock the cells to edit or
sort, and then they can also move a cell's contents out of the row with the
other information that it specifically relates to.