I have a file that I continually add worksheets to. With each new worksheet
I have to reset the page set-up with regards to margins; header and footers
etc. I assumed that copying a correct worksheet to the new one would simply
copy over all my requirements but it doesn't.

Can this be done once in the file instead of each new worksheet

Thanks

Re: Dafaults for new Worksheets by Frank

Frank
Mon Apr 12 09:26:46 CDT 2004

Hi John
you can create a teplmate for new sheets/workbooks. Have a look at the
Excel help for 'Templates'

--
Regards
Frank Kabel
Frankfurt, Germany


John wrote:
> I have a file that I continually add worksheets to. With each new
> worksheet I have to reset the page set-up with regards to margins;
> header and footers etc. I assumed that copying a correct worksheet to
> the new one would simply copy over all my requirements but it
doesn't.
>
> Can this be done once in the file instead of each new worksheet
>
> Thanks


Re: Dafaults for new Worksheets by John

John
Mon Apr 12 12:42:26 CDT 2004

I don't think there is anything in Excel you don't know Frank!

Thanks again


"Frank Kabel" <frank.kabel@freenet.de> wrote in message
news:%238ZquoJIEHA.3044@TK2MSFTNGP10.phx.gbl...
> Hi John
> you can create a teplmate for new sheets/workbooks. Have a look at the
> Excel help for 'Templates'
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
>
>
> John wrote:
> > I have a file that I continually add worksheets to. With each new
> > worksheet I have to reset the page set-up with regards to margins;
> > header and footers etc. I assumed that copying a correct worksheet to
> > the new one would simply copy over all my requirements but it
> doesn't.
> >
> > Can this be done once in the file instead of each new worksheet
> >
> > Thanks
>