software

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.

quot;Jeffquot; gt; wrote in message
news
gt;I think I asked this question before, but I forgot how to do it.
gt;
gt; I have about 15 worksheets with similiar dimensions so when I format the
gt; print on one sheet, the same formatting would apply to all 15 sheets. So
gt; I
gt; want to copy the print format from one sheet to all 15 sheets. The
gt; numbers
gt; on all the sheets are different.
gt;
gt; 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.
quot;Andyquot; wrote:

gt; Hi
gt;
gt; Once you have set up your first one, group all of the sheets and go into the
gt; Page Setup dialog options. When you click OK to come back out, the settings
gt; will be copied to the other grouped sheets. Don't forget to ungroup the
gt; sheets after, though.
gt;
gt; Andy.
gt;
gt; quot;Jeffquot; gt; wrote in message
gt; news
gt; gt;I think I asked this question before, but I forgot how to do it.
gt; gt;
gt; gt; I have about 15 worksheets with similiar dimensions so when I format the
gt; gt; print on one sheet, the same formatting would apply to all 15 sheets. So
gt; gt; I
gt; gt; want to copy the print format from one sheet to all 15 sheets. The
gt; gt; numbers
gt; gt; on all the sheets are different.
gt; gt;
gt; gt; Thanks for your help
gt;
gt;
gt;