Click on the first worksheet tab, and while holding down shift, click on the
last worksheet tab to group the sheets.

Then click FILE in the menu, select PAGE SETUP and click the HEADER/FOOTER
tab. Add your header as you normally would and it will be assigned to all
selected worksheets.

To ungroup the sheets right click on any worksheet tab and select UNGROUP.
--
Kevin Backmann


"Spyder" wrote:

Does anyone know how to add headers and footers to an entire workbook? OR do
I have to add the same header and footer to every single worksheet
individually?

Thank you for any assistance.
Jeff