ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   print mixed page orientations (https://www.excelbanter.com/excel-discussion-misc-queries/223619-print-mixed-page-orientations.html)

rolando

print mixed page orientations
 
Excel 2007;
is it possible to print (in 1 command) with different page orientations ?
for example when my print area=cells A1 to G200; print cells a1 to G5 in
portrait and A6 to G100 in landscape ?
Or do I have 2 make 2 print areas and print separated ?

Dave Peterson

print mixed page orientations
 
I would record a macro when
I selected the first range and printed the selection
and selected the second range and printed that selection

Changing the orientation for each print job.

Then stop recording.

And just run that macro when I wanted to do this kind of printing.



rolando wrote:

Excel 2007;
is it possible to print (in 1 command) with different page orientations ?
for example when my print area=cells A1 to G200; print cells a1 to G5 in
portrait and A6 to G100 in landscape ?
Or do I have 2 make 2 print areas and print separated ?


--

Dave Peterson


All times are GMT +1. The time now is 12:35 PM.

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