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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Header and Footer 5
Hide or Protect Headers 2
Headers & Footers _auto update info from a cell in the worksheet 4
Change Header & Footer Info w/ Worksheet Option Buttons 1
Header/Footer to update on all sheets 5
transferring headers and footers 1
Headers and Footers size 2
Insert file name in header without showing extension 1

Back
Top