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.
Thanks for such detailed and comprehensive review. I think with it I will able to study how to use it
That works great. Now how do you deselect all the sheets? I selected them all and added a footer to all of them. Then I started editing a page, went to the next page and found that what I had typed in the previous page was also on that page (and all the others!) I even closed the workbook and re-opened it, but everything I type on one page shows up on all pages!
I spoke too soon. I just figured it out - If I right-click on the sheet tab, one of the choices was to “ungroup sheets.” BTW, I also noticed that one of the choices was to select all the sheets - which would have been way easier than clicking on each one of the 40 sheets I had in the first place!
Thanks!
This is a great tip, but learnt is not a word.
Daisy, learnt is a word