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."
