MICROSOFT EXCEL
Add headers and footers to multiple worksheets
You can easily add headers and footers across multiple worksheets, saving you the hassle of doing so individually.
First, press the Shift key as you click the worksheets at the bottom ( in our screenshot). This selects them all. Now click the Page Layout tab at the top and click the small arrow at the bottom right.