Custom header

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

Guest

How do I apply a custom header or footer to multiple worksheets in an Excel
workbook? I'm in XP if that matters.
 
Click on the first worksheet tab and ctrl click on the subsequent tabs.

Then do your page setup.

Remember to ungroup the sheets when you're done--if you make a change to a
worksheet that's grouped, you'll be changing the others in that group.

Just rightclick on one of the grouped worksheet tabs and select ungroup sheets.
 

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

PowerPoint Separate lines (line break) - PowerPoint Footer 1
Header/Footer 2
Page Setup for custom prints 1
How do I copy a header and footer to multiple worksheets? 8
Excel header how to automate for new worksheets 1
Default Workbook 12
What does the Header Footer add to filesize? 1
Excel Header and Footer 1

Back
Top