Excel - Keeping Rows Together

Asked By KLG on 25-Sep-09 02:54 PM
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.

Gord Dibben replied on 25-Sep-09 04:10 PM
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