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

You can adjust the margins of one worksheet using print preview.

Then get out of that.
Group your worksheets and make sure that worksheet with the adjusted worksheets
is active.

Then back to File|Page setup and just hit ok on that Margins tab.

All the grouped sheets will get those adjusted margin settings.

Louise wrote:

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

--

Dave Peterson

Excellent, thank you.
Louise

"Dave Peterson" wrote:

You can adjust the margins of one worksheet using print preview.

Then get out of that.
Group your worksheets and make sure that worksheet with the adjusted worksheets
is active.

Then back to File|Page setup and just hit ok on that Margins tab.

All the grouped sheets will get those adjusted margin settings.

Louise wrote:

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

--

Dave Peterson