One way to copy headers and footers from a worksheet in one workbook to a worksheet in another is to use the traditional editing methods of copying and pasting. You can then create your workbooks based on this template and it will have the headers and footers you desire. Then, save the workbook as an Excel template (XLT format). Just set up a workbook as desired, including the specification of headers and footers. If the header and footer is one you use quite a bit in new workbooks, and your main concern is to have the header and footer available in those new workbooks (not in existing workbooks), then the best approach would be to create a template workbook. Doing so within a workbook is relatively easy, but doing so from one workbook to another can be more daunting. You may want to copy these headers and footers from one worksheet to another. Excel allows you to specify headers and footers for your worksheets.
