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?