Regarding header and footer...

Hi all,

Is there any way in excel 2007 to define a standard header and footer on the first sheet and use the same header and footer for all the remaining sheets within the workbook (same font and style as in first page).

Since I have around 25 sheets within the workbook i cannot do formatting and copy paste all the time. This will save my time alot.

Thanks in advance...

Sathish.

Group-select all of the sheets (Ctrl+click) and then do Page Setup.