Help...I can't find the "Yes" button :-( but could not figure a way to
do it either. Tx for response.

"Shane Devenshire" wrote in
message ...
Hi,

Excel doesn't have a feature to do this. You only option is to put a page
break directly before the For Sale Address line. That will put the two
titles at the top of each group. But if the flow over into multiple pages
tall this will not repeat the rows at top.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Meebers" wrote:

I am working on a single worksheet trying to keep different data on.
i.e.
One column has a header labeled "For lease Address" and about 40 rows
later, that same column has an entry "For Sale Address" Data is filled
in
under these two sections. I want the rows to repeat at the top for
printing, but change to the other "heading" when I print the "For Sale
Address" data. I cannot think of a way to do that...any suggestions.