View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Louise Louise is offline
external usenet poster
 
Posts: 217
Default Page setup whilst in Group mode

I want to change the setup on several worksheets to be identical (margins,
orientation etc) so I have grouped the worksheets and gone into File, Page
Setup.

This does work for orientation and scaling, however, when I want to change
the margins I have to enter the measurments on the actual Page Setup/Margins
tab because if I go int print preview, the settings are only applied to the
first worksheet.

Does anybody know of a way around this, or do I have to use the dialog box?
I know it sounds lazy but it's just much easier altering the margins in print
preview.

THanks.

Louise