How do I copy print formatting to multiple sheets in a workbook?

[Guest]

I have a large Excel Workbook (96 worksheets) and I need to set ALL sheets to
the same print formatting (margins, page breaks, footers, etc).
Any ideas????

 

[Dave Peterson]

Lots of settings can be changed all at once if you group the sheets (select the
first and ctrl-click (or shift-click to select subsequent.

Then when all of the sheets are grouped, try file|page setup and see if you can
change all the settings you want.

Make sure you ungroup the sheets when you're done--almost any change you make to
one of the grouped sheets, you make to the others.

ps. You may want to try it on a few grouped sheets. If it works, then group
all 96.

 

[Dave Peterson]

ps. And if they are all the sheets in the workbook, you can rightclick on any
worksheet tab and choose "select all sheets"