Unless you're prepared to insert the titles onto rows wherever a page break would occur, you're back to having to use different worksheets so you can have the headers & footers.

You need to understand that what you're asking isn't something that's normally done with any Office product. Although it can be done with Word, Excel or Publisher, all three applications require you to change the way you're working to suit the way those programs work. I expect you would find the same with any non-Office application.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]