View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Can you put the same header/footer on the entire workbook?

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

jackiemac1595 wrote:
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.