rows to repeat at the top

  • Thread starter Thread starter Meebers
  • Start date Start date
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.
 
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
 
Wouldn't it be better to have worksheet for 'For Lease Address' and another
for 'For Sale Address' then this problem wouldn't occur.
 
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.
 
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

Similar Threads

Repeat Row at Top of Worksheet 2
Repeating rows not wanted 11
Printing non-contiguous rows at the top 1
Repeat rows on top - in worksheet - not printing! 2
All sheets in workbook have same rows to repeat at top 1
Rows to Repeat at Top - Formatting Multiples 2
Can I repeat rows at the top, except the last page? 3
How do I repeat rows at the top of SOME of the pages in Excel 2

Back
Top