Thanks Dave whilst the solution doesn't work for me you have probably
answered my question that it can't be done (perhaps one day!)


"Dave Peterson" wrote:

The only way I know is to print the headers first, then use that same paper to
print the data (sending it through the printer twice).



General JP wrote:

Is it possible to keep the header & footer in Portrait format whilst the page
itself prints as landscape? I want to include Excel Schedules (detailed
excel tables) in a bound report with a Word document and try and keep headers
& footers consistent.

Adobe offers a facility with PDF but it is cumbersome as each Appendix page
needs different title that I generally take from the worksheet tab name.

Thanks

--

Dave Peterson