Same Header on Different Sheets

[Tanya]

Is it possible to carry the same header and/or footers
from one sheet to another within an Excel worksheet
without having to re-type and format it for each sheet?
Any guidance would be greatly appreciated. Thanks much,
Tanya

 

[Frank Kabel]

Hi
one way:
- make the sheet with this header/footer the first sheet in your file
- select this sheet and the other sheets (while holding down the SHIFT
key -> grouping the sheets)
- goto 'File - Pagesetup' and simply press 'OK'

Note: this copies ALL pagesetup settings to the other selected sheets

In the same way you can set/change the header/footer for multiple
sheets within one workbook

 

[Jay]

Is it possible to carry the same header and/or footers

from one sheet to another within an Excel worksheet
without having to re-type and format it for each sheet?

One way is to start with an empty workbook. Select the Sheet1 tab, hold the
shift key, and click on the last sheet tab. Then type in the header and/or
footers. They'll appear in all the sheets.