In Excel, can I copy Headers and Footers between Worksheets?

G

Guest

It would save me a fair amount of time if I could copy headers and footers
between sheets. Then I would only need to change a minimum of data in the
heading or footer
 
G

Guest

Hi
if the worksheet with headers/footers is the first one try:
- select this sheet and the other sheets (hold down the CTRL key to group
them while selecting them)
- goto the 'File - Pagesetup' dialog
- commit with OK

Note: This does not copy only the header/footer but nearly all page settings
 

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

Copy headers and footers to other pages? 1
how to apply the same header or footer to all sheets in workbook 1
How do I set the default font for headers and footers in Excel? 1
How to change the footer only, on multiple worksheets in Excel? 1
Pasteing Word Doc into Excel with headers and footers 5
Headers and Footers by VBA? 6
Copy formatted text but not headers/footers 1
transferring headers and footers 1

Top