none
Excel 2010 - Print portrait and landscape pages

    Question

  • Hi

    Is it possible to print some pages in a worksheet portrait and others in landscape?

    Thanks

    Viv


    Viv Haig

    Thursday, November 15, 2012 4:58 PM

Answers

  • Excel has no built-in support for that.

    You could create a macro that sets the page orientation, prints one or more pages, then changes the page orientation, prints some other pages, etc. Rather complicated.

    It might be easier to split the content into different worksheets, each with its own orientation.


    Regards, Hans Vogelaar

    • Marked as answer by VHaig Friday, November 16, 2012 12:52 PM
    Thursday, November 15, 2012 9:51 PM

All replies

  • Excel has no built-in support for that.

    You could create a macro that sets the page orientation, prints one or more pages, then changes the page orientation, prints some other pages, etc. Rather complicated.

    It might be easier to split the content into different worksheets, each with its own orientation.


    Regards, Hans Vogelaar

    • Marked as answer by VHaig Friday, November 16, 2012 12:52 PM
    Thursday, November 15, 2012 9:51 PM
  • Thanks Hans.

    Viv Haig

    Friday, November 16, 2012 12:52 PM