Copy Page Setup across tabs

J

JWF

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
 
G

Guest

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!)
 
Top