How to print titles repeated in each section RRS feed

  • Question

  • I know there are ways to repeated titles in every page. However, in my situation, the titles that should be repeated in each page are different in different sections. One solution to this is to print each section one by one and setting the title every time. Is there any way to tell excel to let it recognize the section break and print different titles corresponding to that section. 

    Thanks a lot. 

    Sunday, November 16, 2014 10:08 PM


  • Excel doesn't really provide for this. You could enter the print titles in cells in the top row of each page. Maintenance becomes a nuisance if you have to insert or delete rows, of course - you'd have to move the rows containing the fake print titles.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Sunday, November 16, 2014 11:03 PM