how do i change headers on all workbook sheets globally?

[Guest]

I have a workbook with about 30 sheets in it and I would like to change the
header and footer of each sheet without doing it individually on each sheet,
can it be done once and globally change all headers and footers in the
workbook?

 

[Dave Peterson]

Lots of the page setup settings can be changed by grouping the sheets.

Click on the left most tab and shiftclick on the rightmost.

Then do your file|page setup stuff

And then ungroup the sheets--rightclick on one tab and select ungroup sheets.

 

[Guest]

Cheers mate, it worked a treat !