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

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

Andy,

That will not work

I am using Page Breaks, so it is a little more complicated then simply
choosing the size and margins.



"Andy" wrote:

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