Dump the merged cells..........they cause no end of problems.
Make sure you have a column with an Identifier in it so's rows that should
be together get sorted together.
Also select all columns before sorting on your identifier colulmn.
As far as keeping data all within the bounds of page breaks, that would
depend upon the amount of data and how it gets sorted.
Gord Dibben MS Excel MVP