If they're all different, you have to do it one at a time. If they're all
the same, you can select all sheets first (right-click the tab, select
"Select all sheets", and then do the page setup -- whatever you do will be
done for all. Make sure to UNgroup the sheets when you finish. Now the good
If you've already done one sheet and want to "copy" the page setup to
other sheets, again group the sheets, make sure the one with the desired
headers/footers is the active sheet, then simply use file/page setup and
click OK. Ungroup the sheets.
Voila!
Bob Umlas
Excel MVP
H.Sackner said:
How can you change headers/footers in Excel2003 where multiple worksheets
exist, without modifying each worksheet separately?
