Share via

Transferring headers and formats from one worksheet to another.

Anonymous
2010-04-07T15:47:28+00:00

Is there a quick way to transfer a custome header/ footer from one worksheet to another?  I have a detailed set-up that I would like to copy to a new worksheet without having to re-type the whole thing each time.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2010-04-07T23:38:18+00:00

    Right-click on the sheet tab, Select Move or Copy, make sure that 'Create a copy' is checked.

    That copies the whole sheet including header/footer.

    Alternatively, select all the sheets by holding the Shift key down and clicking the first and last sheet tab. Then you can edit the header for all sheets at once.

    Third method, does not work in XL 2003, but does in 2010 (and maybe in 2007). Hold the Ctrl key down and select (by clicking on the sheet tab) the sheet with your custom headers and the new sheet. Then edit the header footer (it will show your custom header) and click Ok. The custom header is now copied to the new sheet.

    Ed Ferrero www.edferrero.com

    30+ people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2010-04-07T23:39:05+00:00

    Right-click on the sheet tab, Select Move or Copy, make sure that 'Create a copy' is checked.

    That copies the whole sheet including header/footer.

    Alternatively, select all the sheets by holding the Shift key down and clicking the first and last sheet tab. Then you can edit the header for all sheets at once.

    Third method, does not work in XL 2003, but does in 2010 (and maybe in 2007). Hold the Ctrl key down and select (by clicking on the sheet tab) the sheet with your custom headers and the new sheet. Then edit the header footer (it will show your custom header) and click Ok. The custom header is now copied to the new sheet.

    Ed Ferrero www.edferrero.com

    0 comments