My post from this morning does not seem to have gone through, so I'll
repeat it here.

If you group the sheets together then you can make changes to one
which will affect all the others. To do this, right-click on a sheet
tab and select Group All Sheets. Then use Page Setup to set margins,
headers/footers etc and all sheets will reflect these changes. Don't
forget to Ungroup the sheets afterwards by right-cliking a sheet tab
again and selecting Ungroup sheets.

Hope this helps.

Pete

On Sep 3, 7:05*am, (Claudia d'Amato) wrote:
I have an Excel file with e.g. 20 whorksheets.
Now I want to change the page setup (for print) and the page margins.
As far as I can see I can do this only for ONE sheet at a time.

Is there really no way to change these options for all sheets
which currently exist in ONE (!) step ?

Claudia