Print Area Problem

[pdizzy]

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

[FDibbins]

Try "grouping" all sheets before setting your print parameters, thety should then be "punched" through to all sheets

select the 1st sheet, hold the shift and select the last sheet. (DONT forget to ungroup them - right-click a tab name/ungroup)

[pdizzy]

Hi FDibbins

Many thanks. That solved it.

PD

[FDibbins]

happy to help and thanks for the feedback