Copy Page Setup across tabs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Upper case only entries 2
Copy & Insert from another xls 1
Running a Macro a number of times 2
Insert sheet template loses page setup (2010) 2
End of File 1
Page Setup 2
Page setup whilst in Group mode 2
Problem after reinstalling Office 2007 with XP SP3 9

Back
Top