Changing all sheets to LANDSCAPE in workbook

M

Mark

I'm sure there's any easy way to do this and I'm just
missing it - at least I hope there's a way...

I have about a dozen different workbooks that each
contain several dozen worksheets. The worksheets were
originally formatted to print in Portrait. I'd like to
change them to print in Landscape.

Is there a way to automatically do this in Excel? In
Page Setup, I can only change it to landscape one sheet
at a time.

Thanks!
 
Top