Hi

Set one sheet up as you wish. Right click on its tab and select Group
Sheets. Go back into the Page Settings again and when you click OK it will
replicate these settings onto the other sheets.
Don't forget to Ungroup the sheets afterwards (right-click on one and select
Ungroup)

Andy.
(England!)
"JWF" wrote in message
...
Hi
This is Jane from Portbury, near Bristol (England).
I have Office 2000 on XP machine.
I would like to know if I can copy Page Setup formats across tabs, I don't
want the formats from the rows or columns, just things like, orientation,
margins etc.
Can anyone help
Thanks
xJane