Can you put the same header/footer on the entire workbook?

J

jackiemac1595

Is it possible to use the same header and footer for the entire workbook so
that I don't have to put it on each worksheet? I can't seem to find any
information on this.
 
P

Pete_UK

Jackie,

group all the sheets together (use Right-click on the tab) then do File
| Page Setup | Headers & Footers (tab) then Custom Header and set it up
how you want it and the same for Custom Footer. OK your way out of
this, and don't forget to ungroup the sheets at the end. Every sheet
will now have the same header and footer.

Hope this helps.

Pete
 
B

Bernard Liengme

lick on the tab for the first sheet; hold SHIFT and click on the tab for the
last sheet.
The tabs now all have the same 'colour' - the sheets are said to be grouped.
Use File | Page Setup, open the Sheet tab and set the headers and footers as
needed.
best wishes
 
Top