Share via

Adding Headers and Footer to an Entire Excel Workbook

Anonymous
2011-06-16T18:34:57+00:00

I have an Eccel (2007) workbook with many sheets/worksheets. I want to add one header to all of the sheets. Can I do this in one addition?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2011-06-16T18:46:28+00:00

    Yes,

    I'm working with Excel 2010 and it's tabs, so hopefully 2007 has same options in roughly the same locations. (It does, I just checked on another system here with 2007 on it).

    Right-click on any worksheet's name tab and choose "Select All Sheets" in the list that appears.  Then go to the Page Layout tab on the Ribbon and open up the Page Setup group.  Choose the [Headers and Footers] tab and set up your custom header/footer.  It will appear on all sheets selected.

    When you are done, click on any single sheet's name tab to ungroup them because if you don't then anything you enter into the visible sheet will also affect all other selected sheets.

    20+ people found this answer helpful.
    0 comments

Answer accepted by question author

  1. Anonymous
    2013-08-27T10:42:05+00:00

    Yes,

    I'm working with Excel 2010 and it's tabs, so hopefully 2007 has same options in roughly the same locations. (It does, I just checked on another system here with 2007 on it).

    Right-click on any worksheet's name tab and choose "Select All Sheets" in the list that appears.  Then go to the Page Layout tab on the Ribbon and open up the Page Setup group.  Choose the [Headers and Footers] tab and set up your custom header/footer.  It will appear on all sheets selected.

    When you are done, click on any single sheet's name tab to ungroup them because if you don't then anything you enter into the visible sheet will also affect all other selected sheets.

     

    Worked perfectly! Thanks!

    TomWilliamsDupage

    Thanks sir, worked perfectly :)

    7 people found this answer helpful.
    0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-06-16T16:28:50+00:00

    Is there a way to add the same header and footer to all the sheets in a workbook other than doing it one by one?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2011-06-16T21:33:54+00:00

    The following reply (in "..") doesn't show a way to do what the original question asked (specifically, following the reply to the letter produces a header on only one of the worksheets, not for any other worksheet in the workbook)

    "Yes, you can.

    • Insert > Header & Footer
    • Customize as per your requirement

    The header & footer will be visible in "Page Layout" view (under View menu) and not "Normal" view. Again H & F will be visible during the print preview as well.

    If you don't want standard H & F then you can insert them by selecting all sheets together and inserting H & F manually. This will make sense if you have similar data layout across sheets."

    0 comments
  3. Anonymous
    2011-06-16T19:33:19+00:00

    Yes, you can.

    • Insert > Header & Footer
    • Customize as per your requirement

    The header & footer will be visible in "Page Layout" view (under View menu) and not "Normal" view. Again H & F will be visible during the print preview as well.

    If you don't want standard H & F then you can insert them by selecting all sheets together and inserting H & F manually. This will make sense if you have similar data layout across sheets.

    0 comments