printing workbook -landscap in to portrait format in Excel

[Guest]

One of my financial program generates Excel workbook (with about 10
worksheets). they all show up in Landscap format. When printing I would like
to print in Portrait format. Is there an easy way to print entire workbook in
Portrait without changing each worksheet format?

 

[Guest]

Select all sheets (click first tab, hold down shift and click last tab), do
the page setup, then ungroup the sheets


Regards,

Peo Sjoblom