Header and Footer in Excel

Occasional Visitor

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!

1 Reply

@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.