View original (French)

How to copy header and footer in excel

aurore -  
 Titi-21 -
Hello,

how to copy the header and footer from one Excel 2003 document to another?

thank you for your response

aurore

Configuration: Windows XP / Internet Explorer 8.0

2 answers

  1. Titi-21
     
    Hello,

    You can also save your headers and footers as a template (*.xlt) if you use them often.

    Best regards
    2
  2. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello,

    Several solutions to start with a copy-paste of the 3 parts of the custom header from one workbook to another.
    Or copy the sheet from one workbook to another and possibly clear it.
    Otherwise, through a VBA macro, but is it worth it if it's not a regular operation? We don't change a header every day...

    Explain the context, the why, and we'll see

    eric
    -1