Forum Discussion
One Header - Show Report Filter Pages
the easiest way to do it is like this:
1. Select all sheets by right-clicking one sheet and chose "Select All Sheets"
Then it should look like this:
2. Goto menu "Page Layout" and klick on the little Page Setup icon on the right bottom corner:
3. Open the Header/Footer tab and click on "Custom Header..."
4. Enter all the desired information in the left, center or right section. If you want to include a picture, select the "Insert Picture" icon and choose the picture:
Please note, the all the headers are not directly visible in the different sheets, but in the print preview and on the printed documents.
But if you need them visible in the sheets, I guess there is no easy way to do it. So either insert them manually sheet by sheet (which I understand is a pain with 200+ sheets) or you have to find a VBA solution.