View Single Post
  #1   Report Post  
Master Yoda
 
Posts: n/a
Default Using same Header & Footer for Multiple Sheets in Excel

I want to use same header for multiple sheets in Excel, and only change a few
items in the header, or footer; i.e. summary of billing for separate
projects using the same content headers for the body of the sheet, but the
header changes to note a specific project. I can Copy & Paste the sheet
content and then modify from sheet to sheet; but I did not find a ay to copy
the Header & Footer from sheet to sheet without having to re-enter all the
Header/Footer info again. Can it be done??