Print multiple sheets with different orientations

Question

I have a multisheet Excel Spreadsheet.

Some pages are setup as Portrait others are setup as Landscape.

Is there a way to define which pages should print as Portrait or Landscape, or is it an all one way or the other type of thing ?

Answer 1

With the Page Setup option you can determine orientation for each work sheet separately.

It will print the worksheets accordingly.