You can't automatically to that for each new sheet added, but you can easily
apply the formatting from any sheet to all the sheets. With the sheet active
which contains the page setup you want, right-click the sheet tab and select
"Select All Sheets". Now simply go to File/Page Setup and then click OK in
the setup dialog. Now all sheets have the same page setup. Shift/click the
active sheet to ungroup the sheets and you're all set!

FYI, I'll be leading a LIVE 1-hour FREE webinar on tips & tricks on January
14 and again on Jan 27 from 4-5 PM est. It's done from your computer. To
find out more & register, go to http://www.iil.com, click on the yellowish
rectangle on the left "Try a free webinar", click the link for Microsoft
Tips & Tricks. Maybe I'll "see" you there!

Bob Umlas
Excel MVP

"ParTeeGolfer" wrote in message
...

How can I set up a header that was created on the first page of a
document
that was created. The header needs to be Formated with
boarders,color,font
and formulas? I would like this header to come up every time a new page
begins. I tried to cut and paste in header creation however this did not
work

Can this be done with footers including formulated cells?

EXAMPLE:
"Plainfield Rush Basketball Team
6th Grade Travel League"
2004 Season

Suggestions or HELP!