rows to repeat at the top


M

Meebers

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

Advertisements

S

Shane Devenshire

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
 
S

Sninkle

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

Meebers

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

Advertisements

M

Meebers

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top