Insert header and footer on all sheets with Kutools for Excel Insert header and footer on all sheets with Select All Sheets function In this article, we will show you methods of inserting header and footer on all sheets, or applying the created header and footer in a specified worksheet to all worksheets in Excel. In some cases, you may need to insert header and footer on all worksheets at the same time without inserting them one by one. How to insert header and footer on all sheets in Excel?