Before sorting, make sure you have ALL columns selected.

Do not let Excel guess what the sort range is.

If this is not what you need, post back with more details and/or a sample of
your layout.


Gord Dibben MS Excel MVP

On Fri, 18 Sep 2009 11:08:01 -0700, 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.