Is there a way to keep rows together in Excel so that when you sort the rows
will stay together and so that when there is a page break the rows will stay
together on a page? I have a spreadsheet where the first three rows are
merged in colum A and then are not merged in columns B and on. When I try to
sort by Col. A I get a "merged cells have to be identically sized" message.

Number one!!

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


On Fri, 25 Sep 2009 11:54:02 -0700, KLG
wrote:

Is there a way to keep rows together in Excel so that when you sort the rows
will stay together and so that when there is a page break the rows will stay
together on a page? I have a spreadsheet where the first three rows are
merged in colum A and then are not merged in columns B and on. When I try to
sort by Col. A I get a "merged cells have to be identically sized" message.