ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Header/Footer (https://www.excelbanter.com/setting-up-configuration-excel/226237-header-footer.html)

General JP

Header/Footer
 
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

Header/Footer
 
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

General JP[_2_]

Header/Footer
 
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



All times are GMT +1. The time now is 01:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com