Header and Footer in Excel

Occasional Visitor



Is it possible when already applied 1st sheet with Header & Footer, and added 2nd sheet, 3rd sheet, 4th sheet the Header & Footer also applied to that new sheet without manually added from Page Layout?


Is it possible?


Thank you!

1 Reply


Many roads lead to Rome...even more roads to a solution in Excel :).

Here are one suggested solutions.

Before inserting the header and footer, you could group the sheets

(click tab of 1st sheet - hold shift key - click tab of last sheet).

(Group) now appears in the title bar.

All settings and changes you make now will be transferred to the other spreadsheets.