The headers and footers will show up when you print the Excel spreadsheet including virtually printing it to a PDF file ... want to add a header or footer to all sheets, select every sheet ...

Quickly add a header or footer to every sheet in an Excel workbook Your email has been sent You don't have to add a header to every Excel worksheet individually when you can group them first.