format a 29 sheet workbook

J

JennB

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

crazybass2

Jenn,

Select all of the tabs (click sheet1 tab, hold shift, click sheet29 tab)
Then goto Page Setup. Format will follow for all tabs that are selected.

Mike
 
M

MikeDb

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.
 
D

Debra Dalgleish

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 File>Page 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
 
C

crazybass2

Debra - Good thinking. I should have expressed that warning. I've made a
mess of documents by forgetting that little tidbit.

Mike
 
Top