We just learnt How to Insert header and footer in Excel from Office 2007 with all the available options and features. But more often the question asked is how to insert the same header and footer in all the Excel sheets from Office 2007?
The answer is simple, just multiple select all the sheets you want to have the same header & footer and insert or edit them.
So how to multiple select the Excel sheets?
In the bottom of the sheet you will find tabs for each sheet. Use the keyboard shortcut CTRL to select multiple sheets or if you want to select the series of sheets, you can use SHIFT key to select the first and the last one in the series which will select all the sheets in-between.
Now you can follow the steps in the post, How to Insert header and Footer in Excel 2007, to insert the same header or footer in all sheets.