G Guest Nov 29, 2005 #1 How do I apply a custom header or footer to multiple worksheets in an Excel workbook? I'm in XP if that matters.
How do I apply a custom header or footer to multiple worksheets in an Excel workbook? I'm in XP if that matters.
D Dave Peterson Nov 29, 2005 #2 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.
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.
