page set-up

[washaz]

I have a workbook with multiple worksheets. Does anyone know how you can
copy the page formatting (headers/footers, etc) from one worksheet to another?

 

[Dave Peterson]

Lots of print settings can be set if you group the worksheets first.

Select the first worksheet tab. Then ctrl-click on subsequent worksheet tabs.

Then do your page setup stuff.

This may change more than you want, so test the results.

And after you're done, ungroup the worksheets.

Rightclick on one of the selected worksheet tabs and select "ungroup sheets".

Otherwise, you could be making changes to each of the grouped worksheets for
things you don't want!