printing workbook -landscap in to portrait format in Excel
 

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?

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


Regards,

Peo Sjoblom


"rjoshi" wrote:

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?