printing workbook -landscap in to portrait format in Excel

R

rjoshi

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?
 
P

Peo Sjoblom

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


Regards,

Peo Sjoblom
 
Top