customised header and footer

[Annette]

I want to save a header and footer that I have customised to use on more than
one excel sheet. It seems I have to keep typing it all, Help please

[cottage6]

Hi Annette, try this:
To create the same header or footer on all sheets in an Excel workbook
without having to set up the header or footer on each sheet individually, you
need to first group the sheets. To group sheets click on the first sheet you
want in the group, then hold your SHIFT key and click the last sheet you want
to include in the group. Any sheets in between the first and last sheet will
be included in the group. Then set up your header or footer, and all sheets
in the group will have the same header or footer. To ungroup the sheets when
you've finished, right-click on any sheet in the group and click "Ungroup
sheets."

"Annette" wrote:

> I want to save a header and footer that I have customised to use on more than
> one excel sheet. It seems I have to keep typing it all, Help please

[gm]

save file as a template type

"Annette" wrote:

> I want to save a header and footer that I have customised to use on more than
> one excel sheet. It seems I have to keep typing it all, Help please