MS Excel Query - how to print alternate Potrait and Landscape pages

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

There is an Excel file that contains pages which need to be printed in both Potrait and Landscape. I was wondering if Excel has a function, similar to Word, where you can set the format of the pages. Thanks for any help provided.
 
Hi Bill
this could only be done with VBA. You could create this macro by
yourself:
- start recording a macro
- print the pages individually and change the page layout between the
print manually
- stop recording

Use this recorded macro
 
Bill -

If you mean print different worksheets landscape or portrait, it's
easier than Frank let on. Run page setup on each sheet to define how you
want it to be printed.

- Jon
 
Hi Frank -

I'm not sure either, which is why I piped up. By the way, don't you ever
sleep?

- Jon
 
Jon said:
Hi Frank -

I'm not sure either, which is why I piped up. By the way, don't you
ever sleep?
Click to expand...

Jon
it's just around 9:30 pm here in Germany :-) -> lot of time left in
this evening


Frank
 
Back
Top