Forum Discussion
Header and Footer in Excel
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 Pa...
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.