Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
SNOWED-IN
 
Posts: n/a
Default 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?
  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default

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?



  #3   Report Post  
SNOWED-IN
 
Posts: n/a
Default

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?




  #4   Report Post  
David McRitchie
 
Posts: n/a
Default

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?






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Printing multiple portait and landscape workbooks at the same time Sbaitso Excel Discussion (Misc queries) 7 March 30th 05 05:49 PM
can't get to change from portrait to landscape even after clicked. linda1960w Excel Discussion (Misc queries) 0 February 28th 05 04:57 PM
Set page to Landscape Still prints as Portrait lahscious Excel Discussion (Misc queries) 0 February 2nd 05 08:07 PM
Share Excel worksheet custom header/footer throughout workbook. zilla1906 Excel Worksheet Functions 2 January 12th 05 11:53 AM
change the orientation of a worksheet to Landscape epoliver Excel Worksheet Functions 2 December 31st 04 08:46 PM


All times are GMT +1. The time now is 09:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"