ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Landscape worksheet with portrait header/footer (https://www.excelbanter.com/excel-discussion-misc-queries/21377-landscape-worksheet-portrait-header-footer.html)

SNOWED-IN

Landscape worksheet with portrait header/footer
 
I need to print the worksheet contents in landscape, but want the header and
footer in portrait. Is this possible?

Chip Pearson

I don't believe this is possible.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"SNOWED-IN" wrote in
message
...
I need to print the worksheet contents in landscape, but want
the header and
footer in portrait. Is this possible?




SNOWED-IN

Bummer - but thanks for the answer.

"Chip Pearson" wrote:

I don't believe this is possible.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"SNOWED-IN" wrote in
message
...
I need to print the worksheet contents in landscape, but want
the header and
footer in portrait. Is this possible?





David McRitchie

You might be able to use Word to print one pass, and Excel for the spreadsheet.

For one page only (first page, for instance) you can place some information in a text box (graphics toolbar)
and rotate it. It at least allows you to put some big type in the upper right hand corner
for instance in portrait while the rest is in landscape.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"SNOWED-IN" wrote in message ...
Bummer - but thanks for the answer.

"Chip Pearson" wrote:

I don't believe this is possible.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"SNOWED-IN" wrote in
message
...
I need to print the worksheet contents in landscape, but want
the header and
footer in portrait. Is this possible?








All times are GMT +1. The time now is 12:00 AM.

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