Header, footer, page set-up

[Kimba]

If I am creating a workbook with multiple sheets, how can I copy the
header, footer, and page set up to every sheet without having to format
the sheets individually? Thank-you

 

[Andy B]

Kimba

In normal view, group the sheets and make the amendments to one. This will
be reflected in all sheets. Don't forget to ungroup the sheets afterwards.

Andy.

If I am creating a workbook with multiple sheets, how can I copy the
header, footer, and page set up to every sheet without having to format
the sheets individually? Thank-you


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements