Print Set-Up for Entire Workbook

I have a workbook that has 17 work sheets. I am wondering if there is a way to set all 17 work sheets to print in Landscape and fit to page without having to go into each sheet and make the settings individually.
What I would like is that all 17 work sheets print in landscape mode - and the contents of each sheet to fit to the page.

Is this possible?

Any help would be appreciated.
Thanks,

Tp

Hi,

You need to click on the first tab of the workbook, then shift-click on the last tab. Now all tabs are selected and you can work on the page setup, orientation, margins, header etc. These settings will be applied to all selected sheets.

HTH

teylyn