Working with Header and Footer

How can we insert header and footer to every worksheet without having to add in one by one? My workbook has over 50 worksheet and I need to add header for all these 50 worksheet.

Any good way to do it quickly?

Hi,

Select all the 50sheets ...Press Ctrl and click on all the sheets and then apply Header and Footer.

Originally Posted by Rahul Nagar

Hi,

Select all the 50sheets ...Press Ctrl and click on all the sheets and then apply Header and Footer.

Thanks Rahul...