View Single Post
  #4   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

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