Can you put the same header/footer on the entire workbook?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to use the same header and footer for the entire workbook so
that I don't have to put it on each worksheet? I can't seem to find any
information on this.
 
Jackie,

group all the sheets together (use Right-click on the tab) then do File
| Page Setup | Headers & Footers (tab) then Custom Header and set it up
how you want it and the same for Custom Footer. OK your way out of
this, and don't forget to ungroup the sheets at the end. Every sheet
will now have the same header and footer.

Hope this helps.

Pete
 
lick on the tab for the first sheet; hold SHIFT and click on the tab for the
last sheet.
The tabs now all have the same 'colour' - the sheets are said to be grouped.
Use File | Page Setup, open the Sheet tab and set the headers and footers as
needed.
best wishes
 

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/Footer on entire workbook 4
how to apply the same header or footer to all sheets in workbook 1
Header/Footers 2
header/footer for the whole workbook 2
header and footer to appear on all sheets within the workbook 1
Can I duplicate headers and footers on multiple sheets? 2
How to change the footer only, on multiple worksheets in Excel? 1
Header and Footer 1

Back
Top