rows to repeat at the top
 

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.

rows to repeat at the top
 

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.

rows to repeat at the top
 

Wouldn't it be better to have worksheet for 'For Lease Address' and another
for 'For Sale Address' then this problem wouldn't occur.
--
Carrie


"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.

rows to repeat at the top
 

It would...but it is a trade off. One worksheet to view both types vrs 2
worksheets. I am dealing with 8 locations using 8 tabs, vrs 16 tabs if
seperated.
"Sninkle" wrote in message
...
Wouldn't it be better to have worksheet for 'For Lease Address' and
another
for 'For Sale Address' then this problem wouldn't occur.
--
Carrie


"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.

rows to repeat at the top
 

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.