Copy Header from worksheet

  • Thread starter Thread starter Lisa
  • Start date Start date
L

Lisa

Is it possible to copy the header used on one worksheet to
all of the worksheets within an Excel file?
 
The header under: file|Page setup|Header/footer tab?

You could group the sheets that you want to have the same header/footer
(Click on the "correct" worksheet tab and ctrl-click on the other tabs.
Then File|page Setup and click ok.

then right click on one of the selected worksheets and Ungroup Sheets.

But try it against a Saved version of your workbook. Other print settings will
be copied across, too. If you don't like all that changed, you can close
without saving.
 
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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Using VBA to copy data into another worksheet ??? 2
How do I copy a header and footer to multiple worksheets? 8
Copy a range data from 1 sheet to multiple selected sheets 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Excel Move or Copy Stopped Working? 0
Header/Footer 2
uniform headers on Excel worksheets 2

Back
Top