not sure I understand fully. Can you create a column to identify the order
or grouping you need to be able to get back to what you need? you can
protect that column but still allow users to sort / edit non protected
fields. If you can provide some examples


"Daniel" wrote:

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.