A
Alec
Is there an easy way of copying headers and footers
between sheets, other than writing VB code.
Thanks
Alec
between sheets, other than writing VB code.
Thanks
Alec
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
Jan Karel Pieterse
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
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
J
Jim Rech
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.
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.
A
Alec
Thanks Jan
Your solution works a treat.
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
.