Right click on the tab at the bottom of the sheet. Choose Move or Copy, put
a checkmark in create a copy, if you want the copy to be the last sheet,
highlight (move to end) and click OK - you now have a copy, header, footer,
formulas, formatting of the sheet.

"Jill E. Lingle" wrote:

How can I copy and then paste headers and footers from one sheet to another
and retain the formatting from the source sheet?