Header/Footer on entire workbook

[tonyalt3]

Does anyone know how to make a header/footer for an entire workbook
instead of having to do it for each sheet?

 

[krcowen]

Does anyone know how to make a header/footer for an entire workbook
instead of having to do it for each sheet?

If you group the sheets, right click on any sheet tab then click
"select all sheets", then anything you do will impact all the sheets.
After you have entered your header/footer information click a single
sheet to ungroup before you start doing stuff you only wand done on a
single sheet. Otherwise you will cost yourself more time than you
just saved in efficiently entering the header/footer information.

Ken

 

[krcowen]

Does anyone know how to make a header/footer for an entire workbook
instead of having to do it for each sheet?

If you group the sheets, right click on any sheet tab then click
"select all sheets", then anything you do will impact all the sheets.
After you have entered your header/footer information click a single
sheet to ungroup before you start doing stuff you only wand done on a
single sheet. Otherwise you will cost yourself more time than you
just saved in efficiently entering the header/footer information.

Ken

 

[Gord Dibben]

You can group the sheets as the other responder suggest but that will change
all the print settings(except print range and rows to repeat).

To change just the header or footer you can loop through the sheets using
VBA

Example code.

Sub Footer22()
For Each ws In ActiveWorkbook.Sheets
With ws.PageSetup
.LeftFooter = "&""Algerian,Regular""&16" & "This is my Footer"
End With
Next
End Sub

There is all kinds of stuff can be placed into a header or footer using
code.

If you have anything specific, post back with deatils.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

You can group the sheets as the other responder suggest but that will change
all the print settings(except print range and rows to repeat).

To change just the header or footer you can loop through the sheets using
VBA

Example code.

Sub Footer22()
For Each ws In ActiveWorkbook.Sheets
With ws.PageSetup
.LeftFooter = "&""Algerian,Regular""&16" & "This is my Footer"
End With
Next
End Sub

There is all kinds of stuff can be placed into a header or footer using
code.

If you have anything specific, post back with deatils.


Gord Dibben MS Excel MVP