As has been suggested, you can select all the sheets, and format them.
WARNING -- While the sheets are grouped, any changes you make to one
sheet will be applied to all the other sheets that are selected.
To select all the sheets quickly:
Right-click on any sheet tab
Choose Select All Sheets
Then choose FilePage Setup
Format the sheets, and click OK
When finished, ungroup the sheets, to prevent damage to the data:
Right-click on any sheet tab
Choose Ungroup Sheets
JennB wrote:
Can I go to Page Setup and set margins, or format, etc my entire 29-pg
workbook without having to make the changes to each worksheet individually?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html