Changes made directly on a sheet in a group will apply to all sheets in a
group. But the page setup (and other) attributes have to be set individually.

Here's a little macro code that would set all worksheets to the Fit to One
Page setting (both in height and width) at once. Use at your own risk <g
since you may not really want that on all sheets, which is why it doesn't
work on the group in the first place.

Sub OneTallOneWide()
Dim anySheet As Worksheet
For Each anySheet In Worksheets
anySheet.PageSetup.FitToPagesWide = 1
anySheet.PageSetup.FitToPagesTall = 1
Next
End Sub


"chanceygardener" wrote:

in the setup I want "fit to page" to apply to each sheet in the group. I
thought it did last year but this year when I group all the spreadsheet and
do a print preview then change the set up to "fit to page" it only change the
page I am viewing. When I click next, I have to click set up again and "fit
to page". I thought changes in the group applied to the whole group.