Header and Footer in Excel

[fandisticoo]

Hi,

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!

[#2]

@fandisticoo 

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.