Hi

Once you have set up your first one, group all of the sheets and go into the
Page Setup dialog options. When you click OK to come back out, the settings
will be copied to the other grouped sheets. Don't forget to ungroup the
sheets after, though.

Andy.

"Jeff" wrote in message
...
I think I asked this question before, but I forgot how to do it.

I have about 15 worksheets with similiar dimensions so when I format the
print on one sheet, the same formatting would apply to all 15 sheets. So
I
want to copy the print format from one sheet to all 15 sheets. The
numbers
on all the sheets are different.

Thanks for your help