cloning headers & footers in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2529654%22%20slang%3D%22en-US%22%3Ecloning%20headers%20%26amp%3B%20footers%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2529654%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20adding%20some%20pages%20to%20a%20workbook%2C%20I%20don't%20want%20to%20manually%20type%20out%20all%20the%20information%20I%20have%20in%20the%20footers%20%26amp%3B%20the%20headers%20-%20how%20do%20I%20copy%20those%20settings%20from%20existing%20pages%20to%20the%20new%20pages%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2529654%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2529753%22%20slang%3D%22en-US%22%3ERe%3A%20cloning%20headers%20%26amp%3B%20footers%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2529753%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F574563%22%20target%3D%22_blank%22%3E%40AprilW%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EUsually%20you%20create%20your%20headers%20and%20footers%20separately%20for%20each%20sheet.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EBut%20you%20can%20simplify%20your%20work%20%3A))%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ESo%20before%20inserting%20the%20header%20and%20footer%2C%20you%20can%20group%20the%20worksheets%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E(click%20on%20the%20tab%20of%20the%201st%20worksheet%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E-%20hold%20down%20the%20Shift%20key%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E-%20click%20on%20the%20tab%20of%20the%20last%20worksheet).%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3E%5BGroup%5D%20now%20appears%20in%20the%20title%20bar.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EAll%20settings%20and%20changes%20you%20make%20now%20will%20be%20transferred%20to%20the%20other%20worksheets.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20Community%20members%20reading%20here.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

I am adding some pages to a workbook, I don't want to manually type out all the information I have in the footers & the headers - how do I copy those settings from existing pages to the new pages?

3 Replies

@AprilW 

Usually you create your headers and footers separately for each sheet.

But you can simplify your work :))

 

So before inserting the header and footer, you can group the worksheets

(click on the tab of the 1st worksheet

- hold down the Shift key

- click on the tab of the last worksheet).

[Group] now appears in the title bar.

All settings and changes you make now will be transferred to the other worksheets.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

@NikolinoDE thanks, that is what I have done in the past, but that involves recreating them again, and each time it is the same information, just a pain in my butt

@AprilW 

Maybe a try with VBA :))

 

 

Option Explicit

Sub head_and_footer()
Dim wks As Worksheet, wks_def As Worksheet
Set wks_def = Sheets("YourWorksheet")
For Each wks In ThisWorkbook.Sheets
    With wks.PageSetup
        .LeftHeader = wks_def.PageSetup.LeftHeader
        .CenterHeader = wks_def.PageSetup.CenterHeader
        .RightHeader = wks_def.PageSetup.RightHeader
        .LeftFooter = wks_def.PageSetup.LeftFooter
        .CenterFooter = wks_def.PageSetup.CenterFooter
        .RightFooter = wks_def.PageSetup.RightFooter
    End With
Next wks
End Sub

 

 

 

Thank you for your patience and time.

 

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.