Headers & Footers

  • Thread starter Thread starter Alec
  • Start date Start date
A

Alec

Is there an easy way of copying headers and footers
between sheets, other than writing VB code.

Thanks
Alec
 
Hi,

Group the sheets by clicking their tabs whilst holding the
control key. Make sure the sheet with the headers and
footers is the active sheet (name is Bold). Now "change"
the header/footer info.

Ungroup the sheets (righclick a tab, choose ungroup).

Regards,

Jan Karel Pieterse
Excel TA/MVP
 
When you "group" worksheets page setups entered for one of the grouped
sheets affect all of them. This would include headers and footers.

To group sheets Ctrl-click or Shift-click on their worksheet tabs. You'll
see "[Group]" in the workbook's titlebar.
 
Thanks Jan

Your solution works a treat.

-----Original Message-----
Hi,

Group the sheets by clicking their tabs whilst holding the
control key. Make sure the sheet with the headers and
footers is the active sheet (name is Bold). Now "change"
the header/footer info.

Ungroup the sheets (righclick a tab, choose ungroup).

Regards,

Jan Karel Pieterse
Excel TA/MVP

.
Click to expand...
 
Back
Top