Try:
1. Record a macro (X) that does the formatting on one sheet 9assign to a key
stroke)
2. Run the macro on every sheet.

If you know a bit of VB, then instead of 2 above, write a macro (Y) to go to
each sheet and run X.

"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?