Hi

I am using a workbook with several sheets (53). All sheets have the same columns, rows, etc and are the same size. How can I set the whole workbook to have a set print area and set the whole workbook to print landscape and centered horizontal and vertical? I can do it by doing it on each page but when there are 53 sheets it would take some time. If I forget then I get the sheet printed across 2 A4 paper. I am using Excel2002 and upgrading is not an option at the moment.

Thanks

PD